Difference between revisions of "Documentation/DevGuide/Database/The SDBC Driver for Flat File Formats"
From Apache OpenOffice Wiki
< Documentation | DevGuide
OOoWikiBot (Talk | contribs) m (Robot: Changing Category:Documentation/Developers Guide/Database Access) |
m (should be flat) |
||
Line 14: | Line 14: | ||
For instance: | For instance: | ||
− | sdbc: | + | sdbc:flat:file:///d:/user/database/textbase1 |
Properties that can be set while creating a new connection. | Properties that can be set while creating a new connection. |
Revision as of 09:54, 18 March 2009
This driver is another basic driver available in OpenOffice.org API. It can only be used to fetch data from existing text files, and no modifications are allowed, that is, the whole connection is read-only. The URL for this driver is:
sdbc:flat:<folder or file url >
For instance:
sdbc:flat:file:///d:/user/database/textbase1
Properties that can be set while creating a new connection.
Properties of com.sun.star.sdbc.FLATConnectionProperties | |
---|---|
Extension | string - Flat file formats are formats such as:
|
Charset | string - Converts data from the ODBC driver into the corresponding text encoding. The value must be a value of the list from www.iana.org/assignments/character-sets. Only some are supported, but a new one can be added.
|
FixedLength | boolean - If true, all occurrences of "?" as a parameter name will be replaced by a valid parameter name. This is necessary, because some drivers mix the order of the parameters.
|
HeaderLine | boolean - If true, the first line is used for column generation.
|
FieldDelimiter | string - Defines a character which should be used to separate fields and columns.
|
StringDelimiter | string - Character to identify strings.
|
DecimalDelimiter | string - Character to identify decimal values.
|
ThousandDelimiter | string - Character to identify the thousand separator. Must be different from DecimalDelimiter .
|
Content on this page is licensed under the Public Documentation License (PDL). |