Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating records in FoxPro tables
Message
From
08/10/2001 12:16:43
Leshel Rich
Plains Cotton Coop Assoc
Lubbock, Texas, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00565010
Message ID:
00565553
Views:
16
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform