On 2016-03-10 10:51, Stephen Russell wrote:
You may get the incorrect value back buy doing this:
So I'm thinking "how do I get something like VFP's old NextKey
generation"
akin to this:
* this was pseudo-code, off the top of my head trying to remember my
coding
from 17+ years ago
FUNCTION GetNextKey(tcTable as String) as Integer
<snip>
In the same insert statement you append ; select last_insert_id() ; and
it
returns YOUR value no matter what type of data column the key is. If
you
do some super fancy secondary select someone else may have gotten an
insert
in as well and your code returns their key, not yours.
Ah, I see it now. Sorry, I thought you were in SQL Server land with
your answer. Yes, that's MySQL. So that should work, right? Or can
this fail somehow if others are inserting simultaneously?
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
