Sawadee,

I have a form that takes 2 parameters for the purpose of specifying a field and a value for an SQL statement that loads a grid.

parameters pcTom, pcJerry
local lcdate

lcDate = date()
thisform.grid1.RecordSource = ''
select * from mytable;
where &pcTom = &pcJerry;
and tdate = lcDate;
order by &pcTom into cursor cCursorUniq
thisform.grid1.RecordSource = cCursorUniq

If pcTom is a regular index, the select statement generates an error 'Cannot find variable pcTom'. If pcTom is not an index at all, the select statement does not err but, when I click the header(my code) for that field to set order to pcTom in the grid, it produces the error 'table has no index order set', as it should. Why does the select statement complain that it can't find pcTom if it is a regular index in mytable, then not complain when pcTom is not indexed? There must be something obvious I'm missing.

TIA,

Eric K.