TEXT TO lcSQL NOSHOW TEXTMERGE SELECT f1.parent_id, f1.child_id, f1.statute_id, f1.startdate, f1.enddate, f1.isactive, f1.IsInjuredParty, f2.FNAME, f2.MNAME, f2.LNAME, f2.ADDRESS, f2.CITY, f2.STATE, f2.ZIP, f2.STREET, f2.PHONE, f2.SSN, f2.DOB, f2.SEX, f2.RACE, f2.DATEDIED, f2.PAYEE_ID, f2.ONPAYROLL, f2.PATIENTNO, f2.MC_INQ, f2.MC_ELIG FROM dbo.links f1 inner join dbo.claimnt f2 on f1.child_id=f2.claimnt_id and f1.ltype='CLCT' WHERE f1.parent_id=<<liCLaimID>> ENDTEXT intResults = SQLEXEC(This.DataSource, lcSQL , lcCursorName) AERROR(la1) IF intResults <0 AERROR(laError) MESSAGEBOX(laError[1,2]) _cliptext = lcSQL RETURN 0 ENDIF lnRecNoQuery=reccount(lcCursorName)fetches the data but when I GET NEW DATA with a new liCLaimID i get an error stating the cursor contains uncommitted data