Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Le 12/09/12 01:25, Girvin R. Herr a écrit :

Hi Girvin,

I did discover that LO requires the dBASE filename to end in ".dbf", not
".DBF" as I started with.  So, LO is case sensitive in this instance.

Yes, that is true. There has been a previous thread on allowed
characters and extension names of DBF files in this user list, some time
ago, it will be in the archives of the mailing list.

I started to look at the Base options and discovered View -> Refresh
Tables.  Clicking on it produces my dBASE database namess in the Tables
section.  I looked up "refresh tables" in help, but all it says is
"Refreshes the tables".  Duh!  However, editing the table produces a

For stuff like that, the built-in help is next-to-useless, unfortunately.

blank page with no structure entries.  Opening the table produces the
SQL errors: "The data content can not be loaded.  The query can not be
executed. It contains no valid table.".  If I click on "More", I get the
errors: "The data content could not be loaded.", "SQL Status: HY000  The
query can not be executed. It contains no valid table." and the
information: "The SQL command leading to this error is:  SELECT * FROM
"pintosw""  (where "pintosw" is my dBASE database file "pintosw.dbf").

You might find that you actually have to save the ODB file, shut down LO
and restart it completely (including any quickstarter if you are on
Windows). The refresh button doesn't seem to perpertuate the refreshed
table schema to the ODB configuration file, which is why you then get an

Additionally, LO only supports DBF from dbf III+ and dbf IV from what I
recall, but Andreas might know more about that than I do, so if your
DBFs use an earlier version, then they probably won't be recognised by LO.


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.