Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How may I change order of a field in a table ?
Message
From
08/11/2000 16:28:34
 
 
To
08/11/2000 16:11:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00439283
Message ID:
00439398
Views:
20
The larger question here is, why do you wnat to do this? From a purist point of view, the position of records in a table doesn't make a difference. Why not use a view of your data for any sorted version you need. The hit in performance when you save, to call the data, sort it, generate a new table, save the data, remove the old table from the dbc, replace the old table with the new one and reconnect it to the dbc is not worth it in my opinion. Just use SQL.

Just my thoughts.

John
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform