Hi Steve
I have written a couple of articles on CA's using Mark's Builder at
www.foxite.com.
May help you out to read them.
Bernard
>Thanks Mark,
>
>This is my first time using a CA. I didn't realize that CursorFill had to be run for any new configuration. I like your Assign methods, just assumed that was sufficient to reset the SQL command and all I had to do was requery it. Works fine now.
>
>
>>When your Select command changes, you must use CursorFill to "re-execute" the query. CursorRefresh will always execute the select command used to create the cursor. The cSelectCmdFilter should be populated before the CA instanciates and the CursorFill fires. If you parameterize the filter and the only piece that changes is the value of the parameter, then the CursorRefresh works exactly like a Requery does on a view. The same principle for views applies to the CA in that if you open a local/remote view then change the SQL command used to create that view, just issuing a Requery on the view does not execute that new SQL. It still uses the SQL used to create that instance of the view. The CA is just a wrapper for all this functionality.