[libreoffice-users] Re: Platform cross-compatability

Le 02/09/11 13:19, Tom Davies a écrit :

Hi Tom,

> Errr, Alex and Andreas are 2 of the Base experts here.  There are a few others 
> too.  My advice was based on a few posts by Andreas a while ago but i might have 
> to work out how i misinterpreted his advice if Alex is saying something 
> different.  Usually i like it when different experts given contradictory advice 
> because it leads to discussion where i learn something.  I thought it was a good 
> idea to avoid Hsql but i could easily be wrong.  

I don't think you have misunderstood. Base can be used cross-platform
providing you keep it simple, e.g. :

- filenames and filename paths should be made cross-platform compatible,
i.e. don't name your ODB file or your tables, queries, reports, etc,
with weird and wonderful characters that might be supported on one OS
and not the other ; if possible, stick to ASCII 127;

- don't rely on file path separators to be correctly interpreted if you
store object references in your database (e.g. images, video, sounds and
other binary objects) ;

- if you do store references to binary objects in your db, use relative
references, and ensure that your target host has the same directory setup ;

- beware of potential localisation and cross-platform issues especially
with regard to your choice of data types.

- save your Forms outside of the Base container, i.e. when the form is
open, click on "Save as" and save it to a different location. You can
then provide the forms saved in this way independently of the ODB file.

In the past, there have also been known (as in mailing list discussion
and possibly OOo bugtracker) problems with user configuration files
getting either overwritten or not correctly updated, and with some kind
of cache issue preventing user configurations from working properly when
trying to use an ODB file produced on another machine. These appear to
unfortunately be rather random, and so difficult to pinpoint, but when
they do occur can be really frustrating.


Alex


-- 
For unsubscribe instructions e-mail to: users+help@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