I used VFP 5.0 with relation to SQL Server 6.5 database.
On the VFP side, a table has a "memo" field, but SQL Server doesn't
have a memo type (therefore uses "Text" type).

When the memo field has more than 3 lines, upon updating into SQL
Server, it prompted error message related to ODBC problem. But if it
is restricted to not more than 3 lines, it is OK.

Any ideas of overcoming the problem? Thanks.