Looking back, Fred, I seem to think that I, for one, have responded to this question before - on the 7th of Feb to be precise!
I have a command file that re-builds my databases with all the tables sorted in the sequence I like - it's yours for the cost of asking for it - it's a bit too big to post here. As I said previously: "I also like to re-build my databases at the turn of each year. As briefly discussed here earlier this year I do this by unloading the tables in a particular sequence (of tables) so that they can be reloaded to a new database without conflicts arising due to missing keys from tables that should have been loaded first. Since I have to unload the data anyway I do so with the ORDER BY clause that best suits each table for my needs. This, effectively, kills two birds with one stone: I get a clean database and its tables are pre-sorted." Regards, Alastair. ----- Original Message ----- From: Fred C Kopp To: RBASE-L Mailing List Sent: Tuesday, June 10, 2008 8:51 PM Subject: [RBASE-L] - Sorted tables What if I'm so anal retentive that I want to keep my tables sorted in certain ways? In 2.11 I simply ran a file that RENAMEd each table to Temp and PROJECTed a new, sorted table from Temp. Then I REMOVEd TABLE Temp and moved on to the next table. After all the sorted tables were projected, my file would BUILD KEY for each appropriate column in each appropriate table. A PACK or RELOAD removed the wasted space. But things have changed... PKs and other Restraints prohibit this naive approach. I don't even want to get into the errors I get. I want a single control file that sorts my tables and preserves / restores my Keys and Restraints. Doesn't seem all that unusual. How do I do it? Thanks, Fred Fred C. Kopp Authorized R:Base Developer 19 Teri Lane Washington, PA 15301 P 724-222-7376 F 724-222-7376 C 724-413-5534 E [EMAIL PROTECTED] ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.2.0/1493 - Release Date: 09/06/2008 17:25
