Difference between revisions of "fpdbfexport"
From Free Pascal wiki
Jump to navigationJump to search (Created; to be fleshed out more on working with module.) |
(Added known bugs) |
||
| Line 1: | Line 1: | ||
| − | = Overview = | + | == Overview == |
The fpdbfexport module is part of the FreePascal FCL database modules. | The fpdbfexport module is part of the FreePascal FCL database modules. | ||
This export module provides export to DBF formats (e.g. DBase IV format). This format is still popular because it is simple, and - opposed to e.g. csv - is clear about what data type is enclosed in its fields. | This export module provides export to DBF formats (e.g. DBase IV format). This format is still popular because it is simple, and - opposed to e.g. csv - is clear about what data type is enclosed in its fields. | ||
Many spreadsheet and database programs can import DBF files. | Many spreadsheet and database programs can import DBF files. | ||
| − | = Example = | + | == Limitations and known bugs == |
| + | In FPC 2.6.2 (e.g. supplied with Lazarus 1.0.8), exporting to e.g. dbase IV format - that has a 10 character field length limit - of fields with longer field names will throw an error unless you populate the export fieldname mapping yourself. | ||
| + | |||
| + | This bug has been fixed in FPC trunk revision 24490 | ||
| + | See [http://bugs.freepascal.org/view.php?id=24423] | ||
| + | |||
| + | == Example == | ||
To do: write a DBF test for the FCL tests and refer to it here. | To do: write a DBF test for the FCL tests and refer to it here. | ||
[[Category:Databases]] | [[Category:Databases]] | ||
| + | [[Category:FPC]] | ||
Revision as of 12:04, 13 May 2013
Overview
The fpdbfexport module is part of the FreePascal FCL database modules. This export module provides export to DBF formats (e.g. DBase IV format). This format is still popular because it is simple, and - opposed to e.g. csv - is clear about what data type is enclosed in its fields. Many spreadsheet and database programs can import DBF files.
Limitations and known bugs
In FPC 2.6.2 (e.g. supplied with Lazarus 1.0.8), exporting to e.g. dbase IV format - that has a 10 character field length limit - of fields with longer field names will throw an error unless you populate the export fieldname mapping yourself.
This bug has been fixed in FPC trunk revision 24490 See [1]
Example
To do: write a DBF test for the FCL tests and refer to it here.
