[libreoffice-users] Base Help Anyone

2014-11-18 Thread Alan Pedder



Hi
Libre Office
Version: 4.2.7.2
Build ID: 420m0(Build:2)
English
Base
 DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=14.04
DISTRIB_CODENAME=trusty
DISTRIB_DESCRIPTION=Ubuntu 14.04.1 LTS
 

I am new to Linux and therefore Libre Base and have been searching for help !!
I posted this on the Libre Office THe Document Foundataion but am still waiting 
for a reply...
 

I should be grateful if you could give me an answer to my question before I 
waste any more time..
 

I
 have been using Base to provide a database for my paintings via a 
simple form.  I recorded 200 records and then added the facility to 
include a photograph .jpg file and this is when the gremlins started to 
appear.  
 

It constantly issues error messages when adding data 
and causes me to endlessly loose work as it has failed to write to the 
table from a form for no obvious reason I can see, sometimes I can add a
 new data or several set/records on the form OK and then it will fail 
with the error message as follows where the Table1 is my Table 
 

S1000 General error java.lang.NullPointerException in statement [update 
Table1 SET Photo=? Where ID=?}
 

Is is a know issue that it is unstable ?  In addition I set auto save and 
backup yet fail to find them anywhere.
 Any help will be very appreciated and I am ok to provide my database for 
analysis if required by genuine helper and would pay on results if necessary.

 cheers
alan


Alan Pedder
Mb. 0781 844 5906
alanswatercolours.co.uk

  
-- 
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] Base Help Anyone

2014-11-18 Thread Alan B
On Tue, Nov 18, 2014 at 6:35 AM, Alan Pedder alanped...@hotmail.co.uk
wrote:

 I
  have been using Base to provide a database for my paintings via a
 simple form.  I recorded 200 records and then added the facility to
 include a photograph .jpg file and this is when the gremlins started to
 appear.


 It constantly issues error messages when adding data
 and causes me to endlessly loose work as it has failed to write to the
 table from a form for no obvious reason I can see, sometimes I can add a
  new data or several set/records on the form OK and then it will fail
 with the error message as follows where the Table1 is my Table


Hello Alan. I haven't used Base to store binaries however I have monitored
this list for a while and used Base for a few small projects.

I expect the two primary recommendations you will get are...
1. Don't store data in Base, use a separate database back end because the
embedded HSQL is not very stable. To that end I've recently found the
native MySQL connector works well for me (never had reliable connections
with the Java or ODBC connectors).
2. Don't store binaries in Base, store a path/pointer to the binary. Keeps
the table size down, minimizes loss if the db becomes corrupted.

-- 
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] Using LO Writer to edit HTML

2014-11-18 Thread Virgil Arrington


On 11/17/2014 12:26 PM, anne-ology wrote:

Therefore it's the simplest since it does not add all that excess
verbage  ;-)


Colored syntax doesn't add any verbage or code to the underlying text 
file. It just provides visual onscreen help in distinguishing code from 
text. This is an instance where simplest isn't better.


Virgil



--
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] Base Help Anyone

2014-11-18 Thread Andrew Douglas Pitonyak

On 11/18/2014 07:32 AM, Alan B wrote:

On Tue, Nov 18, 2014 at 6:35 AM, Alan Pedder alanped...@hotmail.co.uk
wrote:


I
  have been using Base to provide a database for my paintings via a
simple form.  I recorded 200 records and then added the facility to
include a photograph .jpg file and this is when the gremlins started to
appear.


It constantly issues error messages when adding data
and causes me to endlessly loose work as it has failed to write to the
table from a form for no obvious reason I can see, sometimes I can add a
  new data or several set/records on the form OK and then it will fail
with the error message as follows where the Table1 is my Table


Hello Alan. I haven't used Base to store binaries however I have monitored
this list for a while and used Base for a few small projects.

I expect the two primary recommendations you will get are...
1. Don't store data in Base, use a separate database back end because the
embedded HSQL is not very stable. To that end I've recently found the
native MySQL connector works well for me (never had reliable connections
with the Java or ODBC connectors).
2. Don't store binaries in Base, store a path/pointer to the binary. Keeps
the table size down, minimizes loss if the db becomes corrupted.
To re-enforce what was just said, some of which is obviously just an 
opinion


