Michael Kraus wrote:
I already have that covered. Now consider how in embedded SQL you are
going to know the value of id when executing "INSERT INTO tablename
VALUES(null, ...)", where the table structure is (id INT UNIQUE PRIMARY
KEY AUTO_INCREMENT, ...)
Hence I need an identifier that the inserting process knows about to
grab a handle back to that exact row.
See LAST_INSERT_ID(), which returns the value of the newly-created
autoincrement field.
Cheers,
Glen
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
