Article ID: 171668
Article Last Modified on 3/24/2000
* Start of the Code
CLEAR
CLOSE DATABASES ALL
SET MULTILOCKS ON
SET SAFETY OFF
SET TALK OFF
* Create the database and table
*********************************************************************
* NOTE: If the table is not in a database the problem does not occur.
* The following line can be removed to verify this behavior.
*********************************************************************
CREATE DATABASE test
CREATE TABLE test (CTest C(10) , NTest I)
INSERT INTO Test VALUES ( "one", 1)
INSERT INTO Test VALUES ( "two", 2)
INSERT INTO Test VALUES ( "three", 3)
INSERT INTO Test VALUES ( "four", 4)
CLOSE DATABASES ALL
USE Test SHARED
=CURSORSETPROP( "buffering", 5) && Optimistic Table Buffering
REPLACE NEXT 2 cTest WITH "test"
BEGIN TRAN
IF NOT TABLEUPDATE( 2, .F., "Test")
? "Failed."
ELSE
? "Committed."
ENDIF
END TRAN
IF ISFLOCKED( "Test")
* UNLOCK in test && Uncomment this line to test the UNLOCK command
? "The table is still locked."
ELSE
? "The table is not locked."
ENDIF
?ISFLOCKED()
* End of the Code
Keywords: kbbug kbfix kbvfp600fix kbprb KB171668