> 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