>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.
>
>
>
Marcelo, is there anything in the cursor? May be it just didn't find the records meeting the criteria? Put SET STEP ON before the SQL and check the cursor, if there is nothing try to run it manually from the command window changing your parameters values.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison