Add Nofilter.

SELECT * FROM psCursor INTO CURSOR psCursort NOFILTER

>In the following code the psCursort keeps growing and goes into an infinte loop. What is causing this?
>
>

>SELECT * FROM psCursor INTO CURSOR psCursort
>
>y = y + 1
>
>SCAN
>	
>getPSString = "SELECT pinbr, itdsc, ittyp, cinbr FROM amflib6.pstruc" +;
>" Join amflib6.itemasa On amflib6.itemasa.itnbr = amflib6.pstruc.pinbr" +;
>" Where pinbr = '" + psCursort.partno + "'"
>=SQLEXEC(testconn, getPSString, 'getPSQuery')
>	
>SELECT getPSQuery
>	
>Scan
>		
>INSERT INTO psCursor(itemid, partno, descptn, itemtype, childpn, olinelev, faiid, faistatus) ;
>Values(psCursort.itemid, getPSQuery.pinbr, getPSQuery.itdsc, getPSQuery.ittyp, getPSQuery.cinbr, ALLTRIM(STR(y)), "", "")
>	
>EndScan
>	
>EndScan
>
>