Difference between revisions of "Base To-Do/Joins in dBase queries"
From Apache OpenOffice Wiki
Line 1: | Line 1: | ||
+ | === Description === | ||
+ | |||
Queries to dBase files can currently contain one table only. Scope of the project is to enhance Base' built-in simple query engine to be capable of executing statements line <code>SELECT table1.field1, table2.field2 FROM table1, table2</code>. The dBase driver, the text/csv driver, and the Spreadsheet driver would all benefit from this extension. | Queries to dBase files can currently contain one table only. Scope of the project is to enhance Base' built-in simple query engine to be capable of executing statements line <code>SELECT table1.field1, table2.field2 FROM table1, table2</code>. The dBase driver, the text/csv driver, and the Spreadsheet driver would all benefit from this extension. | ||
Line 8: | Line 10: | ||
* effort: 4 weeks for an experienced developer | * effort: 4 weeks for an experienced developer | ||
* difficulty: high | * difficulty: high | ||
+ | |||
+ | === Sketch === |
Revision as of 12:08, 8 October 2007
Description
Queries to dBase files can currently contain one table only. Scope of the project is to enhance Base' built-in simple query engine to be capable of executing statements line SELECT table1.field1, table2.field2 FROM table1, table2
. The dBase driver, the text/csv driver, and the Spreadsheet driver would all benefit from this extension.
Be prepared to dig around here before starting the project, the project touches low-level core implementations, including some heavy-to-read STL stuff, so be prepared to invest some time before writing the first line of code.
- required skills C++, SQL knowledge
- useful skills: Lexx and Yacc
- Contact: mailto:dev@dba.openoffice.org
- effort: 4 weeks for an experienced developer
- difficulty: high