Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Zap/Dele All - no packing
Message
De
01/03/2016 10:06:02
 
 
À
01/03/2016 09:16:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01632301
Message ID:
01632346
Vues:
56
>As I said - it DELETEs ALL therecords - it just won't pack, so it is seeing the correct table.

Not necessarily. The DELETE state of a record is not transient, so it may have been set before, nothing in the code you supplied is sufficient to assure that it is the DELETE ALL command that is in fact putting the deleted mark on records.
SET SAFETY OFF
SET EXCLUSIVE on
IF USED("Bookings")
  USE IN Bookings
ENDIF
USE Bookings IN 0 EXCLUSIVE
SELECT Bookings && make sure it's the correct work area
RECALL ALL && these 2 commands in sequence assure that it is this process that is actually deleting all the records
DELETE ALL
PACK
IF ISEXCLUSIVE( )
 MESSAGEBOX("Table opened exclusive (of course!)")
ELSE
  MESSAGEBOX("Not opened exclusively (this can't be!)")
ENDIF
SET EXCLUSIVE OFF
SET SAFETY ON
----------------------------------
António Tavares Lopes
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform