Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating records in FoxPro tables
Message
De
08/10/2001 12:16:43
Leshel Rich
Plains Cotton Coop Assoc
Lubbock, Texas, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00565010
Message ID:
00565553
Vues:
17
Thanks so much for the suggestions. I have modified your code to look like this:
Select * from MyTable
where taxid = 'SUTATX'
set order to prempl
lprempl = Null
scan
IF lprempl = MyTable.prempl
Delete
ELSE
lprempl = MyTable.prempl
ENDIF
ENDSCAN

The table has two indexes, prempl and taxid. I want to delete the second taxid=SUTATX for each prempl. I am just learning FoxPro, so forgive my ignorance. When I run this code, I get some error and I don't know how to figure out what the error is.
Am I way off with this code?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform