Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>>>>>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).
>>
>>OHH thanks! u >all
>>but one thing. When i SET DELETED ON it would delete but show again when i load the form. but it doesnt when i set the buffering mode OFf :D
>
>Well, if you do your changes on buffered tables (and you should), then you should handle tableupdate /tablerevert in your code as well.
Yea i do have my update and revert code they work fine. when i disabled buffering...sometimes they dont thou...
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement