Database syntax

[Pete]

I'm not sure I follow that logic :-)  What's the point of autoincrement if
he has to supply the primary key value and how does he get the next
available primary key value for the insert?

On Tue, Dec 20, 2011 at 12:50 PM, Bob Sneidar <bobs at twft.com> wrote:

> I should probably also mention that it would be better to set all your
> column values in the insert statement. Otherwise you will have to query for
> the last inserted primary key and use that in your next UPDATE statement's
> WHERE clause.




-- 
Pete
Molly's Revenge <http://www.mollysrevenge.com>