LO contains a database component which stores all of the data in a 
single file which is then pulled into memory when in use. This included 
database is HSQLDB


http://en.wikipedia.org/wiki/HSQLDB

If you create a standard Base document using what came with LO, then 
you are using HSQLDB as the back end to manage your data. You can use 
other database systems on the back-end. i am not an expert and cannot 
enumerate them, but, I expect that mariadb and postgre are both examples 
of other back-end database implementations that people use. The problem 
with that is that (I think) that you must have these programs running as 
a server to access them. The advantage is that they are more robust and 
less prone to errors; especially when you store a large amount of data.


I ran into significant problems when I stored a large number of images 
in a Base document backed by HSQLDB. I expect that the same problem 
would not have occurred if I had used a different DB to actually store 
the images (such as MySQL, MariaDB, or PostGRE). One method that may 
work is to not store the large binaries in the database, but, instead, 
store a path to the individual image in the DB and then store image 
itself on disk. I have used this method in production systems when 
storing very large binaries (by large I mean that each binary may be a 
couple of GB).


I stopped using Base years ago because of those Gremlins. I believe that 
many of the gremlins that plagued me have been fixed, but I would be 
hesitant to use it to store much binary data using HSQLDB as the back-end.


Just my opinion and perhaps others on the list can offer a more recent 
experience.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
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] Base Help Anyone

2014-11-18 Thread Tom Davies
Hi :)
It is only the internal HSqlDb back-end that loses data.  If you get the
proper HSqlDb from their website then it works completely fine.  It's
designed to be extremely fast for fairly tiny databases, like almost any
address book.

So, it's only Base that loses data.  Outside of LibreOffice and OpenOffice
losing data is a heinous crime, especially in a database!!

So the main thing is to migrate existing tables into an external back-end
and pretty much any external back-end will do.  Generally any back-end is
better than the Base one.  Postgresql might be the easiest.  MySql/MariaDb
are often used.

Regards from
Tom :)



On 18 November 2014 13:59, Andrew Douglas Pitonyak and...@pitonyak.org
wrote:

 On 11/18/2014 07:32 AM, Alan B wrote:

 On Tue, Nov 18, 2014 at 6:35 AM, Alan Pedder alanped...@hotmail.co.uk
 wrote:

  I
   have been using Base to provide a database for my paintings via a
 simple form.  I recorded 200 records and then added the facility to
 include a photograph .jpg file and this is when the gremlins started to
 appear.


 It constantly issues error messages when adding data
 and causes me to endlessly loose work as it has failed to write to the
 table from a form for no obvious reason I can see, sometimes I can add a
   new data or several set/records on the form OK and then it will fail
 with the error message as follows where the Table1 is my Table

  Hello Alan. I haven't used Base to store binaries however I have
 monitored
 this list for a while and used Base for a few small projects.

 I expect the two primary recommendations you will get are...
 1. Don't store data in Base, use a separate database back end because the
 embedded HSQL is not very stable. To that end I've recently found the
 native MySQL connector works well for me (never had reliable connections
 with the Java or ODBC connectors).
 2. Don't store binaries in Base, store a path/pointer to the binary. Keeps
 the table size down, minimizes loss if the db becomes corrupted.

 To re-enforce what was just said, some of which is obviously just an
 opinion

 LO contains a database component which stores all of the data in a single
 file which is then pulled into memory when in use. This included database
 is HSQLDB

 http://en.wikipedia.org/wiki/HSQLDB

 If you create a standard Base document using what came with LO, then you
 are using HSQLDB as the back end to manage your data. You can use other
 database systems on the back-end. i am not an expert and cannot enumerate
 them, but, I expect that mariadb and postgre are both examples of other
 back-end database implementations that people use. The problem with that is
 that (I think) that you must have these programs running as a server to
 access them. The advantage is that they are more robust and less prone to
 errors; especially when you store a large amount of data.

 I ran into significant problems when I stored a large number of images in
 a Base document backed by HSQLDB. I expect that the same problem would not
 have occurred if I had used a different DB to actually store the images
 (such as MySQL, MariaDB, or PostGRE). One method that may work is to not
 store the large binaries in the database, but, instead, store a path to the
 individual image in the DB and then store image itself on disk. I have used
 this method in production systems when storing very large binaries (by
 large I mean that each binary may be a couple of GB).

 I stopped using Base years ago because of those Gremlins. I believe that
 many of the gremlins that plagued me have been fixed, but I would be
 hesitant to use it to store much binary data using HSQLDB as the back-end.

 Just my opinion and perhaps others on the list can offer a more recent
 experience.

 --
 Andrew Pitonyak
 My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
 Info:  http://www.pitonyak.org/oo.php



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


