Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How may I change order of a field in a table ?
Message
 
 
To
08/11/2000 16:28:34
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00439283
Message ID:
00439423
Views:
14
>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
John, your response would have been more appropriate if aimed at the originator of the thread (Benoit Grenier) - not those that are attempting to offer help. For what it is worth, I agree with you - it seems like a lot of hard work, where none would seem to be essential. But then again, we do not know the whole background that motivated Benoit to post the initial request. You also don't help by using phrases like "why do you" instead of "why would one".
censored.
Previous
Reply
Map
View

Click here to load this message in the networking platform