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