Lena:
Had to do the very thing. Backed up the OldTable using UNLOAD ALL FOR
OLDTABLE (to be safe) and used the Data Designer to insert NewColumn in
front of the NOTE column.
No problems.
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
------ Original Message ------
Sent: 7/28/2016 10:07:01 AM
Subject: [RBASE-L] - Columns Data Type of NOTE
From: "Lena Dammstrom" <[email protected]>
To: "[email protected]" <[email protected]>
Cc:
Hi all,
Using RBASE 9.5 (32) 9.5.5.30128
My predecessor, mentioned more than once; when you have tables with
Column(s) as Data Type NOTE; you should try to keep the NOTE column(s)
at the end of the table structure.
For table OldTable, NOTE column is at end of table, even thou many
fields have been added since the Note column was created.
So now I want to add another column NewColumn Currency to table
OldTable.
When I write a command ALTER TABLE OldTable ADD Column NewColumn
CURRENCY
It places the column at the end of table, after the OldNote NOTE column.
OldTable is an very wide table (currently 105 columns) with over 320,000
records.
OldTable is one of the main tables in the database, so it is highly
critical/used table.
Does keeping NOTE columns at the end table structure have any
advantages?
Is there a way to ADD a column between 2 existing columns?
1) GUI Tables\Design Table\Modify Existing Table – should work –
any issues with this method on a large table?
2) UNLOAD Structure A.Str, Unload Data, drop table, modify A.str to
add new column. Run A.str then reload data
Any insight/clues would be greatly appreciated.
Regards
Lena Dammstrom
Lena DammstromSoftware Developer Email: [email protected]
Free: 800-446-2500International: 01 630-529-7111Extension:
1037www.qmiusa.com
.
--------------------------------------------------------------------------------
This email may contain material that is confidential, privileged and/or
attorney work product for the sole use of the intended recipient. Any
review, reliance or distribution by others or forwarding without express
permission is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete all copies
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
