>>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
>
>Use CA instead of SPT cursor.

Actually, this is what I ended up doing. I didn't know if they would let me make this kind of change. But it went well. Thanks, both for your input.