I have a main form and a sub form.
The main form holds one single record, the sub form contains multiple records related to the record
in the main form.
Both forms are holding alphanumeric and also pure numeric data.
I wrote a macro to evaluate and calculate the numeric data in the sub form and deposit the results
in fields of the main form.
Now my problem: The numbers placed in the main form fields by means of the macro are not recognized
by the back end MySQL database. These simply are not transferred, whatever I do. (If I write some
figures in manually, the same are being transferred without problem.) What can I do to work around
this problem? Is there any kind of trick that makes the form believe that the automatically
generated data have been put in by hand and treated accordingly? I am sure there must be a solution
Thanks for any help.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- [libreoffice-users] BaseForms: transferring contents of data fields to the database table · Egbert Eissing
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy