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/
