Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving PKs from an inserted row (CursorAdapter)
Message
From
24/10/2003 10:47:50
 
 
To
24/10/2003 05:52:36
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00841822
Message ID:
00842127
Views:
28
Hi Agnes,

-------------
It's not that bug that frustrated me. I never run into it - I stopped befor. The problem is that I need to get next free PX, lock the next n records, APPEND / or INSERT. This will be not that tricky if I'm exclusive but I'm shared. The real problem is to get the next PX easy (AFIELDS is a kludge) and to set it n-steps forward, so that I 'own' those PX's. I know I can set next AutoInc with ALTER TABLE, but for the first im non exclusive, and for the second this will result in a DBC bloat. And I will insert some records not alter the table.
------------

This is not a VFP problem, this is a intrinsic InsertLock operation, on any implementation possible, you need to put a RLOCK(0) before the operation.

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform