Hi Joy,

There's mskb #Q138094 How to Create Updatable Views by Using SQL Passthrough.

>I must be missing something. I am upscaling this app to a SQL back end. The TABLEUPDATE() AND SQLCOMMIT() values both return .T., but when I browse the remote view the updates are not there. Not sure if an intermediate cursor is confounding the issue. Here's the guts of the code:
>MULTILOCKS and BUFFERING =5 are in the load of the form

>SET STEP ON
>*** at this point the stat bar indicates that the cursor that populates a grid
>*** that filters the remote view is in the current work area
>nHandle =sqlconnect([MYsystemDSN])
>=sqlsetprop(nhandle, [Transactions], 2)
>=SQLExec(nHandle, [SELECT * FROM Mytable])
>*** the work-area cursor is now SQLresult
>=CURSORSETPROP('Tables', 'Mytable')
>=CursorSetProp([KeyFieldList], [Track_no], [Mytable])
>=CursorSetProp([UpdatableFieldList], listupdate, [Mytable])
>=CursorSetProp([SendUpdates], .T., [Mytable])
>=CursorSetProp([UpdateNameList], listFields, [Mytable])
>SELECT Mytable
>*** if the above line is used, the Watch window correctly indicates that
>***Mytable.claim_no gets changed using the REPLACE statements below to the new value that was changed on the form.
>***If it is commented out SQLresult.claim_no shows that it is
>***changed.  Neither case updates the back end.
>
>IF Thisform.mEdit= .T.
>	LOCATE FOR Track_no =Thisform.Track_no1.Value
>ENDIF
>	DO CASE
>	CASE Thisform.TermChk.Value	=.T. AND !EMPTY  Thisform.TermDate1.Value) ;
>			AND !EMPTY(Thisform.cbo_Term1.Value)
>			Thisform.Mr_Stat1.Value	=[T]
>		CASE Thisform.Mrchka.Value	=.T. AND !EMPTY(Thisform.Mr_apr1.Value)
>			Thisform.Mr_Stat1.Value	=[A]
>		CASE (Thisform.Mrchkd.Value =.T. AND !EMPTY(Thisform.Mr_Ref1.Value))
>			Thisform.Mr_Stat1.Value	=[D]
>		CASE (Thisform.Mrchkd.Value =.F. AND Thisform.Mrchka.Value =.F. ;
>			AND Thisform.TermChk.Value	=.F. AND !EMPTY(Thisform.Mr_Sent1.Value))
>			Thisform.Mr_Stat1.Value	=[W]
>		CASE Thisform.Mrchkd.Value	=.F. AND Thisform.Mrchka.Value =.F. ;
>		 AND EMPTY(Thisform.Mr_Sent1.Value)
>			Thisform.Mr_Stat1.Value	=[N]
>	ENDCASE
>
>	WITH Thisform
>		REPLACE Clinic_ID 	WITH .Clinic_ID.Value
>		REPLACE Group_ID 	WITH .Group_ID.Value
>		REPLACE Mr_Stat			WITH .Mr_Stat1.Value
>		REPLACE First_Name		WITH .First_Name1.Value
>		REPLACE Last_Name		WITH .Last_Name1.Value
>		REPLACE Init_date		WITH .Init_Date1.Value
>		REPLACE Claim_no		WITH .Claim_no1.Value
>		REPLACE From_Date		WITH .From_Date1.Value
>		REPLACE To_Date			WITH .To_Date1.Value	
>		REPLACE Init_refu		WITH .Init_refu1.Value
>		REPLACE Mr_Due			WITH .Mr_Due1.Value
>		REPLACE Mr_apr			WITH .Mr_apr1.Value
>		REPLACE Mr_ref			WITH .Mr_ref1.Value
>		REPLACE Recon_due		WITH .Mr_ref1.Value + cCarrlist.Recon_Days
>		REPLACE Mr_Sent			WITH .Mr_sent1.Value
>		REPLACE Treat_Cost		WITH .Treat_Cost1.Value
>		REPLACE DenyMedr		WITH .cboDenyMR1.Value
>		REPLACE Terminat		WITH .Termchk.Value
>		REPLACE TermDate		WITH .TermDate1.Value
>		REPLACE TermReas		WITH .cbo_Term1.Value
>		REPLACE DocCntrl		WITH .DocCntrl1.Value
>		REPLACE MRchka			WITH .MRchka.Value
>		REPLACE UPIN			WITH .UPIN1.Value
>		REPLACE Carrier			WITH .cboCarrier.Value
>		IF Thisform.Mrchka.Value	=.T.
>			REPLACE Appr_date	WITH .Mr_apr1.Value
>		ENDIF
>		REPLACE MRchkd			WITH .MRchkd.Value
>		REPLACE Cnn_MR			WITH .Cnn_Num1.Value
>		REPLACE Track_no		WITH .Track_no1.Value
>		mSuccess=TABLEUPDATE(2, .F., [Mytable])
>		If mSuccess
>			Messagebox([Table successfully updated],0+64,[Information])			
>		ELSE
>			Messagebox([Table not updated please check the code],0+64,[Information])
>		ENDIF
>		IF mSuccess
>			SQLSuccess= SQLCOMMIT(nHandle)
>			IF SQLSuccess =1
>				Messagebox([SQL COMMIT successfully completed],0+64,[Information])
>			ELSE
>				Messagebox([SQL COMMIT NOT completed],0+64,[Error])
>				ROLLBACK
>			ENDIF
>		ENDIF

>
>While still in the debugger, I can browse MysystemDSN!Mytable and see no changes, but strangely enough, if I issue a REPLACE claim_no with [AAAA], do a TABLEUPDATE() AND SQLCOMMIT() in the command window, the changes show in the back end.
>
>TIA for any help.