Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL picking up deleted records
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL picking up deleted records
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01243304
Message ID:
01243304
Vues:
48
Hi

Im using row buffering then issuing a tableupdate which seems to come back successfully. IE I get .T.
Result=TABLEUPDATE(1,.T.,"RECTANGULARHEAD")
Then i'm deleting a record, then again
Result=TABLEUPDATE(1,.T.,"RECTANGULARHEAD")
Then when I do a
SELECT * FROM RECTANGULARHEAD WHERE !DELETED() INTO CURSOR TMPLIST
I get the record that I have just deleted included in my cursor?

I've got DELETED set to ON

Any help extremely appreciated
Rob
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform