Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DELETE command?
Message
From
19/01/2007 13:47:04
 
 
To
19/01/2007 13:44:40
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01187102
Message ID:
01187104
Views:
17
>How can I delete and take out the data in my table.dbf? I have this code and it only marked the data to be deleted, but did not remove it. What am I missing?
>
>Please help.
>
>Thanks,
>Sam
>
>
>DELETE FROM testdata ;
>WHERE testdata.serialnum = m.lcSerialNum AND ;
>	testdata.testdatewrk = m.ldDateWrk
>
You may remove records by using PACK, but you should not do it from main application flow. Use SET DELETED ON to ignore deleted records.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform