Alistair, indeed, you have responded to this issue before and I have looked up
your message of 5/5/05. Why can something so simple in 2.11 be so complicated
in 7.6? All I want to do is sort my tables and leave my keys undisturbed. Am
I to understand that everyone else is content to leave their tables unsorted?
If so, I reluctantly bow to the majority, while I continue to search for a way
to defy it.
----- Original Message -----
From: Alastair Burr
To: RBASE-L Mailing List
Sent: Tuesday, June 10, 2008 6:08 PM
Subject: [RBASE-L] - Re: Sorted tables
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
