I have found one case that gets you this error message. if you have a table with a text (1) column and have the null symbol set to -0- and the column in the table has null values If you do a unload the table and then load it you get this error message.
If you change the null symbol to a single character like ^ and then do the unload and then inout I don't get the message. In both cases the data in the table is correct, just the first method gets you error messages. Fred Antrobus On Tue, 2002-06-04 at 12:26, Troy Sosamon wrote: > Brad, > > I recomend that you put your notes in another table. You are probably > exceeding the row size limit on some of those notes. I would just make > another table with your key to wo, work_accomplished, and maybe > date/time/user stamps. I make it a habit to keep the notes isolated from > the rest of the data because when notes are edited, and change length, > sometimes R:base needs to move the row, and I have seen it corrupt the > database. > > To find all of the notes larger than 200 chars, do this: > > select * from wo where (slen(work_accomplished)) > 200 > > Troy Sosamon > Denver, Co. > > ===== Original Message from [EMAIL PROTECTED] at 6/04/02 12:35 pm > >RBase 2000 DOS 6.5++ Bld 1.851xRT03 - > > > >Have 132 column table (WO) with 25104 rows, with NOTE field > >(Work_Accomplished). When reloading database, altering table & adding > >columns, get error message: > > "Work_Accomplished will be truncated....". > > > >Am assuming this note field is causing row to exceed 255kb? Or? Is there > >a way to select those rows by column WO where the note field > >Work_Accomplished exceeds a predetermined value, say > 100kb? > > > >Any advice greatly appreciated - thanks! > > > >Regards, > >Brad Davidson > > ================================================ > 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/ -- -- Fred Antrobus -- [EMAIL PROTECTED] -- (425)235-7796 7796 6 ================================================ 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/