-- 
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: [libreoffice-accessibility] Libo 4.3.4.1/We're Cooking

2014-11-18 Thread Tom Davies
Hi :)
I thought people here might like to see that accessibility issues are being
handled increasingly better.
Regards from
Tom :)



On 18 November 2014 15:02, David Goldfield dgold...@asb.org wrote:

 To quote the Beatles, I have to admit it's getting better.  Installation
 of the official 4.3.4.1 build did not trigger Symantec Endpoint Protection
 as the test builds did.
 Also, while within Calc, pressing f2 followed by the escape key gives me
 proper accessibility with NVDA as it did with the test builds.  Gentlemen,
 nice work and many thanks.


snip /

David Goldfield
 Computer Technology Instructor
 919 Walnut Street
 4th Floor
 Philadelphia, PA  19107

 215-627-0600 ext 3277
 FAX:  215-922-0692

 dgold...@asb.orgmailto:dgold...@asb.org
 www.asb.orghttp://www.asb.org

 Give a Donation
 http://asb.org/index.php?option=com_jdonation

 Serving Philadelphia's and the nation's blind and visually impaired
 population since 1874.



-- 
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] rtf files

2014-11-18 Thread Tom Davies
Hi :)
Congrats on this and many thanks for letting all of us know about it!!

I still think that Rtf is well worth avoiding if at all possible but sadly
a whole load of people fell for MS's marketing.  Even to this day there are
people who believe in using it, despite the findings of the court case.  So
it's good if LO can use it with some confidence despite all it's problems.

It's going to be quite amusing when it's only non-MS packages are still
supporting the mess of old unreliable formats that MS scatters behind it.
Regards from
Tom :)



