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