At 04:34 PM 11/2/2016, Dan Goldberg wrote:
I am trying to run a routine to rename a whole bunch of columns in a table.
I have the command:
rename column #3 to t1 in tmpgary nocheck
It throws an error.
But I can do:
browse #3 from tmpgary
update tmpgary set #3 = 0
Does anyone know how to reference a column number in a table to
rename that column?
FWIW ...
RENAMing a column is much different and complex engine routine than
BROWSing a column.
When RENAMing a column, R:BASE relational integrity checks are
performed as follows:
. Check to see if that column is INDEXed
. Check to see if that column is REFERENCEd (FOREIGN Key) to a
PRIMARY KEY Column
. Check to see if the changed column name and data type is in check
with existing
column name and data type, if any.
Optional NOCHECK parameter simply does not update references to
views, tables, and
columns in forms, reports, labels, access rights, and rules.
In your specific case, check the above, and if all seems OK, use the
actual column
name instead of "#3" and see what happens.
Hope that provides you with some blue's clues ...
Very Best R:egards,
Razzak
--
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.
