Scott,

We ran into similar problems and had to write code to pad empty memo fields with blanks. Of course, we then had to write code when returning said values from SQL to remove the blanks to not interfere with the user entry. It has something to do with the NULL settings on the SQL-side of the things (we believe). We tried setting it to accept null values, but that caused other problems within the database; sorry can't recall what they were now.

Renoir

>I have an application where the database is in Sybase. I have created a table with 2 fields. The first is CASE_NO and the second is COMMENTS. The "comments" field is a Memo type field. I have created a remote view to access the table. When I try to update the comments field I keep getting the following error:
>
>"Connectivity error (Intersolv ODBC SQL Server Driver) Invalid String or Buffer Length"
>
>Are there various advanced view options I need to change or is it something else?
>
>Thanks in Advance.
>
>Scott