>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

You can add tablerevert(.t.,m.lcCusrorName) right before a new requery.