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--