It has the virtue of being able to query not only tables but also queries stored previously in the OOBase database. Probably the SQL CASE expression is unsupported or is different in the syntax.īase SQL Design View produces what we would call “bloated” code – double quotes around table names and field names, for example, and no short alias for a long table name. Simply pasting that part into the code generated by Base throws up untraceable errors. I have attempted to rebuild it using the SQL Design View method and can get it to work without processing the event date field but, using this method, there seems to be no way of incorporating the complex CASE structure employed for date processing. Opposingly, that query at the foundation of shared events for a couple would not work as it comprises multiple SQL commands. The error messages are useless and give no clue where to look.Įxtracting the query from AllFacts4Persons9.sql to return all events for the individual worked “out-of-the-box”, complete with very complex date processing, in the Run SQL Directly mode. It is not readily apparent what it is that allows a query to work in the direct mode and not in the OpenOffice mode. I think in this mode, the commands are syntax which may be limited to a subset of the SQLite command set. With the RUN SQL Direct mode turned off, most queries that work in other SQLite managers do not work when copied into the SQL View and run. semi-colon ( ) and apostrophe or single quote (‘) in comment.comment lines before the first SQL word.Single queries that have been developed using other SQLite managers work in many cases when copied into the Base SQL editor and run using the RUN SQL Direct mode some things that do not work: odb database with Open Office so that its tables and queries can be accessed in text and spreadsheet documents using Open Office Writer and Calc, respectively.īase has a graphic query design tool similar to that of MS Access as well as a direct SQL editor. odb file with Base.Īdditionally, like MS Office, one can register the. For later access to the SQLite database, one can open the. odb file is created, saving the connection information and stored SQL queries. Base can be connected via ODBC to a SQLite database in much the same way as has been described for Microsoft Access, using the same SQLite ODBC driver (See Part One of MS Access Engine). Open Office has a database program (Open Office Base) and a spreadsheet program (Open Office Calc).
0 kommentar(er)