On 16 November 2014 08:34, Tim Lloyd tim.ll...@gmx.com wrote:

 Hi All,

 this is a bug reported by Carole towards the end of September. The issue
 was where data in columns in rtf files was not stored correctly.

 For the record this bug has been fixed and will be release in 4.4.0.

 Cheers
 On 29/09/14 16:02, Jean-Francois Nifenecker wrote:

 Hi,

 Le 29/09/2014 04:26, Tim Lloyd a écrit :

 FYI I removed 4.3 and installed 4.1. The problem is not apparent with
 the older version. I have some old versions stored away so I can drill
 down and find when exactly this problem occurs and report to the
 bugzilla (I can't see anything obvious there).

 Let me know if we are on the same page.

  FYI, the older versions are available here:
 http://downloadarchive.documentfoundation.org/libreoffice/old/



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


-- 
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: Base Help Anyone

2014-11-18 Thread Alexander Thurgood
Le 18/11/2014 12:35, Alan Pedder a écrit :


Hi Alan,


 
 Is is a know issue that it is unstable ?  In addition I set auto save and 
 backup yet fail to find them anywhere.

Yes, unfortunately a known and frequent phenomenon with the default
provided embedded hsqldb implementation.

You might get more mileage out of it by upping the memory available to
the Java process that is used - there is a setting for this that you
would have to manually add to the script or properties file (these files
are to be found within the ODB file, which is simply a zipped container
for the database setup). Read the hsqldb 1.8 documentation before
fiddling with these though.


Autosave doesn't work for Base documents, if it produces anything at
all, then it will be a series of 0 byte files.

This is currently bug 71550.


  Any help will be very appreciated and I am ok to provide my database for 
 analysis if required by genuine helper and would pay on results if necessary.

No need to provide it here, your database is probably corrupt judging by
the symptoms you are experiencing. I hope you have some kind of stable
backup or copy of the ODB file somewhere else that you can work from, or
at least re-purpose, in order to connect your front end (forms, queries,
etc) to a more reliable backend db system.

HSQLDB is reliable enough outside of the embedded scenario defined as
the default in LO Base. There are tutorials in the OpenOffice.org  forum
and the LO Base Handbook which explain how to set up a split hsqldb
database.

Alternatively, people use a variety of other db backend engines :

SQLite
H2
Postgresql
MySQL / MariaDB
Firebird (not the embedded version that ships experimentally with LO,
but the standaloe server version)

Obviously, not all engines will be suited to what you want to do, or are
willing to administrate, etc, so it would be best to do your homework
beforehand to make up your mind.

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: Base Help Anyone

2014-11-18 Thread Andreas Säger
Hi,

Store all picture files in the same directory as your Base file.

Call menu:ToolsSQL and execute:
ALTER TABLE PicTable DROP COLUMN Pics;
ALTER TABLE PicTable ADD COLUMN Pics VARCHAR(100);
SHUTDOWN COMPACT;

where PicTable should be replaced with the actual name of your table
and Pics with the actual name of the field in that table.

The database will be defragmented and is no longer accessible. Restart
the office suite, open the database and your form. A double-click on the
picture control still opens a file picker dialog. But now it stores only
the file name in the database field and loads the actual picture data
from that file.

If you want to convert this embedded HSQL database to a real database
follow this description:
 https://forum.openoffice.org/en/forum/viewtopic.php?f=6t=62905p=278742#p278742

Hope this helps.


-- 
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: Report in Base not executed

2014-11-18 Thread Harvey Nimmo
On Sun, 2014-11-16 at 10:36 +0100, Alex Thurgood wrote:
 Le 14/11/2014 15:39, Harvey Nimmo a écrit :
  com.sun.star.loader.CannotActivateFactoryException was caught.
 
 
 
 Sounds similar to this :
 
 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=51278
 
 which was around in the transition to LO 3.6.x
 
 Maybe try resetting your LO user configuration profile ?
 
 Alex
 
I tried that after trying to reset my UserProfile (thanks to Tom Davies' 
advice).
It seems now a wee bit clearer that the
com.sun.star.comp.loader.JavaLoader is missing.

Harvey



-- 
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] How does 4.4 compress PDFs so well? Is there a quality problem?

2014-11-18 Thread Paddy Landau
I edit a community magazine using LibreOffice Writer. I create a PDF from the
final version, which I send electronically to the printing company, which
prints the PDF.

To create the PDF, I use the settings Lossless compression and do not
reduce image resolution. The resulting PDF is usually in excess of 100Mb,
presumably mainly because of all the images used.

This month, I have created the PDF using both the current stable version
4.3.4.1 and the beta version 4.4.0.0. (I used the beta version because of a
new small bug in 4.3.)

Fascinating results!

Visually, the two PDFs look the same (apart from the small bug). I've
printed a sample page from each PDF and compared them, and they appear
equally-good quality.

However, the sizes are dramatically different. The PDF from 4.3.4.1 is
157.7Mb, which is roughly what I'd expect from past experience. The same PDF
from 4.4.0.0 is a mere 27Mb, just a sixth of its size.

Adding up the sizes of all the images, they come to (approximately) 30Mb.
So, it seems to me that the current version perhaps stuffs the files with
unnecessary content — or perhaps decompresses the images when saving —
whereas the beta version seems to save the files decently compressed.

So, are you able to tell me…

How is the PDF from the beta version so small — or the PDF from the current
version so large?
Am I going to get an unwelcome surprise in the quality of the printed copy
if I send the PDF from 4.4.0.0?
Does the current version use some amazing compression to create its PDF?
Or does the old version stuff the file full of unnecessary content?

Thanks in advance.



--
View this message in context: 
http://nabble.documentfoundation.org/How-does-4-4-compress-PDFs-so-well-Is-there-a-quality-problem-tp4129492.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: How does 4.4 compress PDFs so well? Is there a quality problem?

2014-11-18 Thread V Stuart Foote
@Paddy,

A printed copy of your PDF is not a very good test of document quality.
Embedded BMP representation within LibreOffice is at 300dpi.  Export print
may be the vector format  (wmf, emf, eps, svg) or a bitmap rendering
preview--at 300dpi. 

 You really need to open each PDF in suitable viewer and zoom in to 800% or
1200%.  How do embedded  images compare there? Are they bitmap?  Or more
concise full resolution vector images?

Also, the platform you work on will impact handling of vector images.
Several helper programs are needed--Ghostscript, ImageMagick, pstoedit and
the mix will impact handling as bitmap or vector.

Please provide your OS details, and perhaps attach a sample output (via the
Nabble interface).

Stuart 




--
View this message in context: 
http://nabble.documentfoundation.org/How-does-4-4-compress-PDFs-so-well-Is-there-a-quality-problem-tp4129492p4129497.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: How does 4.4 compress PDFs so well? Is there a quality problem?

2014-11-18 Thread Tim---Kracked_P_P---webmaster


For any document that I want to have a good image printed, I normally 
set everything for 600 dpi minimum, and even higher if the printer can 
print higher.  My bw laser goes to 1200 dpi and for business 
presentations that are bw, I print at that dpi, as long as the 
printer's memory can handle the extra memory for the page and its 
graphics - i.e. the maxed out 48 MB limit for its internal memory [more 
memory costs more than the printer itself].




On 11/18/2014 05:15 PM, V Stuart Foote wrote:

@Paddy,

A printed copy of your PDF is not a very good test of document quality.
Embedded BMP representation within LibreOffice is at 300dpi.  Export print
may be the vector format  (wmf, emf, eps, svg) or a bitmap rendering
preview--at 300dpi.

  You really need to open each PDF in suitable viewer and zoom in to 800% or
1200%.  How do embedded  images compare there? Are they bitmap?  Or more
concise full resolution vector images?

Also, the platform you work on will impact handling of vector images.
Several helper programs are needed--Ghostscript, ImageMagick, pstoedit and
the mix will impact handling as bitmap or vector.

Please provide your OS details, and perhaps attach a sample output (via the
Nabble interface).

Stuart




--
View this message in context: 
http://nabble.documentfoundation.org/How-does-4-4-compress-PDFs-so-well-Is-there-a-quality-problem-tp4129492p4129497.html
Sent from the Users mailing list archive at Nabble.com.




--
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: rtf files

2014-11-18 Thread Urmas

Tom Davies:


I still think that Rtf is well worth avoiding if at all possible but sadly
a whole load of people fell for MS's marketing.  Even to this day there 
are

people who believe in using it, despite the findings of the court case.


Which court case? RTF is rather trivial format, providing compatibility 
between versions from 1986 till today. If LO does not support it, it is 
itself to blame, not Microsoft, 'monopolies' or denizens of Nibiru.





--
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] Base Help Anyone

2014-11-18 Thread Alan B
On Tue, Nov 18, 2014 at 8:19 AM, Alan Pedder alanped...@hotmail.co.uk
wrote:







 *Really appreciate your reply but unfortunately a lot of what you wrote is
 a bit over my level of knowledge and whilst I understand the terminology it
 did raise several questions i.e.1. Storing binaries refers to jpg files?2.
 What would a back end database look like? A spreadsheet?3. MySQL is an
 application that would interpret/interact with the database. Hence Libre
 Base would not be involved?4. Are there more stable databases products
 available excluding Access5. I get what you say about pointing to
 jpg/binaries but that is a feature I like about Base and not sure what
 Field Type would do that?*

Hi again Alan.

Sorry to jump in the deep end with my reply. A database is typically used
by a very small number of people compared to word processing, spreadsheet,
etc. As a result I didn't even think about holding back the jargon in my
reply.

Seems a number of people have given answers that should help you on your
way. Regarding your questions here...
1. Yes
2. Yes, that is one way the table can be viewed. Like looking at the table
in your database. Just keep in mind it is not a spread sheet and so even
though it looks similar it does not work the same way.
3. MySQL *is* the database. LibreOffice Base is the program that shows you
the table that is MySQL gives it. Kind of like your web browser lets you
look at web pages. Each web site has its own web server and gives the web
page to your browser to display for you. MySQL is the server and gives the
table to LibreOffice Base to display for you.
4. There may be. I don't know of them. Hopefully other respondents can give
an idea what options there are and how stable they might be. (Presuming you
envision a single product answer where the whole thing can be managed by
a single program as with Base and Access.)
5. Andreas provided that answer. If you missed it he suggests VARCHAR(100).

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