Escape Artists

The Lounge at the End of the Universe => The Writing Forum => Topic started by: Unblinking on April 07, 2011, 02:21:37 PM

Title: OpenOffice Submissions Database
Post by: Unblinking on April 07, 2011, 02:21:37 PM
I've posted a freely downloadable submissions database, created in OpenOffice as an ODB file, for anyone who's interested:
http://www.diabolicalplots.com/?p=2069

It has forms for easy entry.  What it lacks is the ability to create certain reports based on queries.  I have an idea what the SQL queries would look like, but am not sure how to use OpenOffice to actually make them happen.  If anyone has experience with such a thing and would like to contribute I'd be much obliged.  (further details about what sort of queries are also at the link)
Title: Re: OpenOffice Submissions Database
Post by: kibitzer on April 08, 2011, 03:02:18 AM
I've posted a freely downloadable submissions database, created in OpenOffice as an ODB file, for anyone who's interested:
http://www.diabolicalplots.com/?p=2069

It has forms for easy entry.  What it lacks is the ability to create certain reports based on queries.  I have an idea what the SQL queries would look like, but am not sure how to use OpenOffice to actually make them happen.  If anyone has experience with such a thing and would like to contribute I'd be much obliged.  (further details about what sort of queries are also at the link)

Lemme take a look, see what I can do. Although I'll be doing it in LibreOffice ;-) I'll probably have the chance to check it over the weekend... that OK? pm me with an idea of what reports you want.
Title: Re: OpenOffice Submissions Database
Post by: kibitzer on April 08, 2011, 03:04:13 AM
OK just checked your post where you outline the reports so maybe don't worry about contacting me. Although do if you want to. Or don't. Or do.