>pdm.sqlmo = "Select amflib6.momast.ordno, fitem, fdesc, citem, isqty, ostat, opstc, wkctr, opseq From amflib6.momast" + >" Join amflib6.modata On amflib6.modata.ordno = amflib6.momast.ordno" + >" Join amflib6.morout On amflib6.morout.ordno = amflib6.momast.ordno" + >" Where fitem = '" + arg1.trim().toUpperCase() + >"'And (opstc = '20' Or opstc = '30') And isqty > 0 And ostat < 45"; >Don't use them as string, format as
TEXT TO lcSQL TEXTMERGE NOSHOW (Select amflib6.momast.ordno, fitem, fdesc, citem, isqty, ostat, opstc, wkctr, opseq From amflib6.momast Join amflib6.modata On amflib6.modata.ordno = amflib6.momast.ordno Join amflib6.morout On amflib6.morout.ordno = amflib6.momast.ordno Where fitem = '<<arg1.trim().toUpperCase() >> ' And (opstc = '20' Or opstc = '30') And isqty > 0 And ostat < 45) ENDTEXTfor readability.