On 12/11/2009 08:00 AM, Jonathan Kaye wrote:
jomali wrote:
Thanks John. My macros are extremely specific to a given task and could only
be created via a macro programming language (such a the variety of basic
used in openoffice). I use the dbms supplied by openoffice (mysql?). I have
not been able to find any mention of how to use macros created in openoffice
for calculated fields. I guess it can't be done.
Thanks again.
Jonathan
If you do this one field at a time, then I expect that you will call
your macro from a Form. The macro would then be triggered by the form as
the data is entered.
It sounds like you might be referring to something like a stored
procedure that is called when another field is updated directly in the
DB. This will be dependent on the DB used.
Your other option, which may not be practical, is to write a macro that
uses SQL to read the data, then use the macro to write it back out to
the "calculated" field.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
