Is the concatenated length of Col1 & ',' & Col5 larger than Col1 length?
This will give you the error message
-WARNING- New value will be truncated. (2570)
Hope this helps.
Richard Starkey
-------Original Message-------
From: [EMAIL PROTECTED]
Date: Thursday, September 19, 2002 12:11:10 PM
To: R:Base List
Subject: WARNING Message
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
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
