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 > On Nov 17, 2018, at 8:55 PM, Buddy Walker <[email protected]> wrote: > > 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 > > On Nov 17, 2018, at 8:43 PM, Lin MacDonald <[email protected] > <mailto:[email protected]>> wrote: > >> 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 >> >> -- >> For group guidelines, visit >> http://www.rbase.com/support/usersgroup_guidelines.php >> <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] >> <mailto:[email protected]>. >> For more options, visit https://groups.google.com/d/optout >> <https://groups.google.com/d/optout>. > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- 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.
