PRB: CREATEOFFLINE Opens Parent Table Exclusively (165234)

MORE INFORMATION

In a multiuser environment where more than one work station is accessing tables, CREATEOFFLINE will open a table exclusively regardless of the setting of exclusive, and other users will not be able to open that table. They will get the message [ASCII 147]File Access is denied.[ASCII 148]

Steps to Reproduce Behavior

1. Run the following code to create a new subdirectory with a new database that contains a view of the customer table.

         SET DEFAULT TO HOME()
         OPEN DATABASE HOME()+"\samples\data\testdata"
         MKDIR offview
         SET DEFAULT TO HOME()+"offview"
         CREATE DATABASE OFFDBC
         CREATE SQL VIEW mycustomer AS SELECT * ;
            FROM HOME()+"\samples\data\customer"

2. Run the following code to make the view off line.

         CLOSE ALL
         CLEAR
         SET EXCLUSIVE OFF
         SET MULTILOCKS ON
         OPEN DATABASE Home()+"\samples\data\testdata"
         SET DEFAULT TO HOME()+"offview"
         OPEN DATABASE offdbc
         ?CREATEOFFLINE("mycustomer")
         SET

3. In the Data Session window, select customer. Notice that the status bar shows that customer is opened exclusively.
4. Run the following code to put mycustomer back online.

         CLOSE ALL
         CLEAR
         SET EXCLUSIVE OFF
         SET MULTILOCKS ON
         SET DEFAULT TO HOME()+"offview"
         OPEN DATABASE offdbc
         IF DBGETPROP("mycustomer","view","offline")
            ?DROPOFFLINE("mycustomer")
         ENDIF