Good Morning Jozef!
What I do is to add a macro to the SELECTCMD like
.SELECTCMD = "SELECT * FROM MyTable &lcMacro'
There should exist no var named
lcMacro in the moment you execute the command above!
Before CursorFill and CursorRefresh set
lcMacro to a appropriate value, even to an empty string.
(This as well will do very dynamic WHERE clauses, that is what I use it for)
HTH
Agnes
>Hi !
>1.I want to change "order by ..." clause - included in cursoradapter SelectCmd property - based on a selection made by user. After making such change how should I refresh underlaying cursor ? CursorRefresh method seems not work in such case ( cursorFill works but it close the cursor and destroy grid layout).
>2. I wonder why it is not possible to make such things using parameters like it is in case of 'where ...' clause. Does anybody knows the reason.
>'Order by' clause look simpler than 'where ...' clause
>
>Thanks in advance.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]