[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[libreoffice-users] Help regarding LibOfficeBase/Firebird


Good evening,
and a successful new year 2019 to all of you!
And thanks for the gone interesting years with LibreOffice!
(even if not always quite satisfying)

My LibreOffice version on Windows10 now is 6.1.4.2 and I hope that LO-Base (finally) can meet my needs and intentions.

I have some old database-projects that I (very nicely) have built on MSAccess2003 and want now to rebuild them onto LO-Base.
One of them has three tables (a main form and two subforms with about a hundred records by 15-25 cols each) that I now have successfully ‘transformed’ via MSExcel to LO-Calc files.
My goal now is to get these 400 records to three LOBase tables with a maximum of ease (the new registered database has been created – but no tables yet!).

Now some questions to a LO-Base expert out there somewhere (I think the answers can be of interest to other LOBase-dummies like me!)
1 >>I have noticed that the embedded engine HSQLDB has been replaced with Firebird
    >>can I still work with LOBase as a frontend the same way as before? If not, why not?
    >>which are the main differences to be considered (e.g. regarding form- and report properties like with list-/comboboxes, reports etc)
                with Firebird vs HSQLDB
    >>where can I find fresh instructions (or tutorial) for LOBase (and if available for LOBase/Firebird)
2 >>as said the MSAccess table’s data are now saved as LOCalc-files.
I have learned how to export a LOBase table to a LOCalc file (registered) – but I can not find how to do the reverse:
    >>how do I import a LOCalc file’s data to a (registered) LOBase table, or in other words, get the data (with or not it’s structures) from a LOCalc file into                 a LOBase table?
3 >>        (Brian please, once more) what is the formula to calculate (now in a LOBase/Firebird form or query) a person's age out of her birth date?

All advice is very much appreciated!
Pertti Rönnberg /Finland, 79yrs


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Follow-Ups:
[libreoffice-users] Re: Help regarding LibOfficeBase/FirebirdAlexander Thurgood <alex.thurgood@gmail.com>
Re: [libreoffice-users] Help regarding LibOfficeBase/FirebirdRobert Großkopf <robert@familiegrosskopf.de>
Privacy Policy | Impressum (Legal Info) | Copyright information: 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.