Noor Jahan
15th October 2015, 08:28
Hi ,

I want to skip the record in selectdo and proceed to next record depend on some condition in Sql wuer

ex:

select tccom011.field
from tccom001
where ....

selectdo
IF CONDITION NOT SATISTY
SKIP THIS RECORD AND PROCEED TO NEXT RECORD
Selectempty
endselect

sachinbaan
15th October 2015, 08:34
Try this,

select tccom011.field
from tccom011
where condition
selectdo
if not <condition> then
continue
endif
endselect