I am using the cursoradapter as a connection handler in my application. Now i would like to change the criteria of the query at runtime after the cursor is filled with the CursorFill method. In the help it states that one can change the selectcmd of the cursoradapter before refreshing the cursoradapter. But the cursor gets refreshed with the initial selectcmd.
Below is code i am using to refresh the cursor. What am i doing wrong?
** sGenericCA is a cursoradapter class which accepts as a parameters a table **name and it automatically generates the Cursor Schema, Updatelist,...etc.
oStocks = CREATEOBJECT('SGENERICCA','STK_LIST')
oStocks.SelectCmd = [SELECT * FROM STK_LIST]
oStocks.CursorFill()
Browse
** Till now everything works fine **
oStocks.SelectCmd = [SELECT * FROM STK_LIST WHERE STK_CODE = 'A']
oStocks.CursorRefresh()
** Now I put a message in the before cursor refresh method to display the
** parameter cSelectCmd but it still shows [SELECT * FROM STK_LIST]
Regards