It will support a menu item added to the Base window and utilize a standard dialog box to interact with the user. This will include support for tables, views, and simple queries. The first release of the utility is being finished now. When a parameterized query is selected as the date source it should support an option of either prompting for the parameter values or using pre-loaded values. These definitions need to hold the all the necessary information to preform the export.
The Export Manager can be extended to support creating named export definitions. Additionally an Export Manager is being developed that will make use functionality with this library. The CSV Export utility must be available as a stand alone utility. For instance calling this from a button or menu on a data entry form. It also offers the option of being reused in other contexts. This approach not only allows us to use the built in support for parameterized queries, no need to rebuild something that can be tricky and already works. This will use the HSQLDB text feature to create the link, the transfer however would be implemented in basic using batch inserts to prepared statement. For complicated parameterized queries as well may well need a different approach.įor this second approach the utility will support exporting a rowset to a csv file. Performance is a critical factor, however, no more so then accuracy. The utility will support not only the export of complete tables and simple queries using a single DML commands. Where possible the utility to issue DML commands directly to HSQLDB, this should yield the best performance to writing a text file as. This page will report on the efforts to implement just this using OOBasic. Information on this activity, including the specification document, can be obtained from the Database project at the main web site, or HSQL Text Table Integration.Īdding a GUI to this inherent support should be a task well suited to the scripting capability built into Base. This feature is being actively developed for a future release.
Base at the moment, Release 2.0.4 and earlier, has not GUI interface to this functionality. The HSQLDB database manager employed by as the default database format offers another even more direct path.
Creating an export utility for embedded Base databasesĬurrently Base has no built in support for exporting data except to other documents.Īn indirect path to exporting data that is commonly used to to first drag a table or a query to Calc sheet.
0 kommentar(er)
