General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only