Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to send a big string to sqlexec
Message
 
To
19/08/2007 23:19:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01249060
Message ID:
01249076
Views:
17
This message has been marked as the solution to the initial question of the thread.
Hi,

>I want to send a bing string to sqlexec (creating a SP or a new Database creation command).

Make sure that you test this with the back end you want to use. ODBC drivers have a maximum length for SQL statement that might be less than the script. For MS SQL server, for instance, the maximum length is around 120 KB. Other back ends have considerable smaller maximum size or do not ever allow multiple commands send in one SQLEXEC() line.
--
Christof
Previous
Reply
Map
View

Click here to load this message in the networking platform