Hi all,

I want to change the following code to SQL statement :

sele table1
seek fieldnm
scan whil found()
   sele tabel2
   seek fieldnm
   vconv=iif(found(),nil_conv,1)  
   sele tabel1
   vqty_lkl=vqty_lkl+(qty * vconv)
ends

The above code will give a result eventhough the seek command in Tabel2 is not found 'Cause I give -> vconv=iif(found(),nil_conv,1).
I have tried using the SQL statement and if I seek only one record and it found in table1 but it can't be found in table2, the query result is empty.
I don't know how to translate this code (vconv=iif(found(),nil_conv,1)) into SQL statement, anybody knows ?

TIA,


Budianto