Re: [libreoffice-users] LO Base Query - 'count' function behaviour

[Harvey Nimmo]

Yes that works, too. I notice that Base strips off the 'AS' keywords.

Cheers
Harvey


On Tue, 2022-08-16 at 16:02 +0200, Robert Großkopf wrote:
> Hi Harvey,
> 
> tested this:
> 
> SELECT COALESCE ( `User`, 'Empty' ) AS `User`, COUNT( `ID` ) FROM 
> `test`.`User` AS `User` GROUP BY `User`
> 
> You don't need to change the alias for `Location` to `Loc`.
> I could save this, open this to edit in GUI, execute it - no Problem 
> with direct connection on MariaDB.
> 
> When trying the same with MariaDB and JDBC I will get:
> Column 'User' in group statement is ambiguous at 
> /home/buildslave/source/libo-
> core/connectivity/source/drivers/jdbc/SQLException.cxx:35
> 
> Changing the code to
> SELECT COALESCE ( `User`, 'Empty' ) AS `Us`, COUNT( `ID` ) FROM 
> `test`.`User` AS `User` GROUP BY `User`
> and the query will work. Won't be detroyed also through GUI.
> 
> GUI will destroy the query when setting
> GROUP BY `Us` instead of GROUP BY `User`. Seems it hat problems using
> the alias for a group. But the alias isn't needed there, so set 
> `Location` instead of `Loc`
> 
> Regards
> 
> Robert
> -- 
> Homepage: https://www.familiegrosskopf.de/robert
> 


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Query - 'count' function behaviour

[Robert Großkopf]

Hi Harvey,

tested this:

SELECT COALESCE ( `User`, 'Empty' ) AS `User`, COUNT( `ID` ) FROM 
`test`.`User` AS `User` GROUP BY `User`


You don't need to change the alias for `Location` to `Loc`.
I could save this, open this to edit in GUI, execute it - no Problem 
with direct connection on MariaDB.


When trying the same with MariaDB and JDBC I will get:
Column 'User' in group statement is ambiguous at 
/home/buildslave/source/libo-core/connectivity/source/drivers/jdbc/SQLException.cxx:35


Changing the code to
SELECT COALESCE ( `User`, 'Empty' ) AS `Us`, COUNT( `ID` ) FROM 
`test`.`User` AS `User` GROUP BY `User`

and the query will work. Won't be detroyed also through GUI.

GUI will destroy the query when setting
GROUP BY `Us` instead of GROUP BY `User`. Seems it hat problems using 
the alias for a group. But the alias isn't needed there, so set 
`Location` instead of `Loc`


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert

--
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Query - 'count' function behaviour

[Harvey Nimmo]

Just one remark on this, though. The GUI and SQL Edit views seem not to
be consistent with each other. Just opening the Query to Edit GUI,
adjusting the pane size (say) and saving the result, destroys the
query.

Cheers
Harvey
 

On Tue, 2022-08-16 at 10:54 +0200, Harvey Nimmo wrote:
> Thank you, Robert! As always on target. 
> 
> This is better than filling the Location fields with some unneeded
> value. Great stuff. Man lernt nie aus!
> 
> Cheers
> Harvey
> 
> On Tue, 2022-08-16 at 10:15 +0200, Robert Großkopf wrote:
> > Hi Harvey,
> > > 
> > >   SELECT `Location`, COUNT( `Location` ) FROM
> > > `Item_Management`.`Items`
> > > `Items` GROUP BY `Location`
> > > 
> > > The result is correct for all LOCATIONS that are not empty, but
> > > surpisingly the blank field for the empty locations is
> > > accompanied
> > > by
> > > the value 0. How can I get the right count for the empty fields
> > > as
> > > well?
> > 
> > Try this:
> > SELECT COALESCE(`Location`,'Empty') AS `Loc`, COUNT( `ID` ) FROM 
> > `Item_Management`.`Items` GROUP BY `Loc`
> > 
> > COUNT: Always use a field which should never be NULL (primary key
> > for
> > example)
> > Set a vallue for a field, which is empta at this moment. If
> > "Location" 
> > contains characters it will work with 'Empty' as shown above.
> > 
> > Didn't test it!
> > 
> > Regards
> > 
> > Robert
> > -- 
> > Homepage: https://www.familiegrosskopf.de/robert
> > 
> 


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Query - 'count' function behaviour

[Harvey Nimmo]

Thank you, Robert! As always on target. 

This is better than filling the Location fields with some unneeded
value. Great stuff. Man lernt nie aus!

Cheers
Harvey

On Tue, 2022-08-16 at 10:15 +0200, Robert Großkopf wrote:
> Hi Harvey,
> > 
> >   SELECT `Location`, COUNT( `Location` ) FROM
> > `Item_Management`.`Items`
> > `Items` GROUP BY `Location`
> > 
> > The result is correct for all LOCATIONS that are not empty, but
> > surpisingly the blank field for the empty locations is accompanied
> > by
> > the value 0. How can I get the right count for the empty fields as
> > well?
> 
> Try this:
> SELECT COALESCE(`Location`,'Empty') AS `Loc`, COUNT( `ID` ) FROM 
> `Item_Management`.`Items` GROUP BY `Loc`
> 
> COUNT: Always use a field which should never be NULL (primary key for
> example)
> Set a vallue for a field, which is empta at this moment. If
> "Location" 
> contains characters it will work with 'Empty' as shown above.
> 
> Didn't test it!
> 
> Regards
> 
> Robert
> -- 
> Homepage: https://www.familiegrosskopf.de/robert
> 


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Query - 'count' function behaviour

[Robert Großkopf]

Hi Harvey,


  SELECT `Location`, COUNT( `Location` ) FROM `Item_Management`.`Items`
`Items` GROUP BY `Location`

The result is correct for all LOCATIONS that are not empty, but
surpisingly the blank field for the empty locations is accompanied by
the value 0. How can I get the right count for the empty fields as
well?


Try this:
SELECT COALESCE(`Location`,'Empty') AS `Loc`, COUNT( `ID` ) FROM 
`Item_Management`.`Items` GROUP BY `Loc`


COUNT: Always use a field which should never be NULL (primary key for 
example)
Set a vallue for a field, which is empta at this moment. If "Location" 
contains characters it will work with 'Empty' as shown above.


Didn't test it!

Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert

--
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] LO Base Query - 'count' function behaviour

[Harvey Nimmo]

I have a table consisting of (unique) ITEMS and with a column LOCATION
for the land of origin of the ITEMS. Some LOCATION fields are still
empty.

A query counts the number entries in the LOCATION column for each
country present. Essentially the GUI just shows the functions LOCATION
'group' and LOCATION 'count'.

 SELECT `Location`, COUNT( `Location` ) FROM `Item_Management`.`Items`
`Items` GROUP BY `Location`

The result is correct for all LOCATIONS that are not empty, but
surpisingly the blank field for the empty locations is accompanied by
the value 0. How can I get the right count for the empty fields as
well?

Cheers
Harvey



-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Views and Queries

[Robert Großkopf]

Hi John,

...
MySQL/MariaDB with different drivers will be a new thread - or 
shouldn't we try it per private mail?

...


Robert, I have only been following this thread as a lurker, not 
contributor, but if I may offer a view on that question: I'm surely not 
the only person finding this thread educational, and do not see this 
latest turn as off-topic. However, whether or not you find it 
appropriate to start a new thread, I do hope you will continue on-list. 
You are doing the world a service.


… and I thought: Base - not much people are interested.

In a mailinglist I'm missing the possibility to sort the mails by 
groups, to see something in screenshots. Better solution for this is 
something like

https://ask.libreoffice.org/tag/base

If there is any question related to Base I will (try to) answer also on 
this mailinglist.


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert

--
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Views and Queries

[John Kaufmann]

On 2022-08-12 12:44, Robert Großkopf wrote:

...
MySQL/MariaDB with different drivers will be a new thread - or shouldn't we try 
it per private mail?
...


Robert, I have only been following this thread as a lurker, not contributor, 
but if I may offer a view on that question: I'm surely not the only person 
finding this thread educational, and do not see this latest turn as off-topic. 
However, whether or not you find it appropriate to start a new thread, I do 
hope you will continue on-list. You are doing the world a service.

Regards,
John

--
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Views and Queries

[Robert Großkopf]

Hi Harvey,

MySQL/MariaDB with different drivers will be a new thread - or shouldn't 
we try it per private mail?


Which connector do you use? (MySQL or MariaDB? If MySQL: which version?)

Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert

--
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Views and Queries

[Harvey Nimmo]

Hi Robert,

I have chosen the configuration LO-Base front ent to Mariadb backend
becuase of the advantage of database server with Terrabytes of disk
space. 

But I am wondering seriously whether I have made a good choice. There
seem to be serious compatibilty problems between them in spite of the  
LO MySQL(JDBC) driver interface. For example, The GUI tells me that 3
arguments required by the LO-Base DATEDIFF() function is to incorrect,
and accepts only two arguments (as per MYSQL). But a LO-Base query with
2 arguments, which is syntactically accepted, returns no data.

I am beginning to feel a bit frustrated with this LO-Base/Mariadb idea.
That would be a pity, as the GUI would theoretically be good to avoid
all the SQL typing work (not really within the scope of my expertise),
and the Forms and Reports are a bonus that is missing in the phpMyAdmin
environment.

But perhaps it's just the hot weather. 

Cheers
Harvey



On Fri, 2022-08-12 at 10:09 +0200, Robert Großkopf wrote:
> Hi Harvey,
> 
> > OK. Thanks, Robert. That is more or less the conclusion that I had
> > come
> > to. Not very user-friendly, but it works.
> 
> Reason for this behavior might be you are using a server database for
> many users. Have had a look with PHPMyAdmin. Couldn't edit the view 
> there also.
> 
> Regards
> 
> Robert
> -- 
> Homepage: https://www.familiegrosskopf.de/robert
> 


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Views and Queries

[Robert Großkopf]

Hi Harvey,


OK. Thanks, Robert. That is more or less the conclusion that I had come
to. Not very user-friendly, but it works.


Reason for this behavior might be you are using a server database for 
many users. Have had a look with PHPMyAdmin. Couldn't edit the view 
there also.


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert

--
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Views and Queries

[Harvey Nimmo]

OK. Thanks, Robert. That is more or less the conclusion that I had come
to. Not very user-friendly, but it works.

Cheers
Harvey

On Fri, 2022-08-12 at 08:36 +0200, Robert Großkopf wrote:
> Hi Harvey,
> > 
> > I cannot confirm the Firebird icon. My database backend is
> > MySQL(JDBC),
> > (actually Mariadb). I prefer to continue for the time being with
> > the
> > OpenSUSE packages delivered with my Linux Leap 15.4.
> 
> Editing views with external databases won't work. It's the same
> behavior 
> for every other connection with MySQL/MariaDB, also with PostgreSQL.
> 
> So: Create queries, save it as a query, create a view of this query.
> For 
> changing a view: Edit the query you have saved. Delete the view.
> Create 
> the view from the query again.
> 
> Regards
> 
> Robert
> -- 
> Homepage: https://www.familiegrosskopf.de/robert
> 


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Views and Queries

[Robert Großkopf]

Hi Harvey,


I cannot confirm the Firebird icon. My database backend is MySQL(JDBC),
(actually Mariadb). I prefer to continue for the time being with the
OpenSUSE packages delivered with my Linux Leap 15.4.


Editing views with external databases won't work. It's the same behavior 
for every other connection with MySQL/MariaDB, also with PostgreSQL.


So: Create queries, save it as a query, create a view of this query. For 
changing a view: Edit the query you have saved. Delete the view. Create 
the view from the query again.


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert

--
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Views and Queries

[Harvey Nimmo]

Hi Robert,

I cannot confirm the Firebird icon. My database backend is MySQL(JDBC),
(actually Mariadb). I prefer to continue for the time being with the
OpenSUSE packages delivered with my Linux Leap 15.4. 

Cheers
Harvey


On Thu, 2022-08-11 at 18:06 +0200, Robert Großkopf wrote:
> Hi Harvey,
> 
> LO won't be installed without internal HSQLDB. But with that behavior
> you reported you are using internal Firebird. Will be shown at the 
> bottom of the window in statusbar.
> 
> You are using packages from your distribution, not from LO directly. 
> Have tested the same version you are using, only from LO directly:
> Version: 7.3.4.2 / LibreOffice Community
> Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
> CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5
> (cairo+xcb)
> Locale: de-DE (de_DE.UTF-8); UI: de-DE
> Calc: threaded
> 
> If I choose to edit views they will be opened in this version with
> the 
> query editor.
> 
> Regards
> 
> Robert
> --
> Homepage: https://www.familiegrosskopf.de/robert
> 


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Views and Queries

[Robert Großkopf]

Hi Harvey,

LO won't be installed without internal HSQLDB. But with that behavior 
you reported you are using internal Firebird. Will be shown at the 
bottom of the window in statusbar.


You are using packages from your distribution, not from LO directly. 
Have tested the same version you are using, only from LO directly:

Version: 7.3.4.2 / LibreOffice Community
Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

If I choose to edit views they will be opened in this version with the 
query editor.


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert

--
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Views and Queries

[Harvey Nimmo]

Hi Robert,

Thanks, so far...;-) I understand that a View would be more efficient
in execution than the equivalent query. And this seems to be more or
less the practical extent of justification for view over query.

My version:
Version: 7.3.4.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Calc: threaded

How do I identify the internal db used? Firebird (version 3.0.4.33045-
1.7) is installed in my configuration, HSQLDB is not.

I think I understand your tip to mean that i should use queries until
they are 'final' and then create views as appropriate.

Cheers
Harvey


On Thu, 2022-08-11 at 16:38 +0200, Robert Großkopf wrote:
> Hi Harvey,
> 
> > I'm unsure of the practical implications of the difference between
> > Base
> > implementation of Views and Queries. Perhaps someone can enlighten
> > me.
> > One thing, however, does hit me.
> 
> Views will be executed in the database. The content will look for
> Base 
> like a non-writable table. You could filter data, sort data and use
> this 
> views for repprts, but you couldn't update, add or delete data.
> 
> Database won#t know anything about queries in the queries pane.
> Queries 
> will send from tBase to the database. So queries will be a little bit
> slower. But queries could be used for input, update or delete data,
> if 
> all primary keys of the included tables were available.
> > 
> > Initial design of a View with the GUI, is done similar to a Query,
> > which is OK. However, when the View is stored, then further
> > development
> > of that View seems very limited if not impossible, as the Table-
> > type
> > GUI is opened on Edit.
> 
> Which version pf LO and which (internal) database do you use? This
> bug 
> (opening table editor, not query editor) has been solved for internal
> Firebird database some times ago. In LO 7.4.0.2 the query editor will
> appear.
> 
> One hint: I will save all views separately as queries. It is because
> a 
> view could depend on another view. So I couldn't chang the view I
> first 
> created, if another view needs data of this view. I have to delete
> other 
> views depending on this view and have to recreate them afterwards.
> 
> Regards
> 
> Robert
> -- 
> Homepage: https://www.familiegrosskopf.de/robert
> 


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Views and Queries

[Robert Großkopf]

Hi Harvey,


I'm unsure of the practical implications of the difference between Base
implementation of Views and Queries. Perhaps someone can enlighten me.
One thing, however, does hit me.


Views will be executed in the database. The content will look for Base 
like a non-writable table. You could filter data, sort data and use this 
views for repprts, but you couldn't update, add or delete data.


Database won#t know anything about queries in the queries pane. Queries 
will send from tBase to the database. So queries will be a little bit 
slower. But queries could be used for input, update or delete data, if 
all primary keys of the included tables were available.


Initial design of a View with the GUI, is done similar to a Query,
which is OK. However, when the View is stored, then further development
of that View seems very limited if not impossible, as the Table-type
GUI is opened on Edit.


Which version pf LO and which (internal) database do you use? This bug 
(opening table editor, not query editor) has been solved for internal 
Firebird database some times ago. In LO 7.4.0.2 the query editor will 
appear.


One hint: I will save all views separately as queries. It is because a 
view could depend on another view. So I couldn't chang the view I first 
created, if another view needs data of this view. I have to delete other 
views depending on this view and have to recreate them afterwards.


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert

--
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] LO Base Views and Queries

[Harvey Nimmo]

I'm unsure of the practical implications of the difference between Base
implementation of Views and Queries. Perhaps someone can enlighten me.
One thing, however, does hit me.

Initial design of a View with the GUI, is done similar to a Query,
which is OK. However, when the View is stored, then further development
of that View seems very limited if not impossible, as the Table-type
GUI is opened on Edit.

Is there a way to return to the Query-type feature to continue
modifying the View design once the View has been stored and closed?



-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base: Boolean Report values

[Harvey Nimmo]

On Thu, 2019-12-12 at 20:28 +0100, Robert Großkopf wrote:
> Hi Harvey
> > 
> > I was just about to answer that I had tried that and it did not
> > work,
> > until I noticed your square brackets []. That did the trick!! You
> > are
> > wonderful.
> > 
> > But where is that documented?
> 
> Don't know wher I found it, when I created the Base-Handbook. But
> have a
> lokk for the English version of the Base-Handbook. I have written
> there
> a chapter for the Report-Builder. I copied the code from there.
> 
> If you will try it in German have a look at my homepage.
> 
> Regards
> 
> Robert
> -- 
> Homepage: https://www.familiegrosskopf.de/robert

I've found it. V6.2. Many thanks again!
> 

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base: Boolean Report values

[Robert Großkopf]

Hi Harvey
> 
> I was just about to answer that I had tried that and it did not work,
> until I noticed your square brackets []. That did the trick!! You are
> wonderful.
> 
> But where is that documented?

Don't know wher I found it, when I created the Base-Handbook. But have a
lokk for the English version of the Base-Handbook. I have written there
a chapter for the Report-Builder. I copied the code from there.

If you will try it in German have a look at my homepage.

Regards

Robert
-- 
Homepage: https://www.familiegrosskopf.de/robert


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base: Boolean Report values

[Harvey Nimmo]

On Thu, 2019-12-12 at 19:46 +0100, Robert Großkopf wrote:
> Hi Harvey,
> 
> try this:
> Write into Data > Data field
> 
> IF([NameOfBoolField];"y";"n")
> 
> Regards
> 
> Robert
> -- 
> Homepage: https://www.familiegrosskopf.de/robert

Hi Robert,

I was just about to answer that I had tried that and it did not work,
until I noticed your square brackets []. That did the trick!! You are
wonderful.

But where is that documented?

Regards
Harvey

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base: Boolean Report values

[Robert Großkopf]

Hi Harvey,

try this:
Write into Data > Data field

IF([NameOfBoolField];"y";"n")

Regards

Robert
-- 
Homepage: https://www.familiegrosskopf.de/robert


-- 
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] LO Base: Boolean Report values

[Harvey Nimmo]

I wonder if anyone knows how to solve this little problem?

I am trying to construct a report from a Table/Query in Base. Amongst
other data there are five boolean flags (Type Yes/No[BIT] to be printed
from each record.

Thinking that it would take up too much space on the paper together
with the labels, in my naivity, I thought it would be easy, to print a
single character (e.g. "y", "n", or even better U+2611, U+2610) for the
values each time, rather than the clumsy defaults TRUE or FALSE.

After several hours(!!) of experimentation with 'IF' expressions and
field definitions in various places (Report fields, Query fields), I
have come to the end of my creativity.

I cannot believe that this simple idea has no simple solution...but
what is it?

Can anyone point me in the right direction?

Kind Regards
Harvey 

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO Base Queries, Forms & Reports not appearing

[Robert Großkopf]

Hi Noel,

> I am transferring an H2 database from a Windows PC to a late model Apple
> Mac, (Capitan 10.11.6).  On the main Base window, the Tables are all
> displaying normally, but nothing shows up under Queries, Forms or Reports.

Did you create queries, forms and reports for the database in a
Base-file on the Windows PC? Do you use the same Base-file on Apple now?

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
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] LO Base Queries, Forms & Reports not appearing

[Marion & Noel Lodge]

I am transferring an H2 database from a Windows PC to a late model Apple
Mac, (Capitan 10.11.6).  On the main Base window, the Tables are all
displaying normally, but nothing shows up under Queries, Forms or Reports.

I've hunted through all LO's options, but I can't find any setting that
might be inhibiting these displays.  Is there an equivalent of Tools |
Table Filter, for Queries, Forms or Reports?  Alternatively, is there some
sort of security setting on the Mac that might be hiding these details?

Any ideas where else I could be looking?

Thanks,

Noel
--
Noel Lodge
lodg...@gmail.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] LO base reference?

[Robert Großkopf]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Dave,
> 
> I'm involved in a project that will produce a dataset as its
> product. I'm considering using LO base so as to avoid vendor
> lock-in. I've found a base document from 2014 that seems promising,
> is there a more up-to-date place to start reading?

You could get the Base-Handbook here:
http://www.libreoffice.org/get-help/documentation/

... but it is only the first version. Translation of newer versions
seems to be a little problem ...

The German version from 2007 you could get here:
http://de.libreoffice.org/get-help/documentation/

I have written most of the content. So feel free to ask me. You could
also contact me directly.

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJZDs/2AAoJELDKYwaoS9AIFsQP+wdxyhAJTk7A+7Uk7ldU+Tx9
Us9SLOKSe2Jy1hE6sVhbo4QH+olW3lRIuiYOZuqD5AksINRCZLqSFEMnjGeTXgmN
Gd145qK2UttTXxB9AxgDDJsRy582/Z2rXHuEl7yBvUk3mhZ4LY0MjOBVgczAKlx3
m+T2ZNiWB2Sn0zwqa9nI91oVW+OMF5XrzuaQD31tyQi8kofgqQzmDUSJNQYit88X
xqVw+s16FLH9aZ0YI94oFPmT9CWOuXmbrqKMm8IXwfmQPVrcP8++hYw3nFrlVpIM
buOZRdsl5cqdvB12JGuESxk8zNnKFWAdWxDcHwkHUw5IA01NXLLjmXiSQe/jSnIt
jCKyYaFyO0cIRvVzX6D9U5tVZ4jmH6MoM4FxSNWL1FrODlY5HkHqrTiFHgmE35Hh
WCGGcsk74usy5wXXa4jkymZGwVVIUA0rHvdamRzqlC/NwIFq6g6EfRTvmcsLPVXG
nUkqFep8E8EKXZM93CxWMprdZBDJQPjHDr4rr9HkAe8lo0Zg1x/zBViLicwIy4x+
0O5nJlw3CSWCJLX0dNaunkr3oDqnLjBrCaw3gVuvob+oOzwh7gkARSJTieIRQMe4
9c3H5ZjW+ydQK2lzOc9GoSqx8nbQC0jLUws2A0gBqzH+Y2QywfS0OfESXoolWZ1w
4b63lkHB1Hfg3aysULXu
=C1Mx
-END PGP SIGNATURE-

-- 
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] LO base reference?

[Dave Stevens]

Hi,

I'm involved in a project that will produce a dataset as its product.  
I'm considering using LO base so as to avoid vendor lock-in. I've  
found a base document from 2014 that seems promising, is there a more  
up-to-date place to start reading?


Also the dataset is likely to be subsequently used by a very diverse  
group widely distributed. I've been thinking that a big csv file might  
be sufficiently interoperable, I don't see an option to export data  
this way. Is it possible or am I missing something that ought to be  
obvious?


I suppose it's clear I'm a complete newbie, any advice appreciated.

Dave


--
"As long as politics is the shadow cast on society by big business,
the attenuation of the shadow will not change the substance."

-- John Dewey






--
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] LO Base

[Bruce Hohl]

> I have recently read that Open Office no longer uses HSQL. Is that also
true of LO?
If a new Base is created in LO 5.1.x it will be default is "HSQLDB
Embedded" to store the data.

> is it really necessary to have another database product to do database
work in LO Base?
Not necessarily, but this is a feature which allows Base to be used as
front end to another database.  This might be done for various reasons like
(1) the other database already includes the needed data, (2) a concurrent
multi-user environment is wanted which is not available via HSQLDB embedded
but is possible with HSQL split , (3) a wanted feature is available in
another database but not in HSQL, (4) a preference for another database,
Etc.  Reference this: https://wiki.openoffice.org/wiki/FAQ_(Base)

On Sat, Jul 30, 2016 at 8:53 PM, Dale Erwin 
wrote:

> I have a question about Base:
>
> I used to work with standalone HSQLDB using Java on the OS/2 (eCS)
> platform.  During that time, it was announced that Sun's upcoming release
> of Open Office would include HSQL as the builtin database engine.  I have
> recently read that Open Office no longer uses HSQL. Is that also true of LO?
>
> If HSQL is indeed the builtin database engine, is it really necessary to
> have another database product to do database work in LO Base?
>
> I stopped using eCS a few years ago when the (at the time) latest version
> would not install on my new computer.  I am now using Windows 10 (which I
> literally despise).
>
> Dale Erwin
>
> --
> 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] LO Base

[Dale Erwin]

I have a question about Base:

I used to work with standalone HSQLDB using Java on the OS/2 (eCS) 
platform.  During that time, it was announced that Sun's upcoming 
release of Open Office would include HSQL as the builtin database 
engine.  I have recently read that Open Office no longer uses HSQL. Is 
that also true of LO?


If HSQL is indeed the builtin database engine, is it really necessary to 
have another database product to do database work in LO Base?


I stopped using eCS a few years ago when the (at the time) latest 
version would not install on my new computer.  I am now using Windows 10 
(which I literally despise).


Dale Erwin

--
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] LO Base - Dropdown boxes

[Tom Davies]

Hi :)
Sorry you have not had any responses so far.  Hopefully someone might be
able to help in a while.  Sometimes it is a good idea to "bump the thread"
(which my reply here will do) in order to get your question back to the top
of the mailing list.
Regards from
Tom :)


On 26 June 2016 at 15:20, Ian Whitfield  wrote:

> Hi all
>
> I'm trying to use LO Base - linked to a Spreadsheet and so far all is
> going well.
> However I don't seem to be able to get Dropdown Boxes to work. On my 'User
> Form' they are greyed out and do not react when clicked. I have set them to
> be Dropdown, entered the list of options and set the display line number.
> Any ideas please?? They worked with HSQLDB but I've had too many crashes
> and lost data with that system so am trying a Spreadsheet source instead.
> Do they work with this system??
>
> My OpSys is PClinuxOS and LO is version 5.1.4.2.
>
> Thanks a lot
>
> 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
>

-- 
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] LO Base - Dropdown boxes

[Ian Whitfield]

Hi all

I'm trying to use LO Base - linked to a Spreadsheet and so far all is 
going well.
However I don't seem to be able to get Dropdown Boxes to work. On my 
'User Form' they are greyed out and do not react when clicked. I have 
set them to be Dropdown, entered the list of options and set the display 
line number.
Any ideas please?? They worked with HSQLDB but I've had too many crashes 
and lost data with that system so am trying a Spreadsheet source 
instead. Do they work with this system??


My OpSys is PClinuxOS and LO is version 5.1.4.2.

Thanks a lot

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

Re: [libreoffice-users] LO-Base - Autoreconnect

[Walther Koehler]

Hello list,

me too would like to have a reconnect:

When LO-Base the first connection to a dBase 
database (directory) has made, all the existing *.dbf files in that directory 
are recognized and shown as tables in *.odb.

However, if you add manually or by a third party program another *.dbf, it is 
not recognized until one terminates the running LO (usually with many open 
writer, calc files).

Is there a way other than by a makro (getTables()) to update the tables 
(=*.dbf file list) while in LO Base?

Walther

-- 
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] LO-Base - Autoreconnect

[Tom Davies]

Hi :)
That might be another neat work-around, perhaps as a 'temporary' system
while waiting for more devs to join in with working on Base.
Regards from
Tom :)



On Wednesday, 27 January 2016, Dries Feys  wrote:

> Hello Heinrich,
>
> I never used Base, though for other projects I use MySQL and other db's.
> As a workaround, I wonder whether it is possible to disconnect the
> database from within LO after each query? Then, you should be able to
> reconnect when a new query is requested. This also has the advantage
> you won't have many simultaneous connections on the db.
>
> Met vriendelijke groeten, Salutations distinguées, Kind Regards,
>
> DRIES FEYS
> CORPORATE SERVICES • Specialist Software Developer
>
> TVH GROUP NV
> Brabantstraat 15 • BE-8790 WAREGEM
> T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
> Watch our company movies on www.tvh.tv
>
>
>
> Business Innovation
> through
> Information Technology
> bi2t.tvh.com
>
>
> On 27 January 2016 at 11:29, Heinrich Stoellinger  > wrote:
> > Hello,
> > I have been an avid user of LO/OO-Base for years, using it to connect to
> a
> > MySQL database for everyday work --- couldn't do without it. I am
> convinced
> > that a good connection to a DB-backend like MySQL/MariaDB is essential
> for
> > LO to be successful in a "real" business environment.
> > As I have mentioned in earlier messages to the list, I use JDBC to
> connect
> > to my remote DB-server as well as the native MySQL-connector for my local
> > test server.
> > Unfortunately I don't have access to the remote server and therefore
> cannot
> > change its idle-timeout, which is set at 60 seconds.
> > On my Linux-Mint system I also connect to the server via the command line
> > MySQL client. If - after going away for more than 60 seconds - I come
> back
> > to do more work, the client reports the timeout, but reconnects
> > automatically.
> > This is kind of acceptable, even in a business production environment.
> > Unfortunately the native connector does not support "autoreconnect". This
> > means that one would have to restart LO in case of a timeout
> (unacceptable
> > for "serious" work!) On the other hand, JDBC does allow the
> specification of
> > "autoreconnect=true" as part of a connect string. However, unlike in the
> > case
> > of the MySQL command-line client, LO-Base doesn't simply reconnect
> > AUTOMATICALLY,
> > but displays a message such as "The last package sent to the server was x
> > seconds ago, the lase received packed was y seconds ago".
> > This means that whenever a timeout occurs, one has to confirm the wish to
> > reconnect - even though one has specified that one wants to do this in
> the
> > connect string when defining the DB-connection properties in the first
> > place!
> > I wonder how difficult it would be to implement such a REALLY automatic
> > reconnection...
> > Regards (and I appologise for the lengthy description...)
> > H. Stoellinger
> >
> >
> > --
> > Erstellt mit Operas revolutionärem E-Mail-Modul:
> http://www.opera.com/mail/
> >
> > --
> > 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
> >
>
> --
>
>
>  DISCLAIMER 
>
> http://www.tvh.com/glob/en/email-disclaimer
>
> "This message is delivered to all addressees subject to the conditions
> set forth in the attached disclaimer, which is an integral part of this
> message."
>
> --
> 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] LO-Base - Autoreconnect

[Heinrich Stoellinger]

Hello,
I have been an avid user of LO/OO-Base for years, using it to connect to a
MySQL database for everyday work --- couldn't do without it. I am convinced
that a good connection to a DB-backend like MySQL/MariaDB is essential for
LO to be successful in a "real" business environment.
As I have mentioned in earlier messages to the list, I use JDBC to connect
to my remote DB-server as well as the native MySQL-connector for my local
test server.
Unfortunately I don't have access to the remote server and therefore cannot
change its idle-timeout, which is set at 60 seconds.
On my Linux-Mint system I also connect to the server via the command line
MySQL client. If - after going away for more than 60 seconds - I come back
to do more work, the client reports the timeout, but reconnects automatically.
This is kind of acceptable, even in a business production environment.
Unfortunately the native connector does not support "autoreconnect". This
means that one would have to restart LO in case of a timeout (unacceptable
for "serious" work!) On the other hand, JDBC does allow the specification of
"autoreconnect=true" as part of a connect string. However, unlike in the case
of the MySQL command-line client, LO-Base doesn't simply reconnect 
AUTOMATICALLY,
but displays a message such as "The last package sent to the server was x
seconds ago, the lase received packed was y seconds ago".
This means that whenever a timeout occurs, one has to confirm the wish to
reconnect - even though one has specified that one wants to do this in the
connect string when defining the DB-connection properties in the first place!
I wonder how difficult it would be to implement such a REALLY automatic
reconnection...
Regards (and I appologise for the lengthy description...)
H. Stoellinger


--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
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] LO-Base - Autoreconnect

[Dries Feys]

Hello Heinrich,

I never used Base, though for other projects I use MySQL and other db's.
As a workaround, I wonder whether it is possible to disconnect the
database from within LO after each query? Then, you should be able to
reconnect when a new query is requested. This also has the advantage
you won't have many simultaneous connections on the db.

Met vriendelijke groeten, Salutations distinguées, Kind Regards,

DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer

TVH GROUP NV
Brabantstraat 15 • BE-8790 WAREGEM
T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
Watch our company movies on www.tvh.tv



Business Innovation
through
Information Technology
bi2t.tvh.com


On 27 January 2016 at 11:29, Heinrich Stoellinger  wrote:
> Hello,
> I have been an avid user of LO/OO-Base for years, using it to connect to a
> MySQL database for everyday work --- couldn't do without it. I am convinced
> that a good connection to a DB-backend like MySQL/MariaDB is essential for
> LO to be successful in a "real" business environment.
> As I have mentioned in earlier messages to the list, I use JDBC to connect
> to my remote DB-server as well as the native MySQL-connector for my local
> test server.
> Unfortunately I don't have access to the remote server and therefore cannot
> change its idle-timeout, which is set at 60 seconds.
> On my Linux-Mint system I also connect to the server via the command line
> MySQL client. If - after going away for more than 60 seconds - I come back
> to do more work, the client reports the timeout, but reconnects
> automatically.
> This is kind of acceptable, even in a business production environment.
> Unfortunately the native connector does not support "autoreconnect". This
> means that one would have to restart LO in case of a timeout (unacceptable
> for "serious" work!) On the other hand, JDBC does allow the specification of
> "autoreconnect=true" as part of a connect string. However, unlike in the
> case
> of the MySQL command-line client, LO-Base doesn't simply reconnect
> AUTOMATICALLY,
> but displays a message such as "The last package sent to the server was x
> seconds ago, the lase received packed was y seconds ago".
> This means that whenever a timeout occurs, one has to confirm the wish to
> reconnect - even though one has specified that one wants to do this in the
> connect string when defining the DB-connection properties in the first
> place!
> I wonder how difficult it would be to implement such a REALLY automatic
> reconnection...
> Regards (and I appologise for the lengthy description...)
> H. Stoellinger
>
>
> --
> Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/
>
> --
> 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
>

-- 


 DISCLAIMER 

http://www.tvh.com/glob/en/email-disclaimer

"This message is delivered to all addressees subject to the conditions
set forth in the attached disclaimer, which is an integral part of this
message."

-- 
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] LO-Base - Autoreconnect

[Tom Davies]

Hi :)
If you haven't already done so then posting this idea as a "feature
request" would be a really good way forwards.  Unfortunately not many devs
dare take on the challenge of working with Base.  So the next step might be
to promote it somewhere, preferably in a few different places.  This
mailing list is a good one.  Perhaps a MySql forum too.  Perhaps some sort
of crowd-funding or crowd sourcing place.  So, i think you are already
doing the right sorts of things.

Wrt trying to access a remote server, perhaps using ssh from a linux
command-line might be a way in?  Dealing with the server's sys.admin might
be a blocker, or rather finding a way of contacting them might be.
Regards from
Tom :)

On Wednesday, 27 January 2016, Heinrich Stoellinger 
wrote:

> Hello,
> I have been an avid user of LO/OO-Base for years, using it to connect to a
> MySQL database for everyday work --- couldn't do without it. I am convinced
> that a good connection to a DB-backend like MySQL/MariaDB is essential for
> LO to be successful in a "real" business environment.
> As I have mentioned in earlier messages to the list, I use JDBC to connect
> to my remote DB-server as well as the native MySQL-connector for my local
> test server.
> Unfortunately I don't have access to the remote server and therefore cannot
> change its idle-timeout, which is set at 60 seconds.
> On my Linux-Mint system I also connect to the server via the command line
> MySQL client. If - after going away for more than 60 seconds - I come back
> to do more work, the client reports the timeout, but reconnects
> automatically.
> This is kind of acceptable, even in a business production environment.
> Unfortunately the native connector does not support "autoreconnect". This
> means that one would have to restart LO in case of a timeout (unacceptable
> for "serious" work!) On the other hand, JDBC does allow the specification
> of
> "autoreconnect=true" as part of a connect string. However, unlike in the
> case
> of the MySQL command-line client, LO-Base doesn't simply reconnect
> AUTOMATICALLY,
> but displays a message such as "The last package sent to the server was x
> seconds ago, the lase received packed was y seconds ago".
> This means that whenever a timeout occurs, one has to confirm the wish to
> reconnect - even though one has specified that one wants to do this in the
> connect string when defining the DB-connection properties in the first
> place!
> I wonder how difficult it would be to implement such a REALLY automatic
> reconnection...
> Regards (and I appologise for the lengthy description...)
> H. Stoellinger
>
>
> --
> Erstellt mit Operas revolutionärem E-Mail-Modul:
> http://www.opera.com/mail/
>
> --
> 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

Re: [libreoffice-users] LO-Base - Autoreconnect

[Heinrich Stoellinger]

Hello,
Thanks for the quick replies. Some points...
Disconnecting/Reconnecting the MySQL server from LO-DB is not really a
work-around. Essentially confirming the displayed message mentioned (i.e.
"The last package sent to the server...") with just one click is in my
opinion more efficient, although not really good enough for somebody not
quite as "benevolent" as myself wrt doing "serious" day to day work with 
LO-BASE.
Regarding SSH to the server: I use the MySQL client all the time without 
problems
from my LOCAL machine anyway without having to use SSH, which - by the way -
I am not allowed to use either by the sysadmin at the server. However, while the
MySQL client is o.k. for DB-Admins to do maintenance work (like backups), it is
not fit for everyday production type transaction-type work. By the way - the 
same
applies also to tools like phpMyAdmin or MySQL workbench.
I will look into this as a feature request...
Regards from Salzburg (hardly any snow here - in January! Where is the world
getting to, I wonder!

On Wed, 27 Jan 2016 11:53:18 +0100, Tom Davies  wrote:


Hi :)
If you haven't already done so then posting this idea as a "featurerequest" 
would be a really good way forwards.  Unfortunately not many devs
dare take on the challenge of working with Base.  So the next step might be
to promote it somewhere, preferably in a few different places.  This
mailing list is a good one.  Perhaps a MySql forum too.  Perhaps some sort
of crowd-funding or crowd sourcing place.  So, i think you are already
doing the right sorts of things.

Wrt trying to access a remote server, perhaps using ssh from a linux
command-line might be a way in?  Dealing with the server's sys.admin might
be a blocker, or rather finding a way of contacting them might be.
Regards from
Tom :)

On Wednesday, 27 January 2016, Heinrich Stoellinger 
wrote:


Hello,
I have been an avid user of LO/OO-Base for years, using it to connect to a
MySQL database for everyday work --- couldn't do without it. I am convinced
that a good connection to a DB-backend like MySQL/MariaDB is essential for
LO to be successful in a "real" business environment.
As I have mentioned in earlier messages to the list, I use JDBC to connect
to my remote DB-server as well as the native MySQL-connector for my local
test server.
Unfortunately I don't have access to the remote server and therefore cannot
change its idle-timeout, which is set at 60 seconds.
On my Linux-Mint system I also connect to the server via the command line
MySQL client. If - after going away for more than 60 seconds - I come back
to do more work, the client reports the timeout, but reconnects
automatically.
This is kind of acceptable, even in a business production environment.
Unfortunately the native connector does not support "autoreconnect". This
means that one would have to restart LO in case of a timeout (unacceptable
for "serious" work!) On the other hand, JDBC does allow the specification
of
"autoreconnect=true" as part of a connect string. However, unlike in the
case
of the MySQL command-line client, LO-Base doesn't simply reconnect
AUTOMATICALLY,
but displays a message such as "The last package sent to the server was x
seconds ago, the lase received packed was y seconds ago".
This means that whenever a timeout occurs, one has to confirm the wish to
reconnect - even though one has specified that one wants to do this in the
connect string when defining the DB-connection properties in the first
place!
I wonder how difficult it would be to implement such a REALLY automatic
reconnection...
Regards (and I appologise for the lengthy description...)
H. Stoellinger


--
Erstellt mit Operas revolutionärem E-Mail-Modul:
http://www.opera.com/mail/

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







--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
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] LO-Base

[Heinrich Stoellinger]

Hello,
I have been using OO/LO for more than a decade now and have liked it most of the
time. At the moment I have to print labels from a MySQL database connected 
through
JDBC. My system is Linux-Mint 17.2 and LO 5.0.2. I also use the same LO version
on a Debian 8 and Windows 7 system. I have the following problems (which I did 
NOT
have before):
(1) LO does not honor my action when I try to change the database source for the
DB-fields. In fact, on the labels there are 4 variables which should come from a
particular view in the database. When I specify "change database", only ONE of 
the
fields points to the view in the "new" database. I have tried saving/closing and
reloading the Write file that contains the references to the DB-fields, even
shutting down LO and restarting - no success!
(2) In the writer file I define a varying number of lables that should get their
data filled from an equivalent number of selected database records. I specify
"next DB-record" in the last field of every label (except of course the last 
label).
In the case of only 2 labels (2 DB-records), LO only prints the first one. When
I try to print 6 labels for example, it only prints numbers 1, 3, 5.
Very annoying! It always used to function without problems. I have tried things
out also on LO 4.4.5 (running on Debian, Mint, and Windows 7) -- same result.
The same also happens when connecting to the DB using the native MySQL 
connector.
It seems to me that Base has been a kind of stepchild in LO. To me (and my
guess is -- also to most serious users in enterprise environments), this is a
unacceptable situation.
Any help would be greatly appreciated.
H. Stoellinger

--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
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] LO Base Problem

[Ian Whitfield]

*Hi All*

I have been rebuilding/revamping my Database over the past few weeks and 
everything has been going great.

I'm using LO 4.3.5.2 and MySQL 5.1.73 on PClinuxOS (latest).

Yesterday I found I had not set my Keyfield (RecordID) to Auto Increment 
so I set a new field with phpMyAdmin called 'id'. And this is now 
working fine and Auto incrementing. I deleted the old RecordID field.


Now many of my fields are greyed out in the Form and will not accept 
input and all my drop-down boxes are inactive.


I created a new temporary Form (using the Wizard) and it works fine and 
displays all fields. But as soon as I replace a field with a drop-down 
or Combo Box box that box becomes inactive again and is greyed out and 
will not display the options.


I've looked everywhere in the field properties but can find no obvious 
cause.


Anyone have any ideas please?? Thanks.

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

Re: [libreoffice-users] LO Base Problem

[SOS]

On 18/02/2015 15:23, Ian Whitfield wrote:

*Hi All*

I have been rebuilding/revamping my Database over the past few weeks 
and everything has been going great.

I'm using LO 4.3.5.2 and MySQL 5.1.73 on PClinuxOS (latest).

Yesterday I found I had not set my Keyfield (RecordID) to Auto 
Increment so I set a new field with phpMyAdmin called 'id'. And this 
is now working fine and Auto incrementing. I deleted the old RecordID 
field.


Now many of my fields are greyed out in the Form and will not accept 
input and all my drop-down boxes are inactive.
probably in your data properties from the greyedout ListBoxcontrols 
you have used in a sql statement the name off the deleted field or the 
data connection is based on this deleted fields ?


Hope it helps

fernand


I created a new temporary Form (using the Wizard) and it works fine 
and displays all fields. But as soon as I replace a field with a 
drop-down or Combo Box box that box becomes inactive again and is 
greyed out and will not display the options.


I've looked everywhere in the field properties but can find no obvious 
cause.


Anyone have any ideas please?? Thanks.

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

[libreoffice-users] LO Base Error: DB Created By Newer Version

[Mark LaPierre]

Hey Y'all,

I'm following directions in GS40-GettingStartedLO Chapter 8.  I created
a new database, and then created the Fuel table per the instructions.

I saved the table and the database, then closed the database.

When I open the database, and click on the Tables icon I get this error:

The connection to the data source NAME OF DB could not be established.
The connection could not be established.  The database was created by a
newer version of LibreOffice.

When I click the [More] button on the bottom of the error box I get two
errors listed.

The first says, The connection to the data source NAME OF DB could
not be established.

The second says:
SQL STATUS: HY000

The connection could not be established.  The database was created by a
newer version of LibreOffice.

No it wasn't!  It was created just a minute ago on the same machine, buy
the same user, with the same version of LO.

I tried erasing and then reinstalling LO and building a whole new
database.  Same result.

I'm using:

LO Base, Version 4.0.4.2 (Build ID: 4.0.4.2-9.el6)
JRE, Sun Microsystems Inc. 1.6.0_30 with accessibility support

CentOS release 6.5 (Final)

Linux mushroom.patch 2.6.32-431.5.1.el6.i686 #1 SMP Tue Feb 11 21:56:33
UTC 2014 i686 i686 i386 GNU/Linux

22:37:28 up 5 days,  1:46,  2 users,  load average: 1.33, 1.17, 1.11

Now the money question.  How do I fix this?

-- 
_
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/


-- 
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] LO Base: MySQL or Mariadb ?

[Jay Lozier]

Hi,

MariaDB is compatible with MySQL, the MySQL connectors, and MySQL API 
and is designed to be a drop-in replacement for MySQL. I have connected 
to MariaDB using the LO provided MySQL connector on earlier versions of 
LO. I have not done so with 4.1.X yet.


Jay
On 02/09/2014 03:16 PM, Tom Davies wrote:

Hi :)
I think we have heard from people who have tried it.  I think Ian or
someone started with MySql and then swapped it out replacing it with
MariaDb.  I'm not sure but i think there might be a problem with
MariaDb on Mac but if you are not using a Mac then it should be fine.
Regards from
Tom :)



On 9 February 2014 20:00, Joel Madero jmadero@gmail.com wrote:

On 02/09/2014 11:38 AM, Harvey Nimmo wrote:

Can I use Mariadb as back-end for LO Base or must it be MySQL? For
example, are the connectors compatible or is there a Mariadb-specific
connector?

Cheers
Harvey



Looks like it's possible -
http://ask.libreoffice.org/en/question/18521/how-to-connect-lobase-to-use-mariadb-created-db/
but I've never done it.


Best,
Joel

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


--
Jay Lozier
jsloz...@gmail.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] LO Base: MySQL or Mariadb ?

[Andrew Douglas Pitonyak]

I have seen nothing that indicates that you cannot use Maria DB as a 
drop-in replacement for MySQL at this point.


