RAD Studio |  |

Controlling Read/Write Access to Local Tables
See Also
Collapse All

Like any table type dataset, TTable lets you control read and write access by your application using the ReadOnly property.

In addition, for Paradox, dBASE, and FoxPro tables, TTable can let you control read and write access to tables by other applications. The Exclusive property controls whether your application gains sole read/write access to a Paradox, dBASE, or FoxPro table. To gain sole read/write access for these table types, set the table component's Exclusive property to True before opening the table. If you succeed in opening a table for exclusive access, other applications cannot read data from or write data to the table. Your request for exclusive access is not honored if the table is already in use when you attempt to open it.

The following statements open a table for exclusive access:

Copy Code

    CustomersTable.Exclusive := True; {Set request for exclusive lock}
    CustomersTable.Active := True; {Now open the table}

Copy Code

    CustomersTable->Exclusive = true; // Set request for exclusive lock
    CustomersTable->Active = true; // Now open the table

Note: You can attempt to set Exclusive on SQL tables, but some servers do not support exclusive table-level locking. Others may grant an exclusive lock, but permit other applications to read data from the table. For more information about exclusive locking of database tables on your server, see your server documentation.
See Also

Specifying a dBASE Index File

Renaming Local Tables

Specifying the Table Type for Local Tables

Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!