something like :

lsql="SELECT Fld1,fld2,fld3 FROM mytable WHERE fld2= ?cParam"
lnResult=SQLEXEC(lnHandle,lsql,'tempTbl')

that will place it in a CURSOR

>Hello
>
>In a client-server environment , how can retrieve data from tables by SQL
>
>eg i have payfiles like PayJan03,payFeb03,PayMar03 and if the user select Jan 03 .. Apr03 how can select the data by SQL into a temp table ?
>
>TIA