Re: [libreoffice-users] BaseForms: transferring contents of data fields to the database table

Hi Egbert,

Andrew Pitonyak's "Open Office.org Base Macro Programming" on page 45
states -

The safest solution is to modify the bound field directly. For example,
your current code may be as follows:
oControl.setString("myText")
It is better if you can use the bound field:
oControl.BoundField.updateString("myText")
The required method is dependent on the data type, which is a drawback to
this method. I am aware of at least one instance where the specific method
(updateDate) failed, yet the generate updateString method properly updated
the bound field.

I have found that BoundField.updateString works well in situations such as
yours.  I have also worked out how to cover the problem of using a Macro to
write to a Date field.  If you ever need to do this, I could send you the
code.

​​Noel​
--
Marion & Noel Lodge
lodgemn@gmail.com

On 5 January 2016 at 14:24, Egbert Eissing <nicari234@yahoo.co.uk> wrote:

> 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 to this.
> Thanks for any help.
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> 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

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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