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: [email protected] 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
