INSERT INTO psCursor(itemid, rellev, partno, descptn) ;
Select 'x','1',cinbr,itdsc From getPSQuery Where itdsc Not In('TOOL','MO-ISSUE')>My list could get large, maybe 30 words.
>
>Here is a piece of code:
>
>
>getPSString = "SELECT cinbr, itdsc, ittyp FROM amflib6.pstruc" +;
>" Join amflib6.itemasa On amflib6.itemasa.itnbr = amflib6.pstruc.cinbr" +;
>" Where pinbr = '" + testQuery.cdaitx + "'"
>
>=SQLEXEC(testconn, getPSString, 'getPSQuery')
>
>SELECT getPSQuery
>
>SCAN FOR AT("TOOL", getPSQuery.itdsc) < 1 AND AT("MO-ISSUE", getPSQuery.itdsc) < 1
>
>INSERT INTO psCursor(itemid, rellev, partno, descptn, faiid, faistatus) ;
>Values(x, '1', getPSQuery.cinbr, getPSQuery.itdsc, "", "")
>
Edward Pikman
Independent Consultant
