Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete Command not working.
Message
 
 
To
11/02/2010 09:12:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01448767
Message ID:
01448777
Views:
48
>>>I have this class code which marks records in my record for deleting. It works Fine for every thing.
>>>but i have this table that is Set Deleted OFF. the problem is. when i delete something it gets marked for deleting. when i check the table. but it still shows up in my table when i run the form again... is there something im missing?cause its my only table that does that
>>
>>When you mark record for deletion in VFP, it doesn't disappear from the table. It is only marked and can be recalled. Only when you issue pack command (and this command requires exclusive access to the table) the record is physically gone.
>
>Yea i know that but when its marked isnt it NOT supposed to show up when i call the table ?cause when i mark other stuff they dont show up in the Exe but when i browse the tables i see the little black boxes by them.and i can pack when i need to. but im thinking because im using my tables DIRECTLY IN the exe its gonna show even if its marked or not

How are you displaying the records? If you don't want to show deleted records, use SET DELETED ON setting (put it in form's Load method).
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform