Kevin,

Check http://weblogs.foxite.com/andykramek/archive/2005/03/19/174.aspx


>I'm using this to create a grid of search results. If no Station selected, then all records
>are shown. If a Station is selected, the the query's WHERE clause is changed to include it.
>
>The first time I run it, I see data in the grid, after that, the grid is empty even though
>the query returned data:
>
>

>** If no Station is selected and the Show Paid only checkbox is off, then
>** create a default WHERE clause
>IF EMPTY(.cboStations.DisplayValue) AND .chkUnpaid.Value = 0
>  cWhere = ".T."
>ENDIF
>
>** If a Station is selected, add it to the WHERE clause
>IF NOT EMPTY(.cboStations.DisplayValue)
>  cWhere = cWhere + " StatName = '" + PADR(.cboStations.DisplayValue, 10, " ") + "' AND "
>ENDIF
>
>** If the Show Paid only checkbox is on, then add it to the WHERE clause
>IF .chkUnpaid.Value = 1
>  cWhere = cWhere + " NOT Scanned AND "
>ENDIF
>
>** Remove trailing 'AND'
>cWhere = ALLTRIM(cWhere)
>cWhere = SUBSTR(cWhere, 1, LEN(cWhere) - 3)
>
>** Of no sort column was passed in, use the default columns.
>IF EMPTY(cSortOrder)
>  cSortOrder = "StatName, InvoiceId"
>ENDIF
>
>** Run the query
>SELECT StatName, InvoiceId, DoneDate, UserId, Scanned ;
>  FROM Commits ;
>  WHERE &cWhere ;
>  GROUP BY StatName, InvoiceId;
>  ORDER BY &cSortOrder ;
>  INTO CURSOR ReconData
>
>
>.BindControls = TRUE
>.Refresh()
>

>