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