Javier, Thanks for the tip, however, since we're unloading and reloading several thousand rows, impossible to review data before and after. Yes, cannot verify even if data is dropped from this note field (perhaps not really truncating, as notified in error message?).
Brad Javier Valencia wrote: > I have run into the same problem when loading text data that I know does not > exceed the length of the field. In looking at the loaded data, it did not > seem like anything was truncated. I have never been able to figure out this > message. > You may want to review the data that was loaded and compare it to the > original to verify that it was not truncated. > > Javier Valencia, PE > President > Valencia Technology Group, L.L.C. > 14315 S. Twilight Ln., Suite #14 > Olathe, KS 66062-4571 > (913)829-0888 > (913)649-2904 FAX > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Brad Davidson > Sent: Tuesday, June 04, 2002 1:35 PM > To: Rbase List Questions > Subject: Finding Length of Note Field > > 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/
begin:vcard n:Davidson;Brad tel;fax:909-736-4699 tel;work:909-736-4690 x-mozilla-html:FALSE url:www.aero-craft.com org:Aero-Craft Hydraulics, Inc.;Customer Support adr:;;392 North Smith Avenue;Corona;CA;92880-6971;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Manager fn:Brad Davidson end:vcard
