Two things are possible: 1) You are exceeding the size of the combo column
2) You are exceeding maximum row size which I believe is 4096 bytes in all fields. --------------------------------------- At 11:52 AM 9/19/2002 -0400, you wrote: >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 ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> ><HTML><HEAD> ><META http-equiv=Content-Type content="text/html; charset=windows-1252"> ><META content="MSHTML 5.50.4807.2300" name=GENERATOR> ><STYLE></STYLE> ></HEAD> ><BODY bgColor=#ffffff> ><DIV><FONT face=Arial size=2>Hello,</FONT></DIV> ><DIV> </DIV> ><DIV><FONT face=Arial size=2>I have not been active on the list for awhile but I >am stumped.</FONT></DIV> ><DIV><FONT face=Arial size=2>Thanks in advance for any help.</FONT></DIV> ><DIV><FONT face=Arial size=2>I am sorry this got so long but I am trying to >answer obvious questions you might have on this first go.</FONT></DIV> ><DIV><FONT face=Arial size=2></FONT> </DIV> ><DIV><FONT face=Arial size=2>I have expanded the size of several column in a >table.</FONT></DIV> ><DIV><FONT face=Arial size=2>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,</FONT></DIV> ><DIV><FONT face=Arial size=2><STRONG>-WARNING- New value will be truncated. >(2570)</STRONG></FONT></DIV> ><DIV><FONT face=Arial size=2>At first I thought it was the form but the same >thing happens when I do a direct edit without the form.</FONT></DIV> ><DIV><FONT face=Arial size=2></FONT> </DIV> ><DIV><FONT face=Arial size=2>The message only prints if ERROR MESSAGES is >set ON</FONT></DIV> ><DIV><FONT face=Arial size=2></FONT> </DIV> ><DIV><FONT face=Arial size=2>Things I have tried:</FONT></DIV> ><DIV><FONT face=Arial size=2> RELOAD Database</FONT></DIV> ><DIV><FONT face=Arial size=2> UNLOAD ALL FROM ><tablename></FONT></DIV> ><DIV><FONT face=Arial size=2> > DROP the table and use RUN <unload file> to >reinstate the table and data</FONT></DIV> ><DIV><FONT face=Arial size=2> PROJECT >table to <temptable></FONT></DIV> ><DIV><FONT face=Arial size=2> > DROP the original table and RENAME the temptable to >original table name.</FONT></DIV> ><DIV><FONT face=Arial size=2> </FONT></DIV> ><DIV><FONT face=Arial size=2>The warning message is displayed 3 times as I >exit or move from one line of data to the next.</FONT></DIV> ><DIV><FONT face=Arial size=2></FONT> </DIV> ><DIV><FONT face=Arial size=2>The command I used to consolidate the data from 2 >or more fields was</FONT></DIV> ><DIV><FONT face=Arial size=2>UPDATE TABLENAME SET COL1 = >(COL1 & ', ' & COL5)</FONT></DIV> ><DIV><FONT face=Arial size=2></FONT> </DIV> ><DIV><FONT face=Arial size=2>In this case, my intention was to move the data >from COL5 into the same field with COL1.</FONT></DIV> ><DIV><FONT face=Arial size=2>Everything seemed to work with the data. ></FONT></DIV> ><DIV><FONT face=Arial size=2>Strangely, I am not having the same problem with >another </FONT><FONT face=Arial size=2>table where I did the same >thing.</FONT></DIV> ><DIV><FONT face=Arial size=2></FONT> </DIV> ><DIV><FONT face=Arial size=2>Is this a DUH?</FONT></DIV> ><DIV><FONT face=Arial size=2></FONT> </DIV> ><DIV><FONT face=Arial size=2>Sharon Lima</FONT></DIV></BODY></HTML> > ================================================ 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/
