Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Passthrough
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01033155
Message ID:
01033158
Views:
17
You cannot. See Can I pass a local fox cursor as an parameters into to sql s Thread #1032134 for orher was to achive the same result.

>Would you please let me know how I can use the
>Insert into [Table1] select * from [Cursor1] using a SQL passthrough method.
>
>I tried using the following statemnts
>
>= SQLPREPARE(nHandle, 'Insert into [Table1] select * from [Cursor1]')
>= SQLEXEC(nHandle)
>
>In the error log it says invalid parameter statement in the non-prepared SQL statement. Any idea?
>
>Thanks in advance.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform