Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sending long SQL statements to VFP via OLEDB
Message
From
15/11/2001 20:26:48
 
 
To
15/11/2001 20:13:46
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00582403
Message ID:
00582485
Views:
24
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=MSALL
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform