Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No Zap...No Pack ??
Message
 
To
27/11/2001 22:06:21
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00586764
Message ID:
00586767
Views:
16
>Is there a way to recycle deleted records?
>
>If so then that might preclude the need to zap or pack (or other workarounds)
>
>TIA
>Jere Dorough

You can, but you have to do it yourself.
Something along the lines of
cDel= SET('DELETED')
SET DELETED OFF
LOCATE FOR DELETED()
IF FOUND()
    * Recycle this record
    BLANK()
    RECALL()
ELSE
    * No deleted, so create new
    APPEND BLANK
ENDIF
SET DELETED (m.cDel)
I havnt tested the above code, but I know it is something like that, might need to add some more security etc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform