How do you know they won't do what you want to do? Have you given
up before you even try them? I have a form in which I can enter
information into a table and also has the results of a query based upon
that table. When I enter data into the table, the query updates itself.
Planning/Designing a database takes time. I gave you one way to get
what you wanted with some limitations. There are other ways to do it.
Sometimes it pays to have a good mathematical background to accomplish
what you want to do.
For example, you mentioned that you needed to know what date is a
specific number of days after a given day. You also mentioned needing to
know the difference between two dates. Base has a function DATEDIFF that
can be used to do both of these things. In the second one, you will need
a table that contains the beginning and ending dates. This function will
tell you the difference. In the first case, you need two fields: one for
the beginning date, and another field contains dates into the future for
the ending date. Then the query can use
DATEDIFF('dd',beginning date,ending date) = n where n is the
number of days.
With some time, I can probably create what you want. But then
again, I think I can do it. If you have a math background as it sounds
like you do, you should be able to do it also. But if you don't think
you can, you won't.
One more thing. Another thing. Base uses the HSQLDB database engine
version 1.8. The online User Guide is here:
http://hsqldb.org/doc/guide/guide.html. Chapter 9 has the built-in date
functions and how to use them. I could also send you a copy of the user
guide for HSQLDB 1.8. It is a PDF.
--Dan
On Wed, 2012-02-01 at 13:53 -0800, Jeffrey Needle wrote:
> Thanks so much. These are a help. Queries are good, but they don't
> end up doing what I really want to do -- just enter the data in a form
> and have the calculation done for you live. Other pages you offer give
> me some ideas. Many thanks again.
>
> ----- Original Message -----
> From: "NoOp" <gl...@sbcglobal.net>
> To: users@openoffice.org
> Sent: Wednesday, February 1, 2012 12:13:59 PM
> Subject: [users] Re: My database woes
>
> On 01/31/2012 06:02 PM, Jeffrey Needle wrote:
> > Using OpenOffice 3.2 on a Linux system.
> >
> > This may sound a bit like a whine; it's actually a plea for help.
> >
> > OpenOffice's database has some fine features, but, amazingly, you can't
> > do simple calculations -- especially date calculations -- in the
> > database module.
>
> Sure you can:
> <ttp://openoffice.blogs.com/openoffice/2007/03/creating_calcul.html>
> <http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_queries_and_reports>
> More:
> <http://www.google.com/#sclient=psy-ab&hl=en&source=hp&q=openoffice+%2Bbase+%2Bcalculations>
> and for dates, try:
> <http://www.google.com/search?sclient=psy-ab&hl=en&biw=1173&bih=675&source=hp&q=openoffice+%2Bbase+%2Bdate+%2Bcalculations&pbx=1&oq=openoffice+%2Bbase+%2Bdate+%2Bcalculations>
> Samples:
> <http://user.services.openoffice.org/en/forum/viewtopic.php?t=6754>
> <http://www.oooforum.org/forum/viewtopic.phtml?t=67907>
> <http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures#Date_and_Time_Functions>
>
> ...
>
> --
> -----------------------------------------------------------------
> To unsubscribe send email to users-unsubscr...@openoffice.org
> For additional commands send email to sy...@openoffice.org
> with Subject: help
--
-----------------------------------------------------------------
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help
