>>>Hi All:
>>>
>>>How do I requery a grid? In other words, my rowsource is SQL with a WHERE clause, so every time the condition changes I want to requery. There is no requery on a grid.
>>>
>>>Refresh doesn't seem to do the job.
>>>
>>>Yossi
>>
>>The best solution will be in using safe select approach.
>>
>>See http://weblogs.foxite.com/andykramek/archive/2005/03/19/174.aspx
>
>Hi Naomi,
>
>I referred to an answer you gave me a few years ago.
>
>My problem is I'm not changing the WHERE; I'm changing the columns. I still want to stay with safe select, however, since I might want to add fuctionality to modify the WHERE as well.
>
>This is the code I'm trying to run in the CLICK of an option group:
>
>

>DO CASE
>CASE THIS.option1.VALUE = 1
>	lcCustomerColumns = GenerateColumns('')
>CASE THIS.option2.VALUE = 1
>	lcCustomerColumns = GenerateColumns('FAIR')
>ENDCASE
>
>lcSql = "SELECT curStock.desc, " + lcCustomerColumns + " FROM curStock"
>THISFORM.safeselect(lcSql, "curGrid")
>thisform.gridrefresh()
>

>
>The problem is that the cursor that the grid is bound to (curGrid) doesn't change its columns.
>
>Thanks
>
>Yossi

I don't understand your question. If your curGrid may change columns and you want all of them to be displayed in a grid, then you would not be able to use safe select approach unless you want to have a cursor with all possible number of columns first and only display columns conditionally. In other words, you can have a curGrid with, say, 20 columns and grid setup with 20 columns bound to that cursor. In run-time when you re-select your rows, if you don't want some columns, you make them invisible in a grid.