In VFP 7 i'm using view with macro in where clause.
For example:
In view -

SELECT * FROM Products WHERE &?lcSQLWhere

In code -

lcSQLWhere = "Products.nProducer_ID = 11"
= REQUERY()

It's work fine.
Now i'm planning to use CA. I don't want to use macro substitution in it.

I have a questions:
I understand so, that changed SelectCmd don't affect in CursorRefresh method? That is to say if i use This.SelectCmd = "SELECT * FROM Products WHERE Products.nProducer_ID = 11" in CursorFill, after change SelectCmd to "SELECT * FROM Products WHERE Products.nProducer_ID = 10" and call CursorRefresh, CA anyway use SelectCmd used in CursorFill.

Therefore, i must use CursorFill with new SelectCmd to update cursor if i want to use new SelectCmd?
For example:

This.SelectCmd = "SELECT * FROM Products WHERE Products.nProducer_ID = 10
This.CursorFill
This.SelectCmd = "SELECT * FROM Products WHERE Products.nProducer_ID = 20
This.CursorFill (instead of .CursorRefresh)

But if cursor binded to a Grid, after CursorFill it unbinded.
How can i use CursorRefresh?
Any ideas?

My english at last 50% understandable?
With regards,
Michael.