Re: Form question...

Hello Paul,

orbit wrote:
> Thanks for the note. I'm loosing confidence in OOo/Base 2.0 however as it
> seems to crash and recover the db file just about everytime I launch it.
> Infact, it lost the forms I had made. They were forms I had made while learning
> how to use the form designer and weren't deployed yet. I still haven't found
> any reference to multiple users in a lan environment using the same Base
> to manage the same database in realtime.

If I see right, you use the internal HSQL DB. This one can't be used as
a multiuser db.
If you want to use it in this way you need a database which can do it
e.g mysql, postgresql, oracle etc.

Mechtilde
> 
> So I have questions about how robust Base is. BTW, I'm running it in an
> Ubuntu Linux environment. Normally I steer clear of java based applications.
> Cheers,
> 
> --Paul T.
> 
> Frank Schönheit - Sun Microsystems Germany <[email protected]> wrote: Hi Paul,
> 
>> How are automatic calculations of fields in a form accomplished? I have
>> for example a 'rate-per-hour' (in dollars)  type of field that I would like to set
>> to a fixed value (and changeable easily when needed) and appear in the
>> record, then another field which is 'time billed' (in hours or parts of), then a
>> 'total cost' field. I would like the 'total cost' field to show the total cost based
>> on the values of the other two fields automatically.
> 
> You'd need macros for this. If this doesn't scare you, we could go into
> details ...
> 
> In general, you'd need to listen for changes in the fields which are
> used in the calculation, do your calculation, and update the target
> field. Not too difficult in general, but some lines of code ...
> 
> Ciao
> Frank
> 


-- 
Dipl. Ing. Mechtilde Stehmann
## Observer OpenOffice.org: lang/DE
## Freie Office-Suite für Linux, Mac, Windows, Solaris
## http://de.openoffice.org
## Meine Seite http://www.mechtilde.de
## PGP encryption welcome! Key-ID: 0x53B3892B