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

2016-01-05 Thread Alexander Thurgood
Le 05/01/2016 04:24, Egbert Eissing a écrit :

Hi Egbert,

> 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. 
> 


Without having access to the macro code that you have written, how do
you expect us to be able to help ? It could be that something is missing
in your code, e.g. a commit statement of the form control's value to the
bound database field.



Alex


-- 
To unsubscribe e-mail to: users+unsubscr...@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


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

2016-01-05 Thread Andreas Säger
Am 05.01.2016 um 04:24 schrieb Egbert Eissing:
> 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. 
> 

Please refer to other peoples working code. There are far too many
problems and pitfalls with this API to answer this question out of thin air.


-- 
To unsubscribe e-mail to: users+unsubscr...@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