Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating records in FoxPro tables
Message
 
To
05/10/2001 16:50:58
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:
00565015
Views:
16
Say you have a table xyz with a an id field named id type char.

USE xyz
RECALL ALL
INDEX ON Id TAG Id UNIQUE

SET ORDER TO Id
DELETE ALL

SET ORDER TO

BROWSE FOR DELETED()



>I have some dupe records that are causing me problems and I need to delete one of the dupes for each record in several tables. Is there a way to do that without deleting each individual record by hand? Is there a way to do it using the command line?
What ben makes tracks for what wil be. Words in the air pirnt foot steps on the groun for us to put our feet in to.

Riddley Walker
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform