Unbind the grid: RecordSource = ""
Run the CursorRefresh
Rebind the grid

>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.