Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Indexing error confusing
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement