How do I obtain the id of the result of the last Insert statement without a second query?
I am aware I could select the last row of the database to get what I'm looking for... sometimes. The issue is if two users are inserting at the same time I'm worried that they may get the wrong results.
Pseudo Example Code:
User 1 - Insert Record A
User 1 - Select last Record
User 1 - Record A Selected
Pseudo Multi-user Problem:
User 1 - Insert Record A
User 2 - Insert Record B
User 1 - Select last Record
**User 1 - Record B Selected**
User 2 - Select last Record
User 2 - Record B Selected