>I am using a customer framework has a method that creates a vfp updatable cursor for a sql server backend table. It builds the cursor that sets the properties using a series of cursorsetprop commands.
>
>The customer wants me to use this this method but it has one restriction that I can't seem to work around. I need one parameter. Basically I need to be able to requery after changing the value of the parameter variable.
>
>But when requerying I get the same 1504 error. "Function not supported for SQL pass-through cursors."
>
>Other than re-writing the framework, which is not an option, is there some way to utilize this updatable cursor and support parameters at the same time?
>
>TIA


Dan,

I'm afraid there is no easy way of doing this. You will have to run SQLPREPEARE/SQLEXEC and CURSORSETPROP all over again. You can use existing connection handle though.


Cheers,

Zoran