Sami, Thanks for the help, I changed the data type to VarChar and one record I was having trouble with worked fine. Is the moral to this story use VarChar instead of Note? Tom Hart
----- Original Message ---- From: Sami Aaron <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, February 18, 2008 9:06:53 AM Subject: [RBASE-L] - RE: DB Memo Tom – You don’t say which version of R:BASE you’re using, but if it’s version 7.6 or lower, there is a limit of 4,096 characters per record (Turbo B-8 has increased it to 32,768). If your table has multiple note fields, it’s possible that the couple of records you’ve encountered that have this problem have gotten to the limit on line length. If that’s the case, you could change them to VARCHAR fields and remove the line length limitation. Sami ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of TOM HART Sent: Sunday, February 17, 2008 4:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - DB Memo I have a form that has a DB Memo field, using a Note column. Most of the time the Memo works fine, but occassionally when I type in a long string of text it will only save the first 3 or 4 characters. I can delete all the data in the field and still won't let me put in more characters. The problem is erractic. I can go edit the data in the table and put in a long string, go back to the form and everything is fine, but if I make any change in the DB Memo it Spazzes out. Example: Today is such a nice day, etc................... Will only save: Toda Previous and next customer will work fine Tom Hart
