Robert:
The fastest, simplest way to do it is to do an UNLOAD ALL to a text
file, then modify the column definitions in the text file
OUTPUT utility_changeColumnWidth.rmd
UNLOAD ALL
OUTPUT SCREEN
RBEDIT utility_changeColumnWidth.rmd
... make all your changes, save, and then:
1) Change the extensions of your existing .rx? file e.g:
database.rx1.old ... .rx4.old
2) RUN utility_changeColumnWidth.rmd
Done, and, you end up with a free backup of your database.
Best, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012 m
------ Original Message ------
From "'Robert Thompson' via RBASE-L" <[email protected]>
To [email protected]
Date 1/21/2025 3:48:51 PM
Subject [RBASE-L] - Column definition
I have "Column A" defined as TEXT 12 in about 20 tables. I now need
to
expand that to TEXT 25.
I know how to manually make the changes and it is not very efficient,
so
I thought I would ask if there is an option or process that I may have
missed in some update over the years!
So.... is there a straight forward way of changing a column text length
definition across the database?
Thanks,
--
Robert Thompson
TTC. Inc.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
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].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/ef51c380-731b-4e0e-8b2e-886327601e4f%40comcast.net
<https://groups.google.com/d/msgid/rbase-l/ef51c380-731b-4e0e-8b2e-886327601e4f%40comcast.net?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
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].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/em71657adc-3f99-4299-887e-1a6e606134d2%40828a53f2.com.
