Difference between revisions of "Documentation/DevGuide/Database/The SDBC Driver for dBase"
From Apache OpenOffice Wiki
< Documentation | DevGuide
OOoWikiBot (Talk | contribs) m (FINAL VERSION FOR L10N) |
m |
||
| Line 58: | Line 58: | ||
* Parameters are allowed, but must be denoted with a leading colon (<code>SELECT * FROM biblio WHERE Author LIKE :MyParam</code>) or with a single question mark (<code>SELECT * FROM biblio WHERE Author LIKE ?</code>). | * Parameters are allowed, but must be denoted with a leading colon (<code>SELECT * FROM biblio WHERE Author LIKE :MyParam</code>) or with a single question mark (<code>SELECT * FROM biblio WHERE Author LIKE ?</code>). | ||
* The driver provides a <code>ResultSet</code> that supports bookmarks to records. | * The driver provides a <code>ResultSet</code> that supports bookmarks to records. | ||
| − | * The first instance of {{ | + | * The first instance of {{AOo}} API that accesses a dBase database locks the files for exclusive writing. The lock is never released until the {{AOo}} API instance, which has obtained the exclusive write access, is closed. This severely limits the access to a dBase database in a network. |
{{PDL1}} | {{PDL1}} | ||
[[Category:Documentation/Developer's Guide/Database Access]] | [[Category:Documentation/Developer's Guide/Database Access]] | ||
Latest revision as of 14:12, 21 December 2020
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
SELECTstatement can not contain more than one table in theFROMclause. - 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
ResultSetthat 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). |
