This one time, at band camp, 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.

Our code does this by selecting the next value from the sequence, then
inserting in to the table with that sequence as the ID.  Thus, the
uniqueness of the row ID is guaranteed.

-- 
[EMAIL PROTECTED]                           http://spacepants.org/jaq.gpg
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Reply via email to