>Hi,
>
>I am trying to refresh a cursor adapter after changing the value in .SelectCmd property. But something does not work.
>
>Here is my code:
>
>
>cSqlSelectExpression = "select * from MyTable where 1=1"
>*-- oConn is the connect object (already exist)
>oRS = oConn.Execute(cSqlSelectExpression)
>*-- ca_object is the CursorAdapter object already existing
>ca_object.DataSource = oRS
>ca_object.CursorRefresh()
>
>
>But when I check the resulting cursor it has no records.
>
>What am I missing? TIA.
No, if you change SelectCMD you should run CursorFill() not CursorRefresh().
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.