I have this code.When SQL finishes nothing happens.My listbox stays empty.I check it with the debugger and the two passed parameters have the correct values.What´s wrong ?


LPARAMETERS tcPeriodo, tcAño

IF PARAMETERS() < 1
RETURN .F.
ENDIF


SELECT * ;
FROM mytable a ;
WHERE a.field1 = tcperiodo ;
AND a.field2 = tcaño ;
INTO CURSOR c_names

thisform.lstConsultas.Requery()

IF _tally > 0
thisform.lstConsultas.ListIndex = 1
ENDIF

Note : I put the rowsource of the listbox to cnames and rowsourcetype to Alias.

thanks in advance.