Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete Command not working.
Message
 
 
À
11/02/2010 09:28:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01448767
Message ID:
01448783
Vues:
29
>>>>>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.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform