[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+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
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
[libreoffice-users] Making liberoffice as default
Dear sir I hv downlloaded liberoffice5 n installed in my laptop with win 10. However i culd nt make liberoffice as default file opener. Kly guide me Thanks C v Ananth -- 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
Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?
Don Parris wrote:
Still trying to work out the OUTER JOIN syntax apparently. I tried a
simpler outer join statement:
SELECT
"tCoreType"."type" "Type", "tCoreCategory"."category" "Category"
FROM {oj "tCoreType" "ctype" LEFT OUTER JOIN "tCoreCategory" "ccat"
ON "ctype"."type_id" = "ccat"."type_id"}
This gives me the following error:
SQL Status: S0022
Error code: -28
Column not found: tCoreType.type in statement [SELECT "tCoreType"."type"
"Type", "tCoreCategory"."category" "Category" FROM "tCoreType" "ctype"
LEFT OUTER JOIN "tCoreCategory" "ccat" ON "ctype"."type_id" =
"ccat"."type_id" ]
The column "type" is most certainly one of the columns in the specified
table. No matter what order or how I try to enter this, it just comes up
with an error message. Any ideas? I really would like to learn how to
make this work.
"tCoreType" "ctype" in the FROM clause renames the "tCoreType" as
"ctype" for the purposes of this query. So in the SELECT clause you need
to refer to it as "ctype", as you have done in the join condition.
Likewise for renaming "tCoreCategory" to "ccat". So:
SELECT "ctype"."type" "Type", "ccat"."category" "Category" ...
Mark.
--
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] Linking a Form to another table
Hi All I have another table of data that I would like to link to an existing Form. The Form was originally linked to Table "ABC" but I now want to link it to table "Name/DEF". Is this possible and how would I do this please?? Thanks for any help (I'm using PClinuxOS and LibreOffice 5.0.0.2 to a MySQL Database) Ianw Pretoria RSA -- 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
