This is not a limitation of VFP and SQL, it is a limitation of the VFP ODBC driver. One suggestion would be to create a VFP COM object, pass it your parameters, and have it do the updating to get around the problem.


>Does anybody know of a workaround for inserting more than 255 characters into a VFP memo field with SQL? I am invoking an SQL statement from within an Active Server Page but the problem can also be demonstrated from within the Command Window of VFP (v. 6.0)
>
>The code I have is similar to this:
>
>
>;memovalue = "now is the time for all good men to come to the aid of their party"
>;
>;SQL = "INSERT INTO test (memofield) VALUES ( '" & memovalue & "')"
>;
>;REM 'Insert our new record into the table'
>;set conn = server.createobject("ADODB.Connection")
>;conn.open "DSNentry"
>;REM 'Created a link to the table...'
>;
>;conn.execute(SQL)
>;REM 'record added'
>;conn.close
>;SET conn = Nothing
>;
>
>This works perfectly fine just as long as "memovalue" never is larger than 255 characters. It doesn't appear to matter how long the entire SQL statement is just as long as no one value parameter is longer than the character limit.
>
>Any help would be greatly appreciated.
>
>Thanks in advance,
>
>David Pizon
>pizond97@mio.uwosh.edu
>Lead Webmaster
>Management Information Office
>UW Oshkosh