Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete Command not working.
Message
 
 
À
11/02/2010 08:56:37
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:
01448771
Vues:
55
>Hello!
>
>IF (MESSAGEBOX('Are you sure you want to delete this client',1,'Delete')) =1 then
>  if thisform.Value = 1
> 	messagebox('Cannot DELETE a record! Only READ access is granted!', 16, 'Security Alert')
> else
>	delete
>	go top
>	messagebox('Record deleted successfully!', 64, 'Information')
>	thisform.refresh()
> endif	
>	ELSE
>	return 
>	
>endif
>
>
>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.
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