Last I tried it was with Drupal 7. It just worked. I expect the same for 
Base, if it is not so, file a bug report against Maria DB.


--
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] LO Base: MySQL or Mariadb ?

[Anthony Baldwin]

On 2/10/2014 9:20 AM, Andrew Douglas Pitonyak wrote:

I have seen nothing that indicates that you cannot use Maria DB as a
drop-in replacement for MySQL at this point.

Last I tried it was with Drupal 7. It just worked. I expect the same for
Base, if it is not so, file a bug report against Maria DB.



I'm using MariaDB on all of my web servers, and it really is a drop-in 
replacement.

I uninstalled mysql, installed mariadb, and bo0m, everything just worked.
I've used it with webservers running a broad spectrum of applications, 
including drupal, wordpress, joomla, scuttle, friendica, redmatrix, 
knoxious pastebin, statusnet, piwigo, gallery3, and more.


I have not used it with LObase, though.

I imagine it would work just fine.

Tony
--
http://www.baldwinlinguas.com
translations, localization,
multilingual web development
EN, ES, FR, PT
203-759-8352

--
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] LO Base: MySQL or Mariadb ?

[Harvey Nimmo]

Can I use Mariadb as back-end for LO Base or must it be MySQL? For
example, are the connectors compatible or is there a Mariadb-specific
connector?

Cheers
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

Re: [libreoffice-users] LO Base: MySQL or Mariadb ?

[Joel Madero]

On 02/09/2014 11:38 AM, Harvey Nimmo wrote:
 Can I use Mariadb as back-end for LO Base or must it be MySQL? For
 example, are the connectors compatible or is there a Mariadb-specific
 connector?

 Cheers
 Harvey


Looks like it's possible -
http://ask.libreoffice.org/en/question/18521/how-to-connect-lobase-to-use-mariadb-created-db/
but I've never done it.


Best,
Joel

-- 
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] LO Base: MySQL or Mariadb ?

[Girvin Herr]

On 02/09/2014 12:00 PM, Joel Madero wrote:

On 02/09/2014 11:38 AM, Harvey Nimmo wrote:

Can I use Mariadb as back-end for LO Base or must it be MySQL? For
example, are the connectors compatible or is there a Mariadb-specific
connector?

Cheers
Harvey



Looks like it's possible -
http://ask.libreoffice.org/en/question/18521/how-to-connect-lobase-to-use-mariadb-created-db/
but I've never done it.


Best,
Joel

I, too, am faced with switching to Mariadb, since the latest Slackware 
Linux has switched from MySQL to Mariadb.  I looked on the Mariadb 
website and they are claiming full compatibility with everything, 
including the connectors.  I have yet to confirm that, but I am 
hopeful.  I did notice that Mariadb even goes so far as to keep the 
MySQL utility program names, such as mysql_install_db.  So even existing 
MySQL scripts should work with Mariadb.  That is pretty compatible.

Good luck.
Girvin Herr


--
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] LO Base: MySQL or Mariadb ?

[Tom Davies]

Hi :)
I think we have heard from people who have tried it.  I think Ian or
someone started with MySql and then swapped it out replacing it with
MariaDb.  I'm not sure but i think there might be a problem with
MariaDb on Mac but if you are not using a Mac then it should be fine.
Regards from
Tom :)



On 9 February 2014 20:00, Joel Madero jmadero@gmail.com wrote:
 On 02/09/2014 11:38 AM, Harvey Nimmo wrote:
 Can I use Mariadb as back-end for LO Base or must it be MySQL? For
 example, are the connectors compatible or is there a Mariadb-specific
 connector?

 Cheers
 Harvey


 Looks like it's possible -
 http://ask.libreoffice.org/en/question/18521/how-to-connect-lobase-to-use-mariadb-created-db/
 but I've never done it.


 Best,
 Joel

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

Re: [libreoffice-users] LO Base/MySQL questions

[Andrew Douglas Pitonyak]

On 02/07/2014 09:07 AM, Ian Whitfield wrote:

Sorry All

I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55

A MySQL 'expert' was telling me recently that HSQL is only meant to be 
a prototyping utility and should *NEVER* be used for any proper work 
- - interesting!!??


I can confirm that when it crashes it takes everything with it so you 
have to backup every time you make change. This is what forced me to 
MySQL.


Thanks again


I had a lot of trouble a while back, so I stopped using it and started 
writing my own program in C++. Of course, this is time consuming, but it 
is something I enjoy doing.


That said, I did write some things through MySQL with no problems.

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

[libreoffice-users] LO Base/MySQL questions

[Ian Whitfield]

Hi All

I've been using the Base/MySQL combination since mid-last year now and 
it is fantastic!! It is much faster, never crashes or freezes and just 
works the way it is supposed to. I can definitely recommend it to 
anyone!! (In my opinion this should be the standard and HSQL should be 
dropped)


Now I have a couple of questions...

1) Where does MySQL store the Database? (I think it's in the root somewhere)
2) Is it easy to move it into the /home directory?
3) Where do I find the LO front-end form?
4) If I copy these two files to another machine will I be able to get 
the Database running on this second machine?


Side question

I have a couple of graphics/photos in each record - Is it possible to 
'Link' these instead of embedding them so that if you up-date a photo it 
will automatically update in the Database? If this is possible will it 
effect Base at all? (faster, slower etc)


Thanks for any help

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

Re: [libreoffice-users] LO Base/MySQL questions

[Andrew Douglas Pitonyak]

On 02/07/2014 02:38 AM, Ian Whitfield wrote:


Hi All

I've been using the Base/MySQL combination since mid-last year now and 
it is fantastic!! It is much faster, never crashes or freezes and just 
works the way it is supposed to. I can definitely recommend it to 
anyone!! (In my opinion this should be the standard and HSQL should be 
dropped)


The advantage of HSQL is that it creates a single file and you do not 
need to run a database daemon in the background (I am assuming that the 
MySQL connector uses that rather than knowing how to read the MySQL 
files directly).  In other words, it does serve a need.


The disadvantage of HSQL, (speculation, so assume half of what I am 
about to say is wrong) is that it sounds less stable, if you crash Base, 
it is more likely to lose data, and everything stays in memory.




Now I have a couple of questions...

1) Where does MySQL store the Database? (I think it's in the root 
somewhere)


Are you using Windows or Linux? Try looking under something like:

C:\Program Files\MySQL\MySQL Server #.#\my.ini

Look in that file for the basedir and datadir variables.

And now I see I need to run.


2) Is it easy to move it into the /home directory?
3) Where do I find the LO front-end form?
4) If I copy these two files to another machine will I be able to get 
the Database running on this second machine?


Side question

I have a couple of graphics/photos in each record - Is it possible to 
'Link' these instead of embedding them so that if you up-date a photo 
it will automatically update in the Database? If this is possible will 
it effect Base at all? (faster, slower etc)


Thanks for any help

IanW
Pretoria RSA.



--
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] LO Base/MySQL questions

[Jay Lozier]

On 02/07/2014 08:40 AM, Andrew Douglas Pitonyak wrote:

On 02/07/2014 02:38 AM, Ian Whitfield wrote:


Hi All

I've been using the Base/MySQL combination since mid-last year now 
and it is fantastic!! It is much faster, never crashes or freezes and 
just works the way it is supposed to. I can definitely recommend it 
to anyone!! (In my opinion this should be the standard and HSQL 
should be dropped)


The advantage of HSQL is that it creates a single file and you do not 
need to run a database daemon in the background (I am assuming that 
the MySQL connector uses that rather than knowing how to read the 
MySQL files directly).  In other words, it does serve a need.


The disadvantage of HSQL, (speculation, so assume half of what I am 
about to say is wrong) is that it sounds less stable, if you crash 
Base, it is more likely to lose data, and everything stays in memory.


I think the other reason for using HSQL is it is easier to use as an 
embedded database while MySQL/MariaDB, PostgreSQL, etc. require the 
separate install of the database. The others are designed as stand-alone 
databases that one can connect to using a variety of tools.


Now I have a couple of questions...

1) Where does MySQL store the Database? (I think it's in the root 
somewhere)


Are you using Windows or Linux? Try looking under something like:

C:\Program Files\MySQL\MySQL Server #.#\my.ini

Look in that file for the basedir and datadir variables.

And now I see I need to run.


2) Is it easy to move it into the /home directory?
3) Where do I find the LO front-end form?
4) If I copy these two files to another machine will I be able to get 
the Database running on this second machine?


Side question

I have a couple of graphics/photos in each record - Is it possible to 
'Link' these instead of embedding them so that if you up-date a photo 
it will automatically update in the Database? If this is possible 
will it effect Base at all? (faster, slower etc)
Storing the link to the photo should make the database query run faster 
because the text string is orders of magnitude smaller than the photo. 
One problem is one must be very carefully about naming the photos.


Thanks for any help

IanW
Pretoria RSA.





--
Jay Lozier
jsloz...@gmail.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] LO Base/MySQL questions

[Ian Whitfield]

Sorry All

I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55

A MySQL 'expert' was telling me recently that HSQL is only meant to be a 
prototyping utility and should *NEVER* be used for any proper work - - 
interesting!!??


I can confirm that when it crashes it takes everything with it so you 
have to backup every time you make change. This is what forced me to MySQL.


Thanks again




--
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] LO Base/MySQL questions

[null]

Hello,
On 2/7/2014 9:07 AM, Ian Whitfield wrote:

Sorry All

I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55
Do you know the path of the installation directory for MySQL?  There 
should be a my.cnf file somewhere in it.  If you can't find it, you can 
run sudo find / -name my.cnf in your terminal.  Once you find the 
path, open the file.  You can run sudo cat /path/to/my.cnf (where 
/path/to/my.cnf is the path you found earlier to your my.cnf file) in 
your terminal.  Once opened, you should find a key called datadir, 
which has the location of the data directory for MySQL. However, MySQL 
data usually has to be read by the server itself, since the data  cannot 
be gathered easily.  You could just execute the SQL query SELECT * FROM 
database with database being the database name.
You could move the data directory to somewhere in /home (like you asked) 
and change the datadir in my.cnf.  I don't know if you could move your 
database to another server; maybe if the MySQL version was the same, you 
could the data directory, but there are other files that might have to 
be copied.  Even transferring to a server with another operating system 
could be a difficult task.


A MySQL 'expert' was telling me recently that HSQL is only meant to be 
a prototyping utility and should *NEVER* be used for any proper work 
- - interesting!!??


I can confirm that when it crashes it takes everything with it so you 
have to backup every time you make change. This is what forced me to 
MySQL.


Thanks again





Regards,
xmlhttprequest.o...@gmail.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] LO Base/MySQL questions

[Jay Lozier]

On 02/07/2014 09:07 AM, Ian Whitfield wrote:

Sorry All

I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55

A MySQL 'expert' was telling me recently that HSQL is only meant to be 
a prototyping utility and should *NEVER* be used for any proper work 
- - interesting!!??


I can confirm that when it crashes it takes everything with it so you 
have to backup every time you make change. This is what forced me to 
MySQL.


Thanks again



Ian,

I do not know if HSQL is only intended for prototyping and thus is not 
suitable for production work. I would say as a MySQL/MariaDB user is 
that HSQL is probably intended for lighter production work where a small 
office needs a database. In this scenario the data requirements are 
modest, maybe a couple GB of data, but their data is complex enough to 
need the querying features of a relational database.


--
Jay Lozier
jsloz...@gmail.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] LO Base/MySQL questions

[Lens Paul]

Hello,

This instability of HSQL is worrying when using the same database year 
after year, e.g. an address or a bibliographic database.


For my part, all my data remain in separate external tables in dbf 
format, linked to Base.


Reasons are:
- compatibility with many programmes and readability of old archives, 
even in case of change of database program ;

- stability in the long run;
- format compatible with GIS software;
- when the tables are not merged in one file, the loss is limited when 
one of the tables gets corrupted.


The main drawback is the impossibility to make a relational database.


In fact, the good integration of the office suite with a database was 
one of the main reason's why I began to use OO in 2007 or 2008.


To my great satisfaction indeed: it works very well, except for two 
instances, several years ago, where the dbf file got corrupted (luckily, 
recovery from backups was easy).
Since then it works fine without any failure (except, rarely, for some 
data in memo fields, which can lose the right connection with other data 
(dbt file connection to dbf file)).


Nevertheless, the impossibility of making relations between tables is 
rather frustrating.
One solution is to migrate to a mySQL/Base or preferably Postgresql 
(because of PostGIS). It's my intention but I fear to waste a lot of 
time in migrating.


What is the best combination for a single user, relational database, 
stable in the long run, using Base as the front end?



Paul Lens
  


Le 7/02/2014 15:07, Ian Whitfield a écrit :

Sorry All

I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55

A MySQL 'expert' was telling me recently that HSQL is only meant to be 
a prototyping utility and should *NEVER* be used for any proper work 
- - interesting!!??


I can confirm that when it crashes it takes everything with it so you 
have to backup every time you make change. This is what forced me to 
MySQL.


Thanks again







--
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] LO Base/MySQL questions

[Jay Lozier]

On 02/07/2014 10:29 AM, Lens Paul wrote:

Hello,

This instability of HSQL is worrying when using the same database year 
after year, e.g. an address or a bibliographic database.


For my part, all my data remain in separate external tables in dbf 
format, linked to Base.


Reasons are:
- compatibility with many programmes and readability of old archives, 
even in case of change of database program ;

- stability in the long run;
- format compatible with GIS software;
- when the tables are not merged in one file, the loss is limited when 
one of the tables gets corrupted.


The main drawback is the impossibility to make a relational database.


In fact, the good integration of the office suite with a database was 
one of the main reason's why I began to use OO in 2007 or 2008.


To my great satisfaction indeed: it works very well, except for two 
instances, several years ago, where the dbf file got corrupted 
(luckily, recovery from backups was easy).
Since then it works fine without any failure (except, rarely, for some 
data in memo fields, which can lose the right connection with other 
data (dbt file connection to dbf file)).


Nevertheless, the impossibility of making relations between tables is 
rather frustrating.
One solution is to migrate to a mySQL/Base or preferably Postgresql 
(because of PostGIS). It's my intention but I fear to waste a lot of 
time in migrating.


What is the best combination for a single user, relational database, 
stable in the long run, using Base as the front end?



Paul Lens

Paul

PostgreSQL and MySQL/MariaDB are good alternatives. MariaDB is a fork of 
MySQL and many Linux distros install it instead of MySQL. Both can be 
used as a single user database. IMHO MariaDB is easier to use in a 
single user environment. With both you can use Base or database specific 
GUI (pgAdmin, MySQL Workbench).


If the data can be exported to csv files migrating should not be 
difficult, only time consuming.


Jay


Le 7/02/2014 15:07, Ian Whitfield a écrit :

Sorry All

I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55

A MySQL 'expert' was telling me recently that HSQL is only meant to 
be a prototyping utility and should *NEVER* be used for any proper 
work - - interesting!!??


I can confirm that when it crashes it takes everything with it so you 
have to backup every time you make change. This is what forced me to 
MySQL.


Thanks again









--
Jay Lozier
jsloz...@gmail.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] LO Base/MySQL questions

[Tom Davies]

Hi :)
A quick back of an envelope risk-analysis might suggest that
although the effects can be fairly devastating the likelihood of that
occurring is fairly low so it might be acceptable.

It might be something like that which led Ian's MySql expert to say
it was fine only for proto-typing, or it might be that the expert
needs people to all move to MySql and has a sales-pitch against each
different type of other non-MySql program.  The argument against
MariaDb might be that it doesn't work on Macs.


