Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Very Bad Bug in VFP5.0 and VFP6.0 !!!
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00171436
Message ID:
00171727
Views:
35
Christof and Folks,

I do it this way (recycling deleted records);
LOCAL lcAlias, lcOrder, lcDeleted
lcAlias = ALIAS()
SELECT DesiredTable

lcDeleted = SET("DELETED")
lcOrder = ORDER()

SET ORDER TO Dels && my idex on deleted

GO BOTTOM
IF DELETED()
   * Reuse it
ELSE
   * Make a new one
ENDIF

SET DELETED &lcDeleted
IF NOT EMPTY( lcOrder )
   SET ORDER TO &lcOrder
ELSE
   SET ORDER TO 0
ENDIF
IF NOT EMPTY( lcAlias )
   SELECT (lcAlias)
ELSE
   SELECT 0
ENDIF
Previous
Reply
Map
View

Click here to load this message in the networking platform