General information
Category:
Visual FoxPro and .NET
>>I believe VFPOLEDB is multiuser and multithread safe.
>>
>>If you pass 0 to GETAUTOINCVALUE, it is similar to scope_identity(). Help is pretty clear on this: "0 Specifies that the last autoincremented field value returned is derived from the current scope (function, method, procedure)." Connection is a scope. Therefore, additional synchronization should be used if you execute INSERTs and GETAUTOINCVALUE(0) on different threads at the same time through the same connection (no difference with scope_identity() here).
>
>So, basically, both approaches would be safe in this case. So, that would mean that as long as the connection to the adapter is valid, using this function would return the incremental key value of the last insert. In such situation, do you recomment the first approach or the event handler approach?
Could you elaborate what approaches you are referring to?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only