The LO marketing team keep insisting on pretending that the internal
database is ok.  Most of the rest of us seem to have to pick up the
pieces when/if that goes wrong so we seem to generally advise people
to move to an external back-end asap (within reason).  However it's
very rare that people do run into the problem so maybe it is being
over-stated.  Plus, how hard can it be to back-up a single file!  On
the other hand the effects are TOO devastating and far beyond what
most of us on this list would find acceptable


Just to add 2 extra layers of complexity
1.  the internal (embedded) database 'back-end' is apparently likely
to be switched from Hsql to something else 'soon'.
2.  Hsql is a separate 3rd party project and it's possible to download
and install their latest version on 'your computer' (or server or
anything) and use that in much the same way you use any other external
back-end.

Apparently the only reason the the internal back-end is sometimes
unstable is because Sun paid-devs insisted on locking in a now ancient
version and they heavily tweaked it.  Apparently this was fine back
in the day but nowadays means that the internal back-end is.  Also
apparently when the neweruntweaked versions of Hsql are being used as
an external back-end then it's quite excellent and very stable.

So i don't think it's really fair to blame Hsql.  It's be a bit like
saying that OOo 1.0 is a bit ancient and not great nowadays.

Regards from
Tom :)



On 7 February 2014 15:44, Jay Lozier jsloz...@gmail.com wrote:

 On 02/07/2014 10:29 AM, Lens Paul wrote:

 Hello,

 This instability of HSQL is worrying when using the same database year
 after year, e.g. an address or a bibliographic database.

 For my part, all my data remain in separate external tables in dbf format,
 linked to Base.

 Reasons are:
 - compatibility with many programmes and readability of old archives, even
 in case of change of database program ;
 - stability in the long run;
 - format compatible with GIS software;
 - when the tables are not merged in one file, the loss is limited when one
 of the tables gets corrupted.

 The main drawback is the impossibility to make a relational database.


 In fact, the good integration of the office suite with a database was one
 of the main reason's why I began to use OO in 2007 or 2008.

 To my great satisfaction indeed: it works very well, except for two
 instances, several years ago, where the dbf file got corrupted (luckily,
 recovery from backups was easy).
 Since then it works fine without any failure (except, rarely, for some
 data in memo fields, which can lose the right connection with other data
 (dbt file connection to dbf file)).

 Nevertheless, the impossibility of making relations between tables is
 rather frustrating.
 One solution is to migrate to a mySQL/Base or preferably Postgresql
 (because of PostGIS). It's my intention but I fear to waste a lot of time in
 migrating.

 What is the best combination for a single user, relational database,
 stable in the long run, using Base as the front end?


 Paul Lens

 Paul

 PostgreSQL and MySQL/MariaDB are good alternatives. MariaDB is a fork of
 MySQL and many Linux distros install it instead of MySQL. Both can be used
 as a single user database. IMHO MariaDB is easier to use in a single user
 environment. With both you can use Base or database specific GUI (pgAdmin,
 MySQL Workbench).

 If the data can be exported to csv files migrating should not be difficult,
 only time consuming.

 Jay


 Le 7/02/2014 15:07, Ian Whitfield a écrit :

 Sorry All

 I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55

 A MySQL 'expert' was telling me recently that HSQL is only meant to be a
 prototyping utility and should *NEVER* be used for any proper work - -
 interesting!!??

 I can confirm that when it crashes it takes everything with it so you
 have to backup every time you make change. This is what forced me to MySQL.

 Thanks again







 --
 Jay Lozier
 jsloz...@gmail.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

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? 

Re: [libreoffice-users] LO Base Sub Forms

[Ian Whitfield]

Hi All

I've had some success at last!!

Using Shane Piper's Tutorial at 
http://www.youtube.com/watch?v=TcudVETPePY I have got my sub-Forms 
working fine.


My last problem was with Opening a Form with a Button and again Shane 
has a Tutorial on this at http://www.youtube.com/watch?v=9Zmd-zidIvg


But I have been unable to get it to work on LO 4.1.1.2.
Today I started my old machine running LO 3.6.5.2 and it works fine on 
that machine!!!

(Both machines running PClinuxOS)

The Macro is ...

REM * BASIC *
Sub OpenStoryForm
const sNewDocumentName = Database Name.Form Name
oNewFormDocument = 
ThisDatabaseDocument.FormDocum­ents.getbyname(sNewDocumentNam­e).open

End Sub

We have tried with and without the Database Name and with and without 
the '.' between the two -

but no difference. Nothing happens at all when you click on the Button.

Has anyone seen this or knows of a reason for this?
I'm thinking of dropping back to LO 4.0 and see if it works on that.

Thanks for any info

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

Re: [libreoffice-users] LO Base Sub Forms

[Ian Whitfield]

On 15/10/13 22:41, Andrew Douglas Pitonyak wrote:
If I remember correctly (and I have not looked at this in a while), I 
think that you need to link the master and slave fields.


So, if you open your form in edit mode, load the form navigator, right 
click on your sub-form and choose properties, navigate to the Data 
tab, do the values in the Link master fields and Link slave fields 
look right to you? 


Thanks Andrew

You got the memory cells working again!! This morning I read-up on Sub 
Forms in the new LO 4.0 Base Handbook and I'm sure you are right. BTW - 
Great book but no 'How To' details (??).


That got me remembering a video on You Tube about Sub Forms - 
www.youtube.com/watch?v=TcudVETPePY - so I went and found that again.


However my Form Navigator will NOT show me the content of my Form!! All 
it gives me is a list of types - Headings, Tables, Text Frames, 
Graphics, OLE Objects, Bookmarks, Sections, Hyperlinks, Indexes, 
References, Comments and Draw Objects. (all with a count of '0'). And 
none of the options at the top of the Navigator make any difference.


How do I get the Navigator to display the content of my Form??

Thanks

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

Re: [libreoffice-users] LO Base Sub Forms

[mcmurchy1917-libreoffice]

I would suggest you study an application that uses a main and sub form.

I used  the Business Cards example from

 http://forum.openoffice.org/en/forum/viewforum.php?f=100

Good luck





On Tuesday 15 Oct 2013 14:09:59 Ian Whitfield wrote:
 Hi All
 
 I'm still stuck with LO Base Sub Forms!! I've been at this for some
 time, off and on, but over the past few months I have been very busy
 converting, editing and checking/updating my DB to now run on MySQL.
 I must say it is a GREAT improvement!!
 
 OK - My OpSys is PClinuxOS 2012-10. LO 4.1.1.2, MySQL 5.1.55
 
 I have three tables in my DB - 'Members', 'Story', 'eMails'.
 I have one Main Form Members (that references the 'Members Table) AND
 contains a Sub Form eMail (that references the 'eMail' Table). Also on
 the Main Form is a Button that should pop-up, over the Main Form, a
 Story Form that references the Story table).
 
 All the individual Tables and Forms work well on their own - BUT ...
 
 The eMail Sub Form does not link to the individual Members record
 and cycle with each record so I can not add info to this Sub Form that
 will be linked with the correct record.
 The Button does not work at all!!
 
 I have worked on this so many times off and on that I'm now rather
 confused on how to go about it or what I did before.
 
 My 'eMails' Table contains the fields - MessageID, Date, In/Out, Title,
 Message. ID (My Foreign Key)
 My 'Story' Table contains the fields - StoryID, Story, ID (My Foreign Key)
 
 If I remember correctly I created the eMail Sub Form at the time I
 laid out the new Data Base and under the Button properties I currently
 have When pressed - Standard.Story.OpenForm (document, Basic)
 
 Can someone help me out of this mess???
 
 Thanks for ANY help.
 
 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

[libreoffice-users] LO Base Sub Forms

[Ian Whitfield]

Hi All

I'm still stuck with LO Base Sub Forms!! I've been at this for some 
time, off and on, but over the past few months I have been very busy 
converting, editing and checking/updating my DB to now run on MySQL.

I must say it is a GREAT improvement!!

OK - My OpSys is PClinuxOS 2012-10. LO 4.1.1.2, MySQL 5.1.55

I have three tables in my DB - 'Members', 'Story', 'eMails'.
I have one Main Form Members (that references the 'Members Table) AND 
contains a Sub Form eMail (that references the 'eMail' Table). Also on 
the Main Form is a Button that should pop-up, over the Main Form, a 
Story Form that references the Story table).


All the individual Tables and Forms work well on their own - BUT ...

The eMail Sub Form does not link to the individual Members record 
and cycle with each record so I can not add info to this Sub Form that 
will be linked with the correct record.

The Button does not work at all!!

I have worked on this so many times off and on that I'm now rather 
confused on how to go about it or what I did before.


My 'eMails' Table contains the fields - MessageID, Date, In/Out, Title, 
Message. ID (My Foreign Key)

My 'Story' Table contains the fields - StoryID, Story, ID (My Foreign Key)

If I remember correctly I created the eMail Sub Form at the time I 
laid out the new Data Base and under the Button properties I currently 
have When pressed - Standard.Story.OpenForm (document, Basic)


Can someone help me out of this mess???

Thanks for ANY help.

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

Re: [libreoffice-users] LO Base Sub Forms

[Andrew Douglas Pitonyak]

If I remember correctly (and I have not looked at this in a while), I 
think that you need to link the master and slave fields.


So, if you open your form in edit mode, load the form navigator, right 
click on your sub-form and choose properties, navigate to the Data tab, 
do the values in the Link master fields and Link slave fields look 
right to you?



On 10/15/2013 08:09 AM, Ian Whitfield wrote:


Hi All

I'm still stuck with LO Base Sub Forms!! I've been at this for some 
time, off and on, but over the past few months I have been very busy 
converting, editing and checking/updating my DB to now run on MySQL.

I must say it is a GREAT improvement!!

OK - My OpSys is PClinuxOS 2012-10. LO 4.1.1.2, MySQL 5.1.55

I have three tables in my DB - 'Members', 'Story', 'eMails'.
I have one Main Form Members (that references the 'Members Table) 
AND contains a Sub Form eMail (that references the 'eMail' Table). 
Also on the Main Form is a Button that should pop-up, over the Main 
Form, a Story Form that references the Story table).


All the individual Tables and Forms work well on their own - BUT ...

The eMail Sub Form does not link to the individual Members record 
and cycle with each record so I can not add info to this Sub Form that 
will be linked with the correct record.

The Button does not work at all!!

I have worked on this so many times off and on that I'm now rather 
confused on how to go about it or what I did before.


My 'eMails' Table contains the fields - MessageID, Date, In/Out, 
Title, Message. ID (My Foreign Key)
My 'Story' Table contains the fields - StoryID, Story, ID (My Foreign 
Key)


If I remember correctly I created the eMail Sub Form at the time I 
laid out the new Data Base and under the Button properties I currently 
have When pressed - Standard.Story.OpenForm (document, Basic)


Can someone help me out of this mess???

Thanks for ANY help.

IanW
Pretoria RSA




--
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] LO Base - Pushbutton on Form not working.

[Niklas Johansson]

In short the message you get tells you that the macro that the button is 
linked to cannot be found. Then it tells you where it is looking for the 
macro. If you look closer at this it is looking for the macro that is 
located within the document and has the path Standard.Story.OpenForm. Is 
the macro really located there?


If it is still giving you issues what happens if you try to attach the 
macro to the button again?


Regards,
Niklas Johansson

Ian Whitfield skrev 2013-09-30 12:03:

Hi All

After some time working on other aspects of my Database I'm back to 
trying to get a Pushbutton working to open a SubForm.


PClinuxOS 2013.08; LO Base 4.1.1.2; MySQL 5.1.55

My Database - FSNew
Tables - Members  Story
Forms - FSNew.Members  FSNew.Story

The Pushbutton on the Members Form has the event -
Mouse Button Pressed - Standard.Story.OpenForm .

On Clicking on the Button in the Members Form I get the error -

A Scripting Framework error occurred while running the Basic script 
vnd.sun.star.script:Standard.Story.OpenForm?language=Basiclocation=document.


Message: The following Basic script could not be found:
library: 'Standard'
module: 'Story'
method: 'OpenForm'
location: 'document'

Can someone decipher this for me please?? Thanks!!

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

[libreoffice-users] LO Base - Pushbutton on Form not working.

[Ian Whitfield]

Hi All

After some time working on other aspects of my Database I'm back to 
trying to get a Pushbutton working to open a SubForm.


PClinuxOS 2013.08; LO Base 4.1.1.2; MySQL 5.1.55

My Database - FSNew
Tables - Members  Story
Forms - FSNew.Members  FSNew.Story

The Pushbutton on the Members Form has the event -
Mouse Button Pressed - Standard.Story.OpenForm .

On Clicking on the Button in the Members Form I get the error -

A Scripting Framework error occurred while running the Basic script 
vnd.sun.star.script:Standard.Story.OpenForm?language=Basiclocation=document.


Message: The following Basic script could not be found:
library: 'Standard'
module: 'Story'
method: 'OpenForm'
location: 'document'

Can someone decipher this for me please?? Thanks!!

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

Re: [libreoffice-users] LO Base - Check boxes not working after upgrade?? [WORKROUND]

[Ian Whitfield]

Thanks to Andrew and Mark for their input

I thought about this over the past few days and did not want to wind 
back to the earlier version of LO and have the problem of getting the 
link to my SQL Database working again.


So yesterday afternoon I came up with a Workround!! I converted all the 
Tick Boxes to Combo Boxes. It now takes two clicks to set them now but 
you do get more options if you need them.


All is working fine now. Just an idea that worked for me, in case anyone 
else is in the same boat.


Regards to all

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

Re: [libreoffice-users] LO Base - Check boxes not working after upgrade??

[Ian Whitfield]

Hi Andrew

On 05/09/13 23:09, Andrew Douglas Pitonyak wrote:
Is it possible that the form is in edit mode? As in, you are editing 
the control? It is a long shot guess...


On 09/05/2013 04:47 AM, Ian Whitfield wrote:

Hi All

I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just 
upgraded my LO Office to 4.1.2.


Everything seems to be fine
EXCEPT
The Check Boxes in my LO Form no longer work - you can not edit them 
or add to them. If you click on one a tick appears in the box but as 
you select Save the tick disappears and it is *NOT* saved.


I have even tried and created a new Tick Box and it behaves just as 
above,


Has anyone seen this effect or got any idea how to fix it please??

Thanks or any help.

IanW
Pretoria RSA





No Andrew this is NOT the case as all other fields are working correctly 
- only Tick Boxes can not be saved!!


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

Re: [libreoffice-users] LO Base - Check boxes not working after upgrade??

[Mark LaPierre]

On 09/06/2013 02:16 AM, Ian Whitfield wrote:
 Hi Andrew
 
 On 05/09/13 23:09, Andrew Douglas Pitonyak wrote:
 Is it possible that the form is in edit mode? As in, you are editing
 the control? It is a long shot guess...

 On 09/05/2013 04:47 AM, Ian Whitfield wrote:
 Hi All

 I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just
 upgraded my LO Office to 4.1.2.

 Everything seems to be fine
 EXCEPT
 The Check Boxes in my LO Form no longer work - you can not edit them
 or add to them. If you click on one a tick appears in the box but as
 you select Save the tick disappears and it is *NOT* saved.

 I have even tried and created a new Tick Box and it behaves just as
 above,

 Has anyone seen this effect or got any idea how to fix it please??

 Thanks or any help.

 IanW
 Pretoria RSA


 
 No Andrew this is NOT the case as all other fields are working correctly
 - only Tick Boxes can not be saved!!
 
 IanW
 Pretoria RSA
 

The easiest way to fix this is to replace LO 4, that doesn't work, with
LO 3 that does.  At the next LO release you can install the new release
and run some regression testing on it to see if it brakes any of your
functionality.  If it does write a bug report, then uninstall it and
replace it with the previous version that does work for you.

-- 
_
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/


