Thank you again. These are very useful information.


>>Thank you for the feedback Aleksey.
>>
>>Again, I have additional questions on your feeback.
>>
>>1. Does this mean that I don't need to call the SQLPREPARE() function?
>>
>>>You should set "Prepared" property for the view:

>>>DBSETPROP("viewname","VIEW","Prepared",.T.)

>>>
>
>Actually, cursorsetprop("Prepared", .t., 0) should work too if it is set when CREATE SQL VIEW command is executed, but it doesn't affect USE command.
>
>Back to the question. You don't have to call SQLPREPARE, it is called internally when USE command for the view is executed. After that the command stays prepared and ready to use by REQUERY, no additional calls to DBSETPROP or CURSORSETPROP needed.
>
>
>>2. When parameters change, how do I "prepare" the backend result? Do I issue another DBSETPROP() or CURSORSETPROP() before REQUERY()?
>>
>
>See above.
>
>Thanks,
>Aleksey.