>>>I use cursoradapter class and set property RefreshCMD = [select * from order where sno = 'DN001'],
>>>then use cursorrefresh ,I find in the BeforeCursorRefresh event ,the parameter cSelectCMD is [select * from order] ,and RefreshCMD do not work.
>>> Is there some way to solve this?
>>>
>>>thanks
>>
>>Hi Lu,
>>
>>What are you trying to accomplish? RefreshCmd property is used by RecordRefresh method, not by CursorRefresh method. CursorRefresh method always executes the same command that was executed by CursorFill method. If command executed by CursorFill had parameters, CursorRefresh uses their current values. If you want to use different command, you should change SelectCmd property and execute CursorFill method.
>>
>
>Hi Aleksey,
>
>With this insufficient design the requery of many sql commands is impossible,
>and with CursorFill() it needs to unbind every grid connected to the cursor,
>redefine indexes, set filters, set relations, cursorsetprop() ....
>
>Enable BeforeCursorRefresh to update the selectCMD.
>Believe me, you will do happy many of us.
>
>Thanks.
>
>>Thanks,
>>Aleksey.

Hi ,Fabio Lunardon
I agree with you !Cursorfill should remove indexes and relation ..and grid recordsource...,
if CursorRefresh work with dynamic parameters WHERE condition ,that is great!