>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?