>Funny to reply to myself, but in case anyone else is wondering about this issue, I found what appears to be part of the solution on the MS Knowledge base.
>
>According to the Knowledge Base, VFP can only accept SQL strings from a SQLEXEC statement if the statement contains no strings greater than 255 characters. The article says that to create a longer SQL statement, you should concatenate smaller strings together into a larger statement.
>
>However, that doesn't seem to help anyone sending SQL statements from ASP. I would still appreciate any thouhts. Thanks.
>
>The URL is:
http://support.microsoft.com/support/kb/articles/Q163/8/00.asp?LN=EN-US&SD=gn&FR=0&qry=Visual%20FoxPro%20SQL%20Statement%20255%20characters&rnk=3&src=DHCS_MSPSS_gn_SRCH&SPR=MSALLJosh,
I think you really found the answer yourself but overlooking it. From ASP it would work too. ie: With a VBScript :
Assuming str1,...str5 are strings no longer than 255.
"insert into myTable (nfield1,cLongInput) values (1,'"_
& str1 & "'+'" & str2 & "'+'" & str3 & "'+'" & str4 & "'+'" & str5 + "')"
Cetin
