[RBASE-L] - RE: last inserted id

[Javier Valencia]

Alan: Try the following:   INSERT INTO your_file (your columns…)  VALUES( your values…) SET VAR vlast_id = last_id IN your_file where count = INSERT   Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================   -----Original Message----- From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of Alan Wolfe Sent: Wednesday, April 19, 2006 12:50 PM To: RBASE-L Mailing List Subject: [RBASE-L] - last inserted id   Hey everyone,   I was wondering if there was a way to where if you insert a row into a table with an auto incremented column to get the last id# inserted?   I know you can do a sel max(column) but in the case of multiple people hitting the database at the same time, the sel max might return the id of someone else if the requests overlapped.   TIA! Alan