Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating records in FoxPro tables
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00565010
Message ID:
00565089
Views:
24
>Say you have a table xyz with a an id field named id type char.
>
SET DELETED OFF
>USE xyz EXCLUSIVE
>DELETE ALL
>INDEX ON Id TAG UniqueId UNIQUE
>
>SET ORDER TO Id
>RECALL ALL
>DELETE TAG UniqueID
>SET ORDER TO
SET DELETED ON
I made few corrections. It's important to note, that this solution requires exclusive use of the table, while Sergey's solution doesn't require it.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform