>Hi all,
>
>I have a program that is working on a sql server database via updateble views.
>Now i have a problem updating my view with the following code :
>(tablebuffering is set to 5)
>
>BEGIN TRANSACTION
>SELECT pos_s_invoice
>replace status WITH 5,doc_no WITH m.nCurrentFacId
>IF NOT TABLEUPDATE(2,.T.,'pos_s_invoice')
> ROLLBACK
> RETURN .F.
>ELSE
> MESSAGEBOX('updated')
> END TRANSACTION
>ENDIF
>
>Afther the 'end transaction' my table is still locked. Does anybody know why ?
>
>thnx

The transactions of VFP don't check the transactions of SQL server.

BEGIN TRANSACTION
SELECT pos_s_invoice
* next open a SQL trans session
replace status WITH 5,doc_no WITH m.nCurrentFacId

IF NOT TABLEUPDATE(2,.T.,'pos_s_invoice')
  =SQLROLLBACK(CURSORGETPROP("ConnectHandle")
  ROLLBACK
  RETURN .F.
ENDIF
 =SQLCOMMIT(CURSORGETPROP("ConnectHandle")
 END TRANSACTION
 MESSAGEBOX('updated')