Hello,
I have not been active on the list for awhile
but I am stumped.
Thanks in advance for any help.
I am sorry this got so long but I am trying to
answer obvious questions you might have on this first go.
I have expanded the size of several column in a
table.
Then I used the update command to consolidate
the data from a few columns into the one that was expanded. Everytime
I do an edit, I get the following error message,
-WARNING- New value will be truncated.
(2570)
At first I thought it was the form but the same
thing happens when I do a direct edit without the form.
The message only prints if ERROR MESSAGES
is set ON
Things I have tried:
RELOAD Database
UNLOAD ALL FROM
<tablename>
DROP the table and use RUN <unload file> to
reinstate the table and data
PROJECT
table to <temptable>
DROP the original table and RENAME the temptable to
original table name.
The warning message is displayed 3 times as I
exit or move from one line of data to the next.
The command I used to consolidate the data from
2 or more fields was
UPDATE TABLENAME SET COL1 =
(COL1 & ', ' & COL5)
In this case, my intention was to move the data
from COL5 into the same field with COL1.
Everything seemed to work with the data.
Strangely, I am not having the same problem
with another table where I did the same
thing.
Is this a DUH?
Sharon
Lima
