Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index


Hi Alexander & Robert,

Thank you both for your responses and suggestions.  Sorry about the delayed
reply - I've had limited access to the User's Mac.

It is with a rather red face that I report that the problem was caused by
me forgetting to load a Library file of 45 functions that I have written
which form a central part of the system!  The Library file is loaded under
My Macros | Standard and is stored with LO files.  It is not part of the
.odb file.  I do it that way because the functions are common to all the
databases I have written.

When I've forgotten to load the Library other times, (on Windows PCs),
I've had an error message when the database has been initializing, telling
me it can't find a particular function, and this has alerted me to what the
problem is.  But the Mac reacted differently, so I assumed that it was a
Mac problem.  Bad assumption!  Sorry I bothered you.

However, I did unzip the .odb file as you suggested, and examining the code
alerted me to all the calls to the Library functions.  So your advice did
lead me to the solution.  Once the Library file was in place, all the
Queries, Forms and Reports magically appeared!

Much of the system is now working, but I'm still having problems opening
the main menu.  I discovered that I have used a few calls to Windows
functions, which naturally, the Mac takes a very dim view of!  I've tracked
down several of these, but I think there must be more.  I knew that porting
to the Mac would be difficult, but I'm now hopeful that I'll get there in
the end.

Many thanks for your help

Noel
--
Noel Lodge
lodgemn@gmail.com

On 15 September 2017 at 16:50, Alexander Thurgood <alex.thurgood@gmail.com>
wrote:

Le 15/09/2017 à 04:36, Marion & Noel Lodge a écrit :

Hi Noel,

I don't know of any particular configuration setting that might cause
this, unless there is something physically wrong with the file itself.

Some possibilities to explore :

- if you have automatic document backups (AutoSave) configured on the
Mac LO, turn that off, restart LO and see if it makes a difference.
There is/was a known bug that affected the display of some ODB files
when this option was activated ;

- compare the files on both OSes to check that they are identical (in
structure and content) by unzipping each one ;

- when you create a query in H2 via LO, is it stored within the H2
database schema, for which the LO ODB would merely contain a reference
(with a file path, which would be different between Win/Mac)  OR is the
query stored within the LO ODB in full SQL ?


The fact that you can't see any of the Queries, Reports, Forms, might
indicate a problem with the paths in the XML sections of the ODB file
that defines each of these.


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


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

Context


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.