On 08/02/2006, at 1:18 AM, Frank Schönheit - Sun Microsystems Germany
wrote:
Hi Cor,
The idea is to have a XML formdocument, that is defined to make
connection with various databases via the internet (HTTPS).
In general, the UI does not offer database access in XML forms. The
underlying core could mix those two, but as already mentioned in the
thread, not without additional scripting.
You could for instance imagine a XML form document which is
connected to
a "normal" XML instance. This instance data can be submitted to the
inter/intranet using the normal submissions. This is all there in
XML forms.
Additionally, this document could contain another logical form (see
the
form navigator window from the "Form Design" toolbar) which is
connected
to a database - this other form has to be created manually, but
probably
only once, it should be persistent.
For retrieving the actual database data - well, anything would do here
as long as your database provides. So, if you have a, say, ODBC driver
which allows you HTTPS-access to your actual database, then you could
use this driver in an OOo database form.
In general, it sounds like you might need quite some scripting,
depending on the concrete interactions you want to have.
<advertissment>
If it's an alternative to do this in Java (which is not as
straight-forward as in Basic, but more powerful), the you'd have even
more possibilities.
For instance, you could imagine small Java components which implement
validation of the form control's content, where invalidity would be
indicated by a red border around the control, and a freely
customizable
tooltip.
Or, you could implement an own value binding [1] for the form
controls,
which allow them to exchange data with every location you like, not
only
the built-in XML instances or database connectivity.
All of this is there in the underlying core implementations, but only
limited visible in the UI.
</advertisement>
Ciao
Frank
[1]http://api.openoffice.org/docs/common/ref/com/sun/star/form/
binding/ValueBinding.html
Hi Frank,
Thanks for this information. It is something I will probably look
into further,
when I get a chance :-)
Regards
Jonathon
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
