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

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