>>We have a problem in saving memo fields. If a small amount of data is placed in a memo field then everything is ok. However, a large amount of data in any memo field causes our tableupdates to fail for Oracle or SQL Server. Visual FoxPro works fine, regardless.
The data type for the memo fields is as follows:
VFP: Memo
SQL Server: Text
Oracle: VarChar2(2000)<<
Matt,
The basic issue is that is you send 2001 characters to the varchar2(2000) field, the update will fail because you sent too many characters. What you need to do is to develop a valid() routine that checks the amount of characters and truncates it to 2000.
I believe Oracle 8 allows a varchar2(4000) now which may help out.
Kevin