-- 
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] LO Base - Check boxes not working after upgrade??

[Ian Whitfield]

Hi All

I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just 
upgraded my LO Office to 4.1.2.


Everything seems to be fine
EXCEPT
The Check Boxes in my LO Form no longer work - you can not edit them or 
add to them. If you click on one a tick appears in the box but as you 
select Save the tick disappears and it is *NOT* saved.


I have even tried and created a new Tick Box and it behaves just as above,

Has anyone seen this effect or got any idea how to fix it please??

Thanks or any help.

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

[libreoffice-users] LO Base - Check boxes not working after upgrade??

[Ian Whitfield]

FIRST POST DID NOT SEEM TO GET THROUGH - RE-SENDING ...

Hi All

I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just 
upgraded my LO Office to 4.1.2.


Everything seems to be fine
EXCEPT
The Check Boxes in my LO Form no longer work - you can not edit them or 
add to them. If you click on one a tick appears in the box but as you 
select Save the tick disappears and it is *NOT* saved.


I have even tried and created a new Tick Box and it behaves just as above,

Has anyone seen this effect or got any idea how to fix it please??

Thanks or any help.

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

Re: [libreoffice-users] LO Base - Check boxes not working after upgrade??

[Andrew Douglas Pitonyak]

Is it possible that the form is in edit mode? As in, you are editing the 
control? It is a long shot guess...


On 09/05/2013 04:47 AM, Ian Whitfield wrote:

Hi All

I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just 
upgraded my LO Office to 4.1.2.


Everything seems to be fine
EXCEPT
The Check Boxes in my LO Form no longer work - you can not edit them 
or add to them. If you click on one a tick appears in the box but as 
you select Save the tick disappears and it is *NOT* saved.


I have even tried and created a new Tick Box and it behaves just as 
above,


Has anyone seen this effect or got any idea how to fix it please??

Thanks or any help.

IanW
Pretoria RSA



--
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] LO Base/MySQL Backup??

[Hank Alper]

Hi Ian,
Ive been reading the posts concerning the security of your database using
mysqldump. Are you using a remote server for your MySQL, or is it on your
own computer?
I've completed a database using LO Base with embedded HSQL. I guess I can
use a MySQL server on my own machine to which I can connect LO Base to
avoid the data loss problems with the embedded
system. Is that he reason you went to MySQL?
Hank



