[libreoffice-users] Re: dBASE file access

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
error.


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.


Alex



-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted