The SDBC Driver for dBase
From Apache OpenOffice Wiki
The dBase driver is one of the basic driver implementations and supports the service com.sun.star.sdbcx.Driver. This driver has a number of limitations concerning its abilities to modify the database structure and the extent of its SQL support. The URL for this driver is:
sdbc:dbase:<folder or file url>
For instance:
sdbc:dbase:file:///d:/user/database/biblio
Similar to the SDBC driver for ODBC, this driver supports the connection info property CharSet
to set different text encodings. The second possible property is ShowDeleted
. When it is set to true, deleted rows in a table are still visible. In this state, it is not allowed to delete rows.
The following table shows the shortcomings of the SDBCX part of the dBase driver.
Object | create | alter |
---|---|---|
table | ||
column | ||
key | ||
index | ||
group | ||
user |
The driver has the following conditions in its support for SQL statements:
- The
SELECT
statement can not contain more than one table in theFROM
clause. - For comparisons the following operators are valid:
=
,<
,>
,<>
,>=
,<=
,LIKE
,NOT LIKE
,IS NULL
,IS NOT NULL
. - Parameters are allowed, but must be denoted with a leading colon (
SELECT * FROM biblio WHERE Author LIKE :MyParam
) or with a single question mark (SELECT * FROM biblio WHERE Author LIKE ?
). - The driver provides a
ResultSet
that supports bookmarks to records. - The first instance of Apache OpenOffice API that accesses a dBase database locks the files for exclusive writing. The lock is never released until the Apache OpenOffice API instance, which has obtained the exclusive write access, is closed. This severely limits the access to a dBase database in a network.
Content on this page is licensed under the Public Documentation License (PDL). |