Yes, it is used elsewhere so I'll fix that.Thank you!!LinSent from Samsung
tablet
-------- Original message --------From: [email protected] Date:
2018-11-18 5:20 AM (GMT-08:00) To: Digest recipients
<[email protected]> Subject: [RBASE-L] - Digest for
[email protected] - 3 updates in 1 topic
[email protected]
Google Groups
Topic digest
View all topics
changing a column's length? -
3 Updates
changing a column's length?
Lin MacDonald <[email protected]>: Nov 17 05:43PM -0800
Hello,
I had to change a column's length to accommodate a very long last name.
The table contained a computed column that concatenated the first and
last name. To change the last name's length, I had to delete the
expression on the column that did the concatenation. Now, I can't put it
back. When I do, the table refuses to save. Am I missing something?
thanks!
Lin
Buddy Walker <[email protected]>: Nov 17 10:55PM -0500
Lin
Make sure the length of the computed column is at least the same as the
total length of the two columns. Also make sure the concatenated column name
isn’t in any other table if so the length has to be the same.
Buddy
Sent from my iPhone
Albert Berry <[email protected]>: Nov 17 10:23PM -0700
Using your column name
LIST COLUMN ComputedColumnName
You just might have it in a reporting table
If that is so, then alter table xxx DROP ComputtedColumnName until you have one
instance, then ALTER TABLE yyy ALTER COLUMN ….
ALTER TABLE xxx ADD ComputedColumnName …
Albert
Back to top
You received this digest because you're subscribed to updates for this
group. You can change your settings on the group membership page.
To unsubscribe from this group and stop receiving emails from it send an
email to [email protected].
--
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].
For more options, visit https://groups.google.com/d/optout.
