i have a form in VFP with the data in SQL (used to be in VFP) with this cursoradaptor method:

			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
I am not updating in this form it's just a query form

what am I doing wrong???


Thanks

Peter