General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only