On Mon, May 27, 2013 at 7:27 AM, Ian Whitfield whitfi...@telkomsa.netwrote:

 Hi All

 I'm now using the MySQL back-end (5.1.55) with LO Base (3.6.5.2) as my
 front-end - all on PCLOS 2013.

 I've been messing around since late last year getting this all right,
 (with lots of GREAT help from the Forum!!)

 My question now is - Where does MySQL store the Database and how do I
 track it down to make a backup?? Because of all my messing around I have
 several different files in the system that may be the right one but I'm not
 sure which is which.

 I lost my whole Database at the beginning of the year when I re-installed
 my OpSys so DON'T want that to happen again and need a reliable backup
 method.

 Any suggestions would be most welcome.

 Thanks a lot

 IanW
 Pretoria RSA

 --
 To unsubscribe e-mail to: 
 users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
 unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.**documentfoundation.org/**
 Netiquette http://wiki.documentfoundation.org/Netiquette
 List archive: 
 http://listarchives.**libreoffice.org/global/users/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

Re: [libreoffice-users] LO Base/MySQL Backup??

[Sajan Parikh]

No issue Girvin.  Discussion is good.

It's worth noting that mysqldump is there to be run on a cron.  Unless you
use something like Percona or pay the $5k for Enterprise, mysqldump is what
is being used by sysadmins everywhere considering there's really not much
else unless you go the route of snapshots and doing master-slave.  Which is
what I've done in the past for larger databases, but I just assumed this
was a smaller more personal database server. There's no security issue with
mysqldump itself.  Of course, anything can be used stupidly and insecurely,
that doesn't mean the product was insecure though.

I think my question to you would be why you specifically think putting
mysqldump in a cron is insecure?

--
*Sajan Parikh*
Web Consultant
Noppix LLC

*w: *563.726.0371
*m: *563.447.0822
*f:   *563.726.0122
*e: * sa...@noppix.com




On Thu, May 30, 2013 at 1:04 PM, Tom Davies tomdavie...@yahoo.co.uk wrote:

 Hi :)
 I think for a lot of us on the list that have been lurking around this
 topic the security issue has been interesting.  I think this discussion and
 the different approaches to dealing with the issue may well help some of us
 in the future.  many thanks to all that have posted in this thread.  Some
 valuable insights there! :)
 Thanks and regards from
 Tom :)





 
  From: Girvin R. Herr girvin.h...@sbcglobal.net
 To: Sajan Parikh sa...@noppix.com
 Cc: Steve Edmonds steve.edmo...@ptglobal.com; Wolfgang Keller 
 felip...@gmx.net; users@global.libreoffice.org 
 users@global.libreoffice.org
 Sent: Thursday, 30 May 2013, 18:47
 Subject: Re: [libreoffice-users] LO Base/MySQL Backup??
 
 
 Sajan  Steve,
 Thanks.  I will have to look at this as an alternate possibility.
 I didn't mean to criticize, but I take computer security seriously and
 when I see a vulnerability, I tend to bring it to the person's
 attention.  There are far too many people out there who take computer
 security nonchalantly and can be bitten.
 Girvin
 
 
 Sajan Parikh wrote:
  I don't see the security issue in mysqldump using a cron.  You can throw
  your password in a mysqldump.cnf file and make it only readable by your
  user.  You can combine that with what Steve said and use a special MySQL
  user as well.
 
  --
  *Sajan Parikh*
  *Web Consultant, Noppix LLC*
 
  *Work* - 563.726.0371
  *Cell *- 563.447.0822
  *Fax* - 563.726.0122
  *Email *- sa...@noppix.com
 
 
 
 
  On Tue, May 28, 2013 at 4:06 PM, Steve Edmonds
  steve.edmo...@ptglobal.comwrote:
 
 
  Hi Girvin.
  For security I created a mysql user 'backup' with read only access for
  backup.
  I make the cron script readable by root only
 
  -rwxr-x--- 1 root root 586 2012-12-05 16:19
 /etc/cron.backup/dailytmp.bu
 
  MYSQL_PWD=*** mysqldump -ubackup --all-databases
 --add-drop-database
  | gzip -9  /home/bu/mysql.sql.gz
 
  Steve
 
 
  On 2013-05-29 06:57, Girvin R. Herr wrote:
 
 
  Sajan,
  The only problem I see with a cron job is a security issue.  I assume
 you
  are putting your MySQL password(s) in your cron job script, since
 mysqldump
  requires it.  I would not recommend doing that.  I have a system
 backup
  script which I manually run monthly.  It does not include the
 passwords.
   When that script runs, mysqldump prompts me for the password, I
 enter it,
  and off it goes.
 
  I might add that I have been using mysqldump for several years and I
 have
  not had any problems with it or with retrieving the database data
 from its
  backup files.  I need to retrieve the backup when I upgrade MySQL, in
 order
  to restore my databases in the new version.  It works fine, even when
 I
  upgraded from MySQL 5.0.67 to 5.5.29.
  Girvin Herr
 
 
 
  Sajan Parikh wrote:
 
 
  Someone mentioned mysqldump, this is definitely the way to go.  Set
 it up
  on a cron and have it dump files to a backup directory.
 
  --
  *Sajan Parikh*
  *Web Consultant, Noppix LLC*
 
  *Work* - 563.726.0371
  *Cell *- 563.447.0822
  *Fax* - 563.726.0122
  *Email *- sa...@noppix.com
 
 
 
 
  On Tue, May 28, 2013 at 11:08 AM, Wolfgang Keller felip...@gmx.net
  wrote:
 
   My question now is - Where does MySQL store the Database and how do
 I
 
  track it down to make a backup??
 
 
  You'll have to use the MySQL administration tool for that. LO only
 sees
  a server running at an IP address listening to a specific port. It
 has
  no means to know where the data is.
 
  And I still recommend PostgreSQL over MySQL. ;-)
 
  Among others, it allows backing up a database while live.
 
  Sincerely,
 
  Wolfgang
 
  --
  To unsubscribe e-mail to: users+unsubscribe@global.**
 libreoffice.orgusers%2bunsubscr...@global.libreoffice.org
  Problems?
  http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
  unsubscribe/
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
  Posting guidelines + more: http://wiki.**documentfoundation.org/**
  Netiquette http://wiki.documentfoundation.org/Netiquette
  List archive: http

Re: [libreoffice-users] LO Base/MySQL Backup??

[Girvin R. Herr]

Sajan  Steve,
Thanks.  I will have to look at this as an alternate possibility.
I didn't mean to criticize, but I take computer security seriously and 
when I see a vulnerability, I tend to bring it to the person's 
attention.  There are far too many people out there who take computer 
security nonchalantly and can be bitten.

Girvin


Sajan Parikh wrote:

I don't see the security issue in mysqldump using a cron.  You can throw
your password in a mysqldump.cnf file and make it only readable by your
user.  You can combine that with what Steve said and use a special MySQL
user as well.

--
*Sajan Parikh*
*Web Consultant, Noppix LLC*

*Work* - 563.726.0371
*Cell *- 563.447.0822
*Fax* - 563.726.0122
*Email *- sa...@noppix.com




On Tue, May 28, 2013 at 4:06 PM, Steve Edmonds
steve.edmo...@ptglobal.comwrote:

  

Hi Girvin.
For security I created a mysql user 'backup' with read only access for
backup.
I make the cron script readable by root only

-rwxr-x--- 1 root root 586 2012-12-05 16:19 /etc/cron.backup/dailytmp.bu

MYSQL_PWD=*** mysqldump -ubackup --all-databases --add-drop-database
| gzip -9  /home/bu/mysql.sql.gz

Steve


On 2013-05-29 06:57, Girvin R. Herr wrote:



Sajan,
The only problem I see with a cron job is a security issue.  I assume you
are putting your MySQL password(s) in your cron job script, since mysqldump
requires it.  I would not recommend doing that.  I have a system backup
script which I manually run monthly.  It does not include the passwords.
 When that script runs, mysqldump prompts me for the password, I enter it,
and off it goes.

I might add that I have been using mysqldump for several years and I have
not had any problems with it or with retrieving the database data from its
backup files.  I need to retrieve the backup when I upgrade MySQL, in order
to restore my databases in the new version.  It works fine, even when I
upgraded from MySQL 5.0.67 to 5.5.29.
Girvin Herr



Sajan Parikh wrote:

  

Someone mentioned mysqldump, this is definitely the way to go.  Set it up
on a cron and have it dump files to a backup directory.

--
*Sajan Parikh*
*Web Consultant, Noppix LLC*

*Work* - 563.726.0371
*Cell *- 563.447.0822
*Fax* - 563.726.0122
*Email *- sa...@noppix.com




On Tue, May 28, 2013 at 11:08 AM, Wolfgang Keller felip...@gmx.net
wrote:

 My question now is - Where does MySQL store the Database and how do I


track it down to make a backup??



You'll have to use the MySQL administration tool for that. LO only sees
a server running at an IP address listening to a specific port. It has
no means to know where the data is.

And I still recommend PostgreSQL over MySQL. ;-)

Among others, it allows backing up a database while live.

Sincerely,

Wolfgang

--
To unsubscribe e-mail to: 
users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@global.libreoffice.org
Problems?
http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.**documentfoundation.org/**
Netiquette http://wiki.documentfoundation.org/Netiquette
List archive: 
http://listarchives.**libreoffice.org/global/users/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

Re: [libreoffice-users] LO Base/MySQL Backup??

[Tom Davies]

Hi :)
I think for a lot of us on the list that have been lurking around this topic 
the security issue has been interesting.  I think this discussion and the 
different approaches to dealing with the issue may well help some of us in the 
future.  many thanks to all that have posted in this thread.  Some valuable 
insights there! :)
Thanks and regards from 
Tom :)  






 From: Girvin R. Herr girvin.h...@sbcglobal.net
To: Sajan Parikh sa...@noppix.com 
Cc: Steve Edmonds steve.edmo...@ptglobal.com; Wolfgang Keller 
felip...@gmx.net; users@global.libreoffice.org 
users@global.libreoffice.org 
Sent: Thursday, 30 May 2013, 18:47
Subject: Re: [libreoffice-users] LO Base/MySQL Backup??
 

Sajan  Steve,
Thanks.  I will have to look at this as an alternate possibility.
I didn't mean to criticize, but I take computer security seriously and 
when I see a vulnerability, I tend to bring it to the person's 
attention.  There are far too many people out there who take computer 
security nonchalantly and can be bitten.
Girvin


Sajan Parikh wrote:
 I don't see the security issue in mysqldump using a cron.  You can throw
 your password in a mysqldump.cnf file and make it only readable by your
 user.  You can combine that with what Steve said and use a special MySQL
 user as well.

 --
 *Sajan Parikh*
 *Web Consultant, Noppix LLC*

 *Work* - 563.726.0371
 *Cell *- 563.447.0822
 *Fax* - 563.726.0122
 *Email *- sa...@noppix.com




 On Tue, May 28, 2013 at 4:06 PM, Steve Edmonds
 steve.edmo...@ptglobal.comwrote:

  
 Hi Girvin.
 For security I created a mysql user 'backup' with read only access for
 backup.
 I make the cron script readable by root only

 -rwxr-x--- 1 root root 586 2012-12-05 16:19 /etc/cron.backup/dailytmp.bu

 MYSQL_PWD=*** mysqldump -ubackup --all-databases --add-drop-database
 | gzip -9  /home/bu/mysql.sql.gz

 Steve


 On 2013-05-29 06:57, Girvin R. Herr wrote:

    
 Sajan,
 The only problem I see with a cron job is a security issue.  I assume you
 are putting your MySQL password(s) in your cron job script, since mysqldump
 requires it.  I would not recommend doing that.  I have a system backup
 script which I manually run monthly.  It does not include the passwords.
  When that script runs, mysqldump prompts me for the password, I enter it,
 and off it goes.

 I might add that I have been using mysqldump for several years and I have
 not had any problems with it or with retrieving the database data from its
 backup files.  I need to retrieve the backup when I upgrade MySQL, in order
 to restore my databases in the new version.  It works fine, even when I
 upgraded from MySQL 5.0.67 to 5.5.29.
 Girvin Herr



 Sajan Parikh wrote:

      
 Someone mentioned mysqldump, this is definitely the way to go.  Set it up
 on a cron and have it dump files to a backup directory.

 --
 *Sajan Parikh*
 *Web Consultant, Noppix LLC*

 *Work* - 563.726.0371
 *Cell *- 563.447.0822
 *Fax* - 563.726.0122
 *Email *- sa...@noppix.com




 On Tue, May 28, 2013 at 11:08 AM, Wolfgang Keller felip...@gmx.net
 wrote:

  My question now is - Where does MySQL store the Database and how do I
        
 track it down to make a backup??

            
 You'll have to use the MySQL administration tool for that. LO only sees
 a server running at an IP address listening to a specific port. It has
 no means to know where the data is.

 And I still recommend PostgreSQL over MySQL. ;-)

 Among others, it allows backing up a database while live.

 Sincerely,

 Wolfgang

 --
 To unsubscribe e-mail to: 
 users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
 unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.**documentfoundation.org/**
 Netiquette http://wiki.documentfoundation.org/Netiquette
 List archive: 
 http://listarchives.**libreoffice.org/global/users/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



-- 
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] LO Base/MySQL Backup??

[Wolfgang Keller]

 My question now is - Where does MySQL store the Database and how do I 
 track it down to make a backup??

You'll have to use the MySQL administration tool for that. LO only sees
a server running at an IP address listening to a specific port. It has
no means to know where the data is.

And I still recommend PostgreSQL over MySQL. ;-)

Among others, it allows backing up a database while live.

Sincerely,

Wolfgang

-- 
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] LO Base/MySQL Backup??

[Sajan Parikh]

Someone mentioned mysqldump, this is definitely the way to go.  Set it up
on a cron and have it dump files to a backup directory.

--
*Sajan Parikh*
*Web Consultant, Noppix LLC*

*Work* - 563.726.0371
*Cell *- 563.447.0822
*Fax* - 563.726.0122
*Email *- sa...@noppix.com




On Tue, May 28, 2013 at 11:08 AM, Wolfgang Keller felip...@gmx.net wrote:

  My question now is - Where does MySQL store the Database and how do I
  track it down to make a backup??

 You'll have to use the MySQL administration tool for that. LO only sees
 a server running at an IP address listening to a specific port. It has
 no means to know where the data is.

 And I still recommend PostgreSQL over MySQL. ;-)

 Among others, it allows backing up a database while live.

 Sincerely,

 Wolfgang

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

Re: [libreoffice-users] LO Base/MySQL Backup??

[Girvin R. Herr]

Sajan,
The only problem I see with a cron job is a security issue.  I assume 
you are putting your MySQL password(s) in your cron job script, since 
mysqldump requires it.  I would not recommend doing that.  I have a 
system backup script which I manually run monthly.  It does not include 
the passwords.  When that script runs, mysqldump prompts me for the 
password, I enter it, and off it goes.


I might add that I have been using mysqldump for several years and I 
have not had any problems with it or with retrieving the database data 
from its backup files.  I need to retrieve the backup when I upgrade 
MySQL, in order to restore my databases in the new version.  It works 
fine, even when I upgraded from MySQL 5.0.67 to 5.5.29.

Girvin Herr



Sajan Parikh wrote:

Someone mentioned mysqldump, this is definitely the way to go.  Set it up
on a cron and have it dump files to a backup directory.

--
*Sajan Parikh*
*Web Consultant, Noppix LLC*

*Work* - 563.726.0371
*Cell *- 563.447.0822
*Fax* - 563.726.0122
*Email *- sa...@noppix.com




On Tue, May 28, 2013 at 11:08 AM, Wolfgang Keller felip...@gmx.net wrote:

  

My question now is - Where does MySQL store the Database and how do I
track it down to make a backup??
  

You'll have to use the MySQL administration tool for that. LO only sees
a server running at an IP address listening to a specific port. It has
no means to know where the data is.

And I still recommend PostgreSQL over MySQL. ;-)

Among others, it allows backing up a database while live.

Sincerely,

Wolfgang

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

Re: [libreoffice-users] LO Base/MySQL Backup??

[Steve Edmonds]

Hi Girvin.
For security I created a mysql user 'backup' with read only access for 
backup.

I make the cron script readable by root only

-rwxr-x--- 1 root root 586 2012-12-05 16:19 /etc/cron.backup/dailytmp.bu

MYSQL_PWD=*** mysqldump -ubackup --all-databases 
--add-drop-database | gzip -9  /home/bu/mysql.sql.gz


Steve

On 2013-05-29 06:57, Girvin R. Herr wrote:

Sajan,
The only problem I see with a cron job is a security issue.  I assume 
you are putting your MySQL password(s) in your cron job script, since 
mysqldump requires it.  I would not recommend doing that.  I have a 
system backup script which I manually run monthly.  It does not 
include the passwords.  When that script runs, mysqldump prompts me 
for the password, I enter it, and off it goes.


I might add that I have been using mysqldump for several years and I 
have not had any problems with it or with retrieving the database data 
from its backup files.  I need to retrieve the backup when I upgrade 
MySQL, in order to restore my databases in the new version.  It works 
fine, even when I upgraded from MySQL 5.0.67 to 5.5.29.

Girvin Herr



Sajan Parikh wrote:
Someone mentioned mysqldump, this is definitely the way to go.  Set 
it up

on a cron and have it dump files to a backup directory.

--
*Sajan Parikh*
*Web Consultant, Noppix LLC*

*Work* - 563.726.0371
*Cell *- 563.447.0822
*Fax* - 563.726.0122
*Email *- sa...@noppix.com




On Tue, May 28, 2013 at 11:08 AM, Wolfgang Keller felip...@gmx.net 
wrote:



My question now is - Where does MySQL store the Database and how do I
track it down to make a backup??

You'll have to use the MySQL administration tool for that. LO only sees
a server running at an IP address listening to a specific port. It has
no means to know where the data is.

And I still recommend PostgreSQL over MySQL. ;-)

Among others, it allows backing up a database while live.

Sincerely,

Wolfgang

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

Re: [libreoffice-users] LO Base/MySQL Backup??

[Sajan Parikh]

I don't see the security issue in mysqldump using a cron.  You can throw
your password in a mysqldump.cnf file and make it only readable by your
user.  You can combine that with what Steve said and use a special MySQL
user as well.

--
*Sajan Parikh*
*Web Consultant, Noppix LLC*

*Work* - 563.726.0371
*Cell *- 563.447.0822
*Fax* - 563.726.0122
*Email *- sa...@noppix.com




On Tue, May 28, 2013 at 4:06 PM, Steve Edmonds
steve.edmo...@ptglobal.comwrote:

 Hi Girvin.
 For security I created a mysql user 'backup' with read only access for
 backup.
 I make the cron script readable by root only

 -rwxr-x--- 1 root root 586 2012-12-05 16:19 /etc/cron.backup/dailytmp.bu

 MYSQL_PWD=*** mysqldump -ubackup --all-databases --add-drop-database
 | gzip -9  /home/bu/mysql.sql.gz

 Steve


 On 2013-05-29 06:57, Girvin R. Herr wrote:

 Sajan,
 The only problem I see with a cron job is a security issue.  I assume you
 are putting your MySQL password(s) in your cron job script, since mysqldump
 requires it.  I would not recommend doing that.  I have a system backup
 script which I manually run monthly.  It does not include the passwords.
  When that script runs, mysqldump prompts me for the password, I enter it,
 and off it goes.

 I might add that I have been using mysqldump for several years and I have
 not had any problems with it or with retrieving the database data from its
 backup files.  I need to retrieve the backup when I upgrade MySQL, in order
 to restore my databases in the new version.  It works fine, even when I
 upgraded from MySQL 5.0.67 to 5.5.29.
 Girvin Herr



 Sajan Parikh wrote:

 Someone mentioned mysqldump, this is definitely the way to go.  Set it up
 on a cron and have it dump files to a backup directory.

 --
 *Sajan Parikh*
 *Web Consultant, Noppix LLC*

 *Work* - 563.726.0371
 *Cell *- 563.447.0822
 *Fax* - 563.726.0122
 *Email *- sa...@noppix.com




 On Tue, May 28, 2013 at 11:08 AM, Wolfgang Keller felip...@gmx.net
 wrote:

  My question now is - Where does MySQL store the Database and how do I
 track it down to make a backup??

 You'll have to use the MySQL administration tool for that. LO only sees
 a server running at an IP address listening to a specific port. It has
 no means to know where the data is.

 And I still recommend PostgreSQL over MySQL. ;-)

 Among others, it allows backing up a database while live.

 Sincerely,

 Wolfgang

 --
 To unsubscribe e-mail to: 
 users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
 unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.**documentfoundation.org/**
 Netiquette http://wiki.documentfoundation.org/Netiquette
 List archive: 
 http://listarchives.**libreoffice.org/global/users/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] LO Base/MySQL Backup??

[Ian Whitfield]

Hi All

I'm now using the MySQL back-end (5.1.55) with LO Base (3.6.5.2) as my 
front-end - all on PCLOS 2013.


I've been messing around since late last year getting this all right, 
(with lots of GREAT help from the Forum!!)


My question now is - Where does MySQL store the Database and how do I 
track it down to make a backup?? Because of all my messing around I 
have several different files in the system that may be the right one but 
I'm not sure which is which.


I lost my whole Database at the beginning of the year when I 
re-installed my OpSys so DON'T want that to happen again and need a 
reliable backup method.


Any suggestions would be most welcome.

Thanks a lot

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

Re: [libreoffice-users] LO Base/MySQL Backup??

[jomali]

mysqldump database name  filename (with authentication) is the best backup
method. You can look up the details in the docs.

On Monday, May 27, 2013, Ian Whitfield wrote:

 Hi All

 I'm now using the MySQL back-end (5.1.55) with LO Base (3.6.5.2) as my
 front-end - all on PCLOS 2013.

 I've been messing around since late last year getting this all right,
 (with lots of GREAT help from the Forum!!)

 My question now is - Where does MySQL store the Database and how do I
 track it down to make a backup?? Because of all my messing around I have
 several different files in the system that may be the right one but I'm not
 sure which is which.

 I lost my whole Database at the beginning of the year when I re-installed
 my OpSys so DON'T want that to happen again and need a reliable backup
 method.

 Any suggestions would be most welcome.

 Thanks a lot

 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/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.**documentfoundation.org/**
 Netiquette http://wiki.documentfoundation.org/Netiquette
 List archive: 
 http://listarchives.**libreoffice.org/global/users/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] LO Base - Question about Query

[Ian Whitfield]

Hi All

I have a Database with about 3000 addresses in it and need - from 
time-to-time - to check how many different Countries are listed in it.


I have a Query that extracts this for me but naturally it pulls out 
EVERY entry for EVERY Country.


Is there a way for a Query to do this BUT only list each Country Once??

(PCLOS 2013, MySQL 5.1.55, LO 3.6.5.2)

Thanks for any help

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

Re: [libreoffice-users] LO Base - Question about Query

[Marion Noel Lodge]

Hi Ian,

Assuming your field is 'Country', try this -

   SELECT Country, Count(Country) AS 'Count'
   FROM your Table name
   GROUP BY Country
   ORDER BY Country

Noel
--
Noel Lodge
lodg...@gmail.com


On 25 May 2013 19:09, Ian Whitfield whitfi...@telkomsa.net wrote:

 Hi All

 I have a Database with about 3000 addresses in it and need - from
 time-to-time - to check how many different Countries are listed in it.

 I have a Query that extracts this for me but naturally it pulls out EVERY
 entry for EVERY Country.

 Is there a way for a Query to do this BUT only list each Country Once??

 (PCLOS 2013, MySQL 5.1.55, LO 3.6.5.2)

 Thanks for any help

 IanW
 Pretoria RSA

 --
 To unsubscribe e-mail to: 
 users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
 unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.**documentfoundation.org/**
 Netiquette http://wiki.documentfoundation.org/Netiquette
 List archive: 
 http://listarchives.**libreoffice.org/global/users/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

Re: [libreoffice-users] LO Base - Question about Query [SOLVED]

[Ian Whitfield]

Thanks Noel !!!

On 25/05/13 11:58, Marion  Noel Lodge wrote:

Assuming your field is 'Country', try this -

SELECT Country, Count(Country) AS 'Count'
FROM your Table name
GROUP BY Country
ORDER BY Country
I had a problem, at first - as I always seem to do - with 'Syntax 
Error'!! So I created it with the Wizard and edited it in SQL view.


This resulted in ...

SELECT `Members`.`Country` AS `Country`
FROM `FedSaintsNew`.`Members` `Members`
GROUP BY `Members`.`Country`
ORDER BY `Members`.`Country`

This worked 100%!! So thanks very much. It does bring up two 'Blank' 
results, (which I guess must have a space in them or something). I don't 
know how to track these down but it's not too important.


Appreciate the help.

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

Re: [libreoffice-users] LO Base - Question about Query [SOLVED]

[Marion Noel Lodge]

Hi Ian,

Glad you got it working - there are often subtle differences between
different flavours of SQL.

If you would like to track down the two blank records, you could try -

SELECT *
FROM `FedSaintsNew`.`Members` `Members`
WHERE `Members`.`Country` = ' '

Not sure what your syntax might be in the last line - if it doesn't work
try -

WHERE `Members`.`Country` =  

If ever you wanted to know how many people you have from each country, you
could experiment with adding -

, Count(`Members`.`Country`) AS 'Count'
or perhaps -
, Count(`Members`.`Country`) AS Count

to the end of your SELECT line.

Noel
--
Noel Lodge
lodg...@gmail.com


On 25 May 2013 21:10, Ian Whitfield whitfi...@telkomsa.net wrote:

 Thanks Noel !!!

 On 25/05/13 11:58, Marion  Noel Lodge wrote:

 Assuming your field is 'Country', try this -

 SELECT Country, Count(Country) AS 'Count'
 FROM your Table name
 GROUP BY Country
 ORDER BY Country

 I had a problem, at first - as I always seem to do - with 'Syntax Error'!!
 So I created it with the Wizard and edited it in SQL view.

 This resulted in ...

 SELECT `Members`.`Country` AS `Country`
 FROM `FedSaintsNew`.`Members` `Members`
 GROUP BY `Members`.`Country`
 ORDER BY `Members`.`Country`

 This worked 100%!! So thanks very much. It does bring up two 'Blank'
 results, (which I guess must have a space in them or something). I don't
 know how to track these down but it's not too important.

 Appreciate the help.

 IanW
 Pretoria RSA

 --
 To unsubscribe e-mail to: 
 users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
 unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.**documentfoundation.org/**
 Netiquette http://wiki.documentfoundation.org/Netiquette
 List archive: 
 http://listarchives.**libreoffice.org/global/users/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

Re: [libreoffice-users] LO Base - Question about Query [SOLVED]

[Dan Lewis]

On 05/25/2013 07:10 AM, Ian Whitfield wrote:

Thanks Noel !!!

On 25/05/13 11:58, Marion  Noel Lodge wrote:

Assuming your field is 'Country', try this -

SELECT Country, Count(Country) AS 'Count'
FROM your Table name
GROUP BY Country
ORDER BY Country
I had a problem, at first - as I always seem to do - with 'Syntax 
Error'!! So I created it with the Wizard and edited it in SQL view.


This resulted in ...

SELECT `Members`.`Country` AS `Country`
FROM `FedSaintsNew`.`Members` `Members`
GROUP BY `Members`.`Country`
ORDER BY `Members`.`Country`

This worked 100%!! So thanks very much. It does bring up two 'Blank' 
results, (which I guess must have a space in them or something). I 
don't know how to track these down but it's not too important.


Appreciate the help.

IanW
Pretoria RSA
 If all you want is a count of the distinct countries in your 
table, try this:


SELECT COUNT( DISTINCT `Members`.`Country`) AS `Country`
FROM `FedSaintsNew`.`Members` `Members`

--Dan

--
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] LO Base - Question about Query [SOLVED]

[Dan Lewis]

On 05/25/2013 08:37 AM, Dan Lewis wrote:

On 05/25/2013 07:10 AM, Ian Whitfield wrote:

Thanks Noel !!!

On 25/05/13 11:58, Marion  Noel Lodge wrote:

Assuming your field is 'Country', try this -

SELECT Country, Count(Country) AS 'Count'
FROM your Table name
GROUP BY Country
ORDER BY Country
I had a problem, at first - as I always seem to do - with 'Syntax 
Error'!! So I created it with the Wizard and edited it in SQL view.


This resulted in ...

SELECT `Members`.`Country` AS `Country`
FROM `FedSaintsNew`.`Members` `Members`
GROUP BY `Members`.`Country`
ORDER BY `Members`.`Country`

This worked 100%!! So thanks very much. It does bring up two 'Blank' 
results, (which I guess must have a space in them or something). I 
don't know how to track these down but it's not too important.


Appreciate the help.

IanW
Pretoria RSA
 If all you want is a count of the distinct countries in your 
table, try this:


SELECT COUNT( DISTINCT `Members`.`Country`) AS `Country`
FROM `FedSaintsNew`.`Members` `Members`

--Dan

 I forgot to mention one very important thing:
You must do this in SQL View. Then you must click the SQL icon. (This 
causes the SQL commands to be run directly. It will also prevent an 
error message because the Query Design dialog will not run this SQL 
otherwise.) After doing these things, run the query. You should get the 
number of distinct countries you have in your table.


--Dan

--
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] LO Base Colour settings in Form design.

[Ian Whitfield]

Hi All

I have a Membership Database running on MySQL 5.1 with an LO Base Front 
end Ver 3.6.2.2. All running on PCLOS 2012.
My Members fall into two or three different Categories and I would like 
to be able to show this on screen.


SO - Is it possible to add in a statement to the Form design so that the 
background colour of the Form will change depending on the value set in 
a field called 'Cat'?


Something like
IF 'Cat'=abc THEN Bgd Colour = colour string1 OR
IF 'Cat'=cde THEN Bgd Colour = colour string2

Thanks for any help!!

IanW
Pretoria RSA

--
For unsubscribe instructions e-mail to: users+h...@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] LO Base Colour settings in Form design.

[Fernand Vanrie]

 Ian ,

When using macro's to add the data to your form it can easly been done, 
without macro's ??


Greetz

Fernand

Hi All

I have a Membership Database running on MySQL 5.1 with an LO Base 
Front end Ver 3.6.2.2. All running on PCLOS 2012.
My Members fall into two or three different Categories and I would 
like to be able to show this on screen.


SO - Is it possible to add in a statement to the Form design so that 
the background colour of the Form will change depending on the value 
set in a field called 'Cat'?


Something like
IF 'Cat'=abc THEN Bgd Colour = colour string1 OR
IF 'Cat'=cde THEN Bgd Colour = colour string2

Thanks for any help!!

IanW
Pretoria RSA




--
For unsubscribe instructions e-mail to: users+h...@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] LO Base Colour settings in Form design.

[Fernand Vanrie]

Ian ,

or maybe just place a listener on the filed who contains Cat data.
on changing the field content place a event who run a macro:

The eventlistner produce a oEvent object who contains the source = 
field object and the source.context = Form object


IF Oevent.source.model.text = abc THEN Oevent.source. context . 
backgroundcolor == colour string1 OR ...


hope it helps

Hi All

I have a Membership Database running on MySQL 5.1 with an LO Base 
Front end Ver 3.6.2.2. All running on PCLOS 2012.
My Members fall into two or three different Categories and I would 
like to be able to show this on screen.


SO - Is it possible to add in a statement to the Form design so that 
the background colour of the Form will change depending on the value 
set in a field called 'Cat'?


Something like
IF 'Cat'=abc THEN Bgd Colour = colour string1 OR
IF 'Cat'=cde THEN Bgd Colour = colour string2

Thanks for any help!!

IanW
Pretoria RSA




--
For unsubscribe instructions e-mail to: users+h...@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] LO Base Colour settings in Form design.

[Dan Lewis]

On 11/23/2012 10:24 AM, Ian Whitfield wrote:

Hi All

I have a Membership Database running on MySQL 5.1 with an LO Base 
Front end Ver 3.6.2.2. All running on PCLOS 2012.
My Members fall into two or three different Categories and I would 
like to be able to show this on screen.


SO - Is it possible to add in a statement to the Form design so that 
the background colour of the Form will change depending on the value 
set in a field called 'Cat'?


Something like
IF 'Cat'=abc THEN Bgd Colour = colour string1 OR
IF 'Cat'=cde THEN Bgd Colour = colour string2

Thanks for any help!!

IanW
Pretoria RSA
 To do this you will have to create a macro. Use the Events tab of 
the Control tool to assign the macro to 'Cat'. I don't know how well you 
understand macros nor how to create them.
 I don't have any experience in using macros, so I can not make any 
suggestions as to the required macro's content. From what little I have 
seen, it may contain some lengthy lines of code. Others with macro 
experience may be able to point you in the right direction.


--Dan

--
For unsubscribe instructions e-mail to: users+h...@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] LO Base Reports

[Ian Whitfield]

Thanks Girvin

You were the only one to come back to my question!!

The report layout looks fine, (FieldNames in the 'Header' and the 
field's data in the 'Detail'), but no matter what I do it displays 
alternative rows of Headings and Data!!


I have however, in the absence of any other suggestions, come up with a 
work-round ...


1) Call up the Query the Report runs on.
2) Select everything. (Click top-left corner)
3) Copy everything. (Right-click and select 'copy')
4) Open a new Text Document and Paste, (A box comes up to select which 
fields you want).
(*BTW* - This display is exactly the way it used to be and the way 
I want it.

ie one line of Headings and all the Data below!!)
5) Click inside the new Table and select TableConvertTable to Text.
6) Remove the Headings line.

Viola!!!

I still wonder however why this was changed and what the proper answer 
is


Regarding my SQL problem - I could not get the old string to work at all 
but after a little digging I got YOUR 'CONCAT' string to work for me. I 
guess this must be a difference between HSQL and MySQL!! Thanks for this!!!


As always I greatly appreciate the assistance!!

Ianw
Pretoria RSA



--
For unsubscribe instructions e-mail to: users+h...@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] LO Base Reports

[Ian Whitfield]

Hi All

Since I upgraded to LO 3.6.2.2 on my PCLOS 2012 system I find that Base 
no longer displays my Reports the way I need them!!


I used to get a single line of 'Field Names' followed my multiple lines 
of data.


What I get now is alternating lines of 'Field Names' and one row of 
data. (I've tried all the options given and they all do this!!)


How can I get back to my original layout??

Second problem - I have a need to produce a file, with the data in the 
format Field_One|Field_Two. I was given the SQL Command of 
PrefFirstName || '|' || Email but failed to make a note of how I set 
this up in the Report.

(All I get now is a syntax error - whatever I try)

Can someone please put me right!!

Thanks a lot

IanW
Pretoria RSA.

--
For unsubscribe instructions e-mail to: users+h...@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] LO Base Reports

[Girvin R. Herr]

Ian Whitfield wrote:

Hi All

Since I upgraded to LO 3.6.2.2 on my PCLOS 2012 system I find that 
Base no longer displays my Reports the way I need them!!


I used to get a single line of 'Field Names' followed my multiple 
lines of data.


What I get now is alternating lines of 'Field Names' and one row of 
data. (I've tried all the options given and they all do this!!)


How can I get back to my original layout??
I don't know how or why your report got changed, but you should be able 
to drag the fields back to where you want them in the report editor.  It 
sounds like your field names are now located in the detail section 
rather than the heading section.  You don't say what version you 
upgraded from, but lately, LO is bundling the Oracle Report Builder 
extension, which may have changed something if you weren't using it 
before the upgrade. 


Second problem - I have a need to produce a file, with the data in the 
format Field_One|Field_Two. I was given the SQL Command of 
PrefFirstName || '|' || Email but failed to make a note of how I 
set this up in the Report.

(All I get now is a syntax error - whatever I try)

Have you looked at using the MySQL CONCAT_WS function in a query?  This 
function allows you to concatenate fields, and specify a field delimiter 
string, into a single line of text.  For example:


   CONCAT_WS('|',` Field_One`,`Field_Two`)

should result in the format you specified.  In my case, I am using it in 
a SELECT clause to format my supplier data inside a form listbox.  It 
displays the name, address, etc, separated by ' | ' strings so the 
fields are not all run together.  It isn't fixed columns, but it works 
well enough for me.

Can someone please put me right!!

Thanks a lot

IanW
Pretoria RSA.


Hope this helps.
Girvin Herr


--
For unsubscribe instructions e-mail to: users+h...@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] LO Base questions

[Ian Whitfield]

On 09/02/2012 18:53, drew wrote:

On Thu, 2012-02-09 at 17:12 +0200, Ian Whitfield wrote:

On 07/02/2012 20:08, drew wrote:

Periodically you should perform the following. When finished using the
database, open the SQL window. Menu [FileSQL] In the command window
enter: SHUTDOWN COMPACT You should, after a short while receive in the
status field the message: 1: Command successfully executed. At that
point close the file. [you must do so as the database engine is indeed
shutdown at this point] This will reduce the size of the file on disk
and the memory used at run-time, and will increase performance on
startup and shutdown. Depending on how actively you edit that table
this period can be once a week or once every two weeks..can't say what
is right for your specific usage.

Thanks Drew!!

This worked a treat for me and I can see a marked improvement in my
close-down times of the main DB and also closing Queries,

A real Gem!! (Is there any way of automating this do you know??)

Howdy Ian

Glad it helped.

Automating?

As in a custom menu item for 'Close after Compact'
_or_
Every Friday compact the database?

Thanks

//drew


Good question Drew! (thinking...???)

I guess either would work but I think the first option would be my first 
choice. But rather 'Compact and Close'.


On reflection - whichever is the easiest to implement.

Ian Whitfield
Pretoria


--
For unsubscribe instructions e-mail to: users+h...@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] LO Base questions

[Tom Davies]

Hi :)
I think automating it creates problems.  Unexpected things tend to crop-up and 
it can be very annoying to find that your machine is suddenly outside of your 
control and running super slow at a moment when you need rapid access to deal 
with a situation.  

Where i 'work' we share the building with an organisation that only has 
part-time workers.  As soon as they sit down to do some work their machines 
hunt for updates and install them, run through a mysterious back-up process, 
defrags, does an anit-virus scan and error-messages pop-up such as Must 
install new java now and Must reboot machine NOW.  After a couple of hours 
the machine has completed most of the tasks and is ready to use.  Just in time 
for the worker to have to go to their next workplace.  

The java updats never completes because none of them have an admin level 
account.  It gets almost all the way through and then drops out.

In our office we also have a lot of part-timers but when people login the 
computer lets them get on with work rather than forcing them to wait for the 
machine to service itself badly.  

Regards from
Tom :)


--- On Fri, 10/2/12, Ian Whitfield whitfi...@telkomsa.net wrote:

From: Ian Whitfield whitfi...@telkomsa.net
Subject: Re: [libreoffice-users] LO Base questions
To: users@global.libreoffice.org
Date: Friday, 10 February, 2012, 9:03

On 09/02/2012 18:53, drew wrote:
 On Thu, 2012-02-09 at 17:12 +0200, Ian Whitfield wrote:
 On 07/02/2012 20:08, drew wrote:
 Periodically you should perform the following. When finished using the
 database, open the SQL window. Menu [FileSQL] In the command window
 enter: SHUTDOWN COMPACT You should, after a short while receive in the
 status field the message: 1: Command successfully executed. At that
 point close the file. [you must do so as the database engine is indeed
 shutdown at this point] This will reduce the size of the file on disk
 and the memory used at run-time, and will increase performance on
 startup and shutdown. Depending on how actively you edit that table
 this period can be once a week or once every two weeks..can't say what
 is right for your specific usage.
 Thanks Drew!!

 This worked a treat for me and I can see a marked improvement in my
 close-down times of the main DB and also closing Queries,

 A real Gem!! (Is there any way of automating this do you know??)
 Howdy Ian

 Glad it helped.

 Automating?

 As in a custom menu item for 'Close after Compact'
 _or_
 Every Friday compact the database?

 Thanks

 //drew

Good question Drew! (thinking...???)

I guess either would work but I think the first option would be my first 
choice. But rather 'Compact and Close'.

On reflection - whichever is the easiest to implement.

Ian Whitfield
Pretoria


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

-- 
For unsubscribe instructions e-mail to: users+h...@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] LO Base questions

[Ian Whitfield]

On 07/02/2012 20:08, drew wrote:
Periodically you should perform the following. When finished using the 
database, open the SQL window. Menu [FileSQL] In the command window 
enter: SHUTDOWN COMPACT You should, after a short while receive in the 
status field the message: 1: Command successfully executed. At that 
point close the file. [you must do so as the database engine is indeed 
shutdown at this point] This will reduce the size of the file on disk 
and the memory used at run-time, and will increase performance on 
startup and shutdown. Depending on how actively you edit that table 
this period can be once a week or once every two weeks..can't say what 
is right for your specific usage.


Thanks Drew!!

This worked a treat for me and I can see a marked improvement in my 
close-down times of the main DB and also closing Queries,


A real Gem!! (Is there any way of automating this do you know??)

Ian Whitfield
Pretoria

--
For unsubscribe instructions e-mail to: users+h...@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] LO Base questions

[drew]

On Thu, 2012-02-09 at 17:12 +0200, Ian Whitfield wrote:
 On 07/02/2012 20:08, drew wrote:
  Periodically you should perform the following. When finished using the 
  database, open the SQL window. Menu [FileSQL] In the command window 
  enter: SHUTDOWN COMPACT You should, after a short while receive in the 
  status field the message: 1: Command successfully executed. At that 
  point close the file. [you must do so as the database engine is indeed 
  shutdown at this point] This will reduce the size of the file on disk 
  and the memory used at run-time, and will increase performance on 
  startup and shutdown. Depending on how actively you edit that table 
  this period can be once a week or once every two weeks..can't say what 
  is right for your specific usage.
 
 Thanks Drew!!
 
 This worked a treat for me and I can see a marked improvement in my 
 close-down times of the main DB and also closing Queries,
 
 A real Gem!! (Is there any way of automating this do you know??)

Howdy Ian

Glad it helped.

Automating?

As in a custom menu item for 'Close after Compact'
_or_
Every Friday compact the database?

Thanks

//drew





-- 
For unsubscribe instructions e-mail to: users+h...@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] LO Base questions

[Heinrich Stoellinger]

Hi everybody,
At the risk of getting on people's nerves...
I have been trying on and off to download and install the native 
mysql-connector for LO-3.5
from the extensions site. I run Linux-Mint 12 (Lisa) as well as Debian-Wheezy.

Whenever I try to activate it, I get the message  loading component library 
failed
~/.config/libreoffice/3/user/uno_packages/cache/uno_packages/lupqfyfc.tmp_/mysql-native-connector-1.0.1-linux-32bit.oxt/mysqlc.uno.so
This file is of course present in exactly that directory and it always is the 
version
just downloaded a minute before. I have played around with less restricive 
permissions of
mysqlc.uno.so, but that didn't help. Any idea of what might be wrong?
Heinz

On Wed, 08 Feb 2012 12:24:41 +0100, Tom Davies tomdavie...@yahoo.co.uk wrote:


Hi :)

http://extensions.libreoffice.org/extension-center/mysql-native-connector-for-mac-osx

it is not mine.  I think Alex did the ones for Mac and GnuLinux but we still 
need someone to do one for Windows and possibly Bsd.  I think the Bsd people have 
their own wiki-system.  Somewhere in this mailing is a recent link to a Vista-only 
connector but i am not sure many people are still using Vista.  Didn't people 
upgrade back to Xp or on to 7 now?

Good luck and regards from
Tom :)


--- On Wed, 8/2/12, Ian Whitfield whitfi...@telkomsa.net wrote:

From: Ian Whitfield whitfi...@telkomsa.net
Subject: Re: [libreoffice-users] LO Base questions
To: users@global.libreoffice.org
Date: Wednesday, 8 February, 2012, 7:46

On 07/02/2012 20:36, Tom Davies wrote:

The MySql connector should work exactly the same for MariaDb as the code is 
almost identical with perhaps a few new features and plenty of bug-patches.


Thanks Tom!!

Where do I get _YOUR_ connector and how do I use it??

On 07/02/2012 20:36, Drew wrote:

Hi Ian,

One or maybe two quick things...

Also thanks Drew

Great advise - I will give this a go!!

Ian Whitfield
Pretoria




--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

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