date:20130111

Hi :) 
So in the editing can you change the direction? or rather the way that the 
relationships works?
Regards from
Tom :)  






 From: Girvin R. Herr girvin.h...@sbcglobal.net
To: Tom Davies tomdavie...@yahoo.co.uk 
Cc: Dan Lewis elderdanle...@gmail.com; users@global.libreoffice.org 
users@global.libreoffice.org 
Sent: Thursday, 10 January 2013, 21:44
Subject: Re: [libreoffice-users] Re: Base scenario
 
Tom,
Yes.  I confirmed that right-clicking on a join line does allow deleting or 
editing.
If I understand you correctly, no, relationship definitions should not be part 
of the back-end.  The table relationship is defined for the back-end by the 
front-end through the SQL statements.  For example, I have a table of 
suppliers, with names and addresses and other contact information.  This table 
is related to almost all of my database (main) tables.  Additionally, each 
main table has its own set of table relationships with other (sub?) tables, 
most of which are for selecting options with a join.  Each record of these 
option tables contains a primary key and a text field for the option.  For 
example, I have a table of statuses for the item in the main table record.  An 
integer foreign key in the main table contains a primary key value 
corresponding to the text element of the statuses table record.  That way, I 
am only storing an integer (key value) in the main table, rather than the 
option text, and with no repeated option text.  It
 also standardizes the option texts.  All of these multiple relationships must 
be defined by me - ergo it needs to be in the front-end.
Hope this helps clarify this.
Girvin Herr



Tom Davies wrote:
 Hi :)
 Can you right-click on a relationship's join-line and edit it's properties?  
 Shouldn't the relationships be part of the back-end rather than defined in 
 the front-end?  Regards from
 Tom :)  
 
 
 
 
  
 
 From: Dan Lewis elderdanle...@gmail.com
 To: users@global.libreoffice.org Sent: Wednesday, 9 January 2013, 4:14
 Subject: Re: [libreoffice-users] Re: Base scenario
 
 Comment inline below.
 
 --Dan
 
 On 01/08/2013 07:07 PM, Girvin R. Herr wrote:
    
 Ian,
 Have you actually drawn any relationships?  Base will not do that for you. 
  Just adding the tables in the 'Relationships Window' will not create the 
 relationships automagically.  You must click and hold on the one table 
 element (remote key) and drag over to the related table's element (primary 
 key), then release the mouse button.  Base will then draw a line between 
 the two.  Note, the order of the drag is important.  It determines the 
 type of join. Joins are confusing to me too, so I can't help much there.  
 I had to experiment with the direction to get it to work right.  I think 
 it was remote key to primary key, but I am not sure of that any more.
 
 Warning!  The way the SQL language is set up, if either of the ends of a 
 join (relationship) is NULL, then the record will be discarded and not 
 show up in your result set.  No warnings, no errors.  Data records will 
 just be missing.  IMHO, this is stupid (my mantra is: thou shall not lose 
 data), but that is how the SQL language was set up.  So, make sure any 
 joined data elements in all of your table records are not NULL.  Note that 
 NULL is not zero (0) and vice-versa!  NULL means that there is no data in 
 the record element.  I use a lot of remote keys in my database main tables 
 that point to primary keys (options) in other tables.  In those other 
 tables, I have made it a point to make the data elements of the first 
 record to be -, which is my equivalent of unknown, just to have 
 something to select that is not NULL.  You could probably use a blank ( 
 ), but I prefer seeing the - in forms and reports.  Most times in 
 reports, it is
 hard
      
  to see anyway.  Seeing the - tells me the field is not NULL.
  
 Hope this helps.
 Girvin Herr
 
      
       These statements about joins do not seem to be quite correct. What 
you are describing is an Inner Join: you will only see the rows of data in 
which both the foreign (remote) key and the primary key have a value.
      Suppose we have two tables A and B and that the foreign (remote) key 
is in table A and the primary key is in table B.
     Example 1: table A Left Outer Join table B. The output (result set) for 
this contains all the fields in table A and their values on the left side of 
the combined table. The right side contains all the fields in Table B. The 
rows in which the primary key value matches the foreign key value, data from 
both table appear in the output. However, where there is no primary key 
value in table B that matches the foreign key value in table A, all the 
fields from table B for that row will be NULL.
      Example 2: table A Right Outer Join table B. The output for this 
contains all the fields in table B and their values on the right side. For 
each output row in which the

[libreoffice-users] Re: LibreOffice on Win2008 with RDP terminal services

2013-01-11 Thread Tom Johnson

I was able to resolve my problem. Here's what I learned. It appears that
LibreOffice creates some sort of session/temp file within the user profile
folder while LO is in use. The user profile folder was located in
c:\users\username\appdata\roaming\LibreOffice\3. When more than one
terminal session was logged in using the same account name LO in each
session is trying to read/write files in the same folder causing conflict.

Looking through documentation, it appears that this path is configurable via
the bootstrap.ini file in C:\Program Files\LibreOffice 3.6\program. There
is a UserInstallation variable in there that utilizes a $SYSUSERCONFIG
variable. My system did not have this env variable set so it was using
whatever the default path was for LibreOffice.

I created a batch script that is run on login that creates an env variable
name SYSUSERCONFIG and points it to a temp file location that is
session-specific. That way each terminal session gets its own path.

This seems to have resolved my problem.

--
View this message in context:
http://nabble.documentfoundation.org/LibreOffice-on-Win2008-with-RDP-terminal-services-tp4028002p4028531.html
Sent from the Users mailing list archive at Nabble.com.

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

[Solved], Congrats! :) Re: [libreoffice-users] Re: LibreOffice on Win2008 with RDP terminal services

Hi :)
Blimey!!  Well found!  Hopefully that and other tricks are in the documentation 
for 'corporate' users
https://wiki.documentfoundation.org/Documentation/Publications#Corporate_Users

Sorry i didn't spot the question in good time!
Apols, congrats and regards from 

Tom :)  







 From: Tom Johnson tojo4...@gmail.com
To: users@global.libreoffice.org 
Sent: Friday, 11 January 2013, 17:42
Subject: [libreoffice-users] Re: LibreOffice on Win2008 with RDP terminal 
services
 
I was able to resolve my problem.   Here's what I learned.  It appears that
LibreOffice creates some sort of session/temp file within the user profile
folder while LO is in use.  The user profile folder was located in
c:\users\username\appdata\roaming\LibreOffice\3.  When more than one
terminal session was logged in using the same account name LO in each
session is trying to read/write files in the same folder causing conflict.

Looking through documentation, it appears that this path is configurable via
the bootstrap.ini file in C:\Program Files\LibreOffice 3.6\program.  There
is a UserInstallation variable in there that utilizes a $SYSUSERCONFIG
variable.  My system did not have this env variable set so it was using
whatever the default path was for LibreOffice.

I created a batch script that is run on login that creates an env variable
name SYSUSERCONFIG and points it to a temp file location that is
session-specific.  That way each terminal session gets its own path. 

This seems to have resolved my problem.



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-on-Win2008-with-RDP-terminal-services-tp4028002p4028531.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Base: Action Queries

Hi :)  
I'm trying to re-build a database that has become unweildy in Access and 
because it's Access it lacks scalability and some of the functionality we 
expect of it.  

I've exported a tiny part of the data, and ended up with 2 columns
ClientID
CompanyName
Not all clients have a company name so there are a lot of blanks in the 2nd 
column.  I've written a query to just show the non-blanks (=non-nulls) but now 
i want to make that into a table in it's own right.  Is there an easy way to 
get a query to create the table for me or should i export as a Csv?  

It's been a long time since i last wrote a database and then it was in 
Access.  So, please try to forgive me asking a stupid question
Thanks and regards from  
Tom :)  

-- 
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] Re: Base: Action Queries

2013-01-11 Thread Alex Thurgood


Le 11/01/2013 21:28, Tom Davies a écrit :

Hi Tom,



I've exported a tiny part of the data, and ended up with 2 columns
ClientID
CompanyName
Not all clients have a company name so there are a lot of blanks in the 2nd 
column.  I've written a query to just show the non-blanks (=non-nulls) but now 
i want to make that into a table in it's own right.  Is there an easy way to 
get a query to create the table for me or should i export as a Csv?



This might help
http://www.techonthenet.com/sql/insert.php

using INSERT ... SELECT


Alex



--
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] Re: Base: Action Queries

Hi :)
Thanks guys :)  Ok, so i am starting out with the embedded database against all 
advice but just so that i can keep emailing it to myself easily until i get to 
grips with it better.  Then i hope to export this table to whatever small 
back-end seems best.  My Sql coding gets rejected Syntax error in SQL 
expression and then these SQL Status: HY000   Error code: 1000   Syntax error 
in SQL expression
SQL Status: HY000   Error code: 1000
SQL Status: HY000   Error code: 1000   syntax error, unexpected $end, 
expecting BETWEEN or IN or SQL_TOKEN_LIKE

Here's 'my' code

INSERT INTO OrgTable 
(IdOfOrg, IdOfPerson, OrgName)
SELECT (IdOfOrg, IdOfPerson, OrgName)
FROM  zzQuery1 
WHERE OrgName IS NOT NULL;

Regards from
Tom :)  







 From: Alex Thurgood alex.thurg...@gmail.com
To: users@global.libreoffice.org 
Sent: Friday, 11 January 2013, 20:46
Subject: [libreoffice-users] Re: Base:  Action Queries
 
Le 11/01/2013 21:28, Tom Davies a écrit :

Hi Tom,


 I've exported a tiny part of the data, and ended up with 2 columns
 ClientID
 CompanyName
 Not all clients have a company name so there are a lot of blanks in the 2nd 
 column.  I've written a query to just show the non-blanks (=non-nulls) but 
 now i want to make that into a table in it's own right.  Is there an easy 
 way to get a query to create the table for me or should i export as a Csv?


This might help
http://www.techonthenet.com/sql/insert.php

using INSERT ... SELECT


Alex



-- 
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] Re: Base scenario


Tom,
I can't seem to change the direction from the editing (Join Properties) 
dialog.  If the direction needs to be changed, I have been selecting the 
line by right-clicking on it and selecting the Delete option.  I then 
re-enter the relationship (Join) in the opposite direction as I had 
explained in my last posting to Dan et al.


The type of Join can be changed in the right-click Edit option under 
the Join Properties dialog.  There is a Type list box, which has the 
Inner, Left, Right, or Cross Join options.  Under that list box in the 
dialog, there is a table labeled Fields involved, with two columns, 
left and right, corresponding to the left and right join ends.  Under 
that panel, is a hint of sorts, that explains the Join type, the 
direction, and that warning about the join may not be supported, for all 
but when Inner is selected in the list box.  There is another radio 
button labeled Natural for a Natural Join augmentation, but I am not 
familiar with that option.


Hope this helps.
Girvin Herr



Tom Davies wrote:

Hi :)
So in the editing can you change the direction? or rather the way that 
the relationships works?

Regards from
Tom :) 




*From:* Girvin R. Herr girvin.h...@sbcglobal.net
*To:* Tom Davies tomdavie...@yahoo.co.uk
*Cc:* Dan Lewis elderdanle...@gmail.com;
users@global.libreoffice.org users@global.libreoffice.org
*Sent:* Thursday, 10 January 2013, 21:44
*Subject:* Re: [libreoffice-users] Re: Base scenario

Tom,
Yes.  I confirmed that right-clicking on a join line does allow
deleting or editing.
If I understand you correctly, no, relationship definitions should
not be part of the back-end.  The table relationship is defined
for the back-end by the front-end through the SQL statements.  For
example, I have a table of suppliers, with names and addresses and
other contact information.  This table is related to almost all of
my database (main) tables.  Additionally, each main table has
its own set of table relationships with other (sub?) tables, most
of which are for selecting options with a join.  Each record of
these option tables contains a primary key and a text field for
the option.  For example, I have a table of statuses for the item
in the main table record.  An integer foreign key in the main
table contains a primary key value corresponding to the text
element of the statuses table record.  That way, I am only storing
an integer (key value) in the main table, rather than the option
text, and with no repeated option text.  It also standardizes the
option texts.  All of these multiple relationships must be defined
by me - ergo it needs to be in the front-end.
Hope this helps clarify this.
Girvin Herr



Tom Davies wrote:
 Hi :)
 Can you right-click on a relationship's join-line and edit it's
properties?  Shouldn't the relationships be part of the back-end
rather than defined in the front-end?  Regards from
 Tom :) 





 
 

 From: Dan Lewis elderdanle...@gmail.com
mailto:elderdanle...@gmail.com
 To: users@global.libreoffice.org
mailto:users@global.libreoffice.org Sent: Wednesday, 9 January
2013, 4:14
 Subject: Re: [libreoffice-users] Re: Base scenario

 Comment inline below.

 --Dan

 On 01/08/2013 07:07 PM, Girvin R. Herr wrote:
   
 Ian,

 Have you actually drawn any relationships?  Base will not do
that for you.  Just adding the tables in the 'Relationships
Window' will not create the relationships automagically.  You must
click and hold on the one table element (remote key) and drag over
to the related table's element (primary key), then release the
mouse button.  Base will then draw a line between the two.  Note,
the order of the drag is important.  It determines the type of
join. Joins are confusing to me too, so I can't help much there. 
I had to experiment with the direction to get it to work right.  I

think it was remote key to primary key, but I am not sure of that
any more.

 Warning!  The way the SQL language is set up, if either of the
ends of a join (relationship) is NULL, then the record will be
discarded and not show up in your result set.  No warnings, no
errors.  Data records will just be missing.  IMHO, this is stupid
(my mantra is: thou shall not lose data), but that is how the
SQL language was set up.  So, make sure any joined data elements
in all of your table records are not NULL.  Note that NULL is not
zero (0) and vice-versa!  NULL means that there is no data in the
record element.  I use a lot of remote keys in my database main
tables that point to primary keys (options) in other tables.  In
those other tables, I have made it a point to

Re: [libreoffice-users] Re: Base: Action Queries


Tom,
One thing that popped out at me is that you used double quotes () 
around your names.  So I checked one of my queries to be sure and 
confirmed Base is using the single reverse quote ` ( not ').  You might 
try that.  The ...unexpected $end... is a clue.  It sounds like it is 
finding an end-of-statement prematurely.  On my keyboard, the single 
reverse quote is the quote under the ~ tilde key, not the single quote 
under the  key.

Hope this helps.
Girvin Herr


Tom Davies wrote:

Hi :)
Thanks guys :)  Ok, so i am starting out with the embedded database against all advice but just so 
that i can keep emailing it to myself easily until i get to grips with it better.  Then i hope to 
export this table to whatever small back-end seems best.  My Sql coding gets rejected Syntax 
error in SQL expression and then these SQL Status: HY000   Error code: 1000   Syntax 
error in SQL expression
SQL Status: HY000   Error code: 1000
SQL Status: HY000   Error code: 1000   syntax error, unexpected $end, expecting 
BETWEEN or IN or SQL_TOKEN_LIKE

Here's 'my' code

INSERT INTO OrgTable 
(IdOfOrg, IdOfPerson, OrgName)

SELECT (IdOfOrg, IdOfPerson, OrgName)
FROM  zzQuery1 
WHERE OrgName IS NOT NULL;


Regards from
Tom :)  







  


From: Alex Thurgood alex.thurg...@gmail.com
To: users@global.libreoffice.org 
Sent: Friday, 11 January 2013, 20:46

Subject: [libreoffice-users] Re: Base:  Action Queries

Le 11/01/2013 21:28, Tom Davies a écrit :

Hi Tom,



I've exported a tiny part of the data, and ended up with 2 columns
ClientID
CompanyName
Not all clients have a company name so there are a lot of blanks in the 2nd 
column.  I've written a query to just show the non-blanks (=non-nulls) but now 
i want to make that into a table in it's own right.  Is there an easy way to 
get a query to create the table for me or should i export as a Csv?
  

This might help
http://www.techonthenet.com/sql/insert.php

using INSERT ... SELECT


Alex



--
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] Re: Base: Action Queries

2013-01-11 Thread Dan Lewis


 I wonder about the last line of your code:

WHERE OrgName IS NOT NULL;

Above this line you used  OrgName
 Your field has upper and lower case letters. When this is the 
case, you must enclose the field's name in double quotes. So, I'm 
thinking that this is likely the problem.


 A quote from the HSQLDB Guide (version 1.8):
name
 The character set for quoted identifiers (names) in HSQLDB is Unicode.
A unquoted identifier (name) starts with a letter and is followed by any 
number of AS-
CII letters or digits. When an SQL statement is issued, any lowercase 
characters in un-
quoted identifiers are converted to uppercase. Because of this, unquoted 
names are in
fact ALL UPPERCASE when used in SQL statements. An important implication 
of this
is the for accessing columns names via JDBC DatabaseMetaData: the 
internal form,
which is the ALL UPPERCASE must be used if the column name was not 
quoted in the

CREATE TABLE statement.
 Quoted identifiers can be used as names (for tables, columns, 
constraints or indexes).
Quoted identifiers start and end with  (one doublequote). A quoted 
identifier can con-
tain any Unicode character, including space. In a quoted identifier use 
 (two double-
quotes) to create a  (one doublequote). With quoted identifiers it is 
possible to create

mixed-case table and column names.

--Dan

On 01/11/2013 04:42 PM, Tom Davies wrote:

Hi :)
Thanks guys :)  Ok, so i am starting out with the embedded database against all advice but just so 
that i can keep emailing it to myself easily until i get to grips with it better.  Then i hope to 
export this table to whatever small back-end seems best.  My Sql coding gets rejected Syntax 
error in SQL expression and then these SQL Status: HY000   Error code: 1000   Syntax 
error in SQL expression
SQL Status: HY000   Error code: 1000
SQL Status: HY000   Error code: 1000   syntax error, unexpected $end, expecting 
BETWEEN or IN or SQL_TOKEN_LIKE

Here's 'my' code

INSERT INTO OrgTable
(IdOfOrg, IdOfPerson, OrgName)
SELECT (IdOfOrg, IdOfPerson, OrgName)
FROM  zzQuery1
WHERE OrgName IS NOT NULL;

Regards from
Tom :)








From: Alex Thurgood alex.thurg...@gmail.com
To: users@global.libreoffice.org
Sent: Friday, 11 January 2013, 20:46
Subject: [libreoffice-users] Re: Base:  Action Queries

Le 11/01/2013 21:28, Tom Davies a écrit :

Hi Tom,


I've exported a tiny part of the data, and ended up with 2 columns
ClientID
CompanyName
Not all clients have a company name so there are a lot of blanks in the 2nd 
column.  I've written a query to just show the non-blanks (=non-nulls) but now 
i want to make that into a table in it's own right.  Is there an easy way to 
get a query to create the table for me or should i export as a Csv?


This might help
http://www.techonthenet.com/sql/insert.php

using INSERT ... SELECT


Alex



--
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] Re: Base: Action Queries

Hi :)
I think i need to explore this a bit more tomorrow.  I tried both types of 
quotes and no quotes.  Then i made the field names unique and all lower-case 
and i tried using a query as the source rather than a table.  Then i tried 
editing my Sql code to the most basic example on the page
http://www.techonthenet.com/sql/insert.php
but even once i took out the Select part the error message kept grumbling 
about it.  So i think i might need to write the code in Gedit or something and 
then copypaste the code into a fresh query.  

I'm not quite sure what i'm doing wrong but that is not a big surprise.  I've 
got a bit of reading to do and some of that should make more sense now i've 
played around a bit.
Thanks all and regards from
Tom :)  






 From: Dan Lewis elderdanle...@gmail.com
To: users@global.libreoffice.org 
Sent: Friday, 11 January 2013, 23:08
Subject: Re: [libreoffice-users] Re: Base:  Action Queries
 
      I wonder about the last line of your code:

WHERE OrgName IS NOT NULL;

Above this line you used  OrgName
      Your field has upper and lower case letters. When this is the 
case, you must enclose the field's name in double quotes. So, I'm 
thinking that this is likely the problem.

      A quote from the HSQLDB Guide (version 1.8):
name
      The character set for quoted identifiers (names) in HSQLDB is Unicode.
A unquoted identifier (name) starts with a letter and is followed by any 
number of AS-
CII letters or digits. When an SQL statement is issued, any lowercase 
characters in un-
quoted identifiers are converted to uppercase. Because of this, unquoted 
names are in
fact ALL UPPERCASE when used in SQL statements. An important implication 
of this
is the for accessing columns names via JDBC DatabaseMetaData: the 
internal form,
which is the ALL UPPERCASE must be used if the column name was not 
quoted in the
CREATE TABLE statement.
      Quoted identifiers can be used as names (for tables, columns, 
constraints or indexes).
Quoted identifiers start and end with  (one doublequote). A quoted 
identifier can con-
tain any Unicode character, including space. In a quoted identifier use 
 (two double-
quotes) to create a  (one doublequote). With quoted identifiers it is 
possible to create
mixed-case table and column names.

--Dan

On 01/11/2013 04:42 PM, Tom Davies wrote:
 Hi :)
 Thanks guys :)  Ok, so i am starting out with the embedded database against 
 all advice but just so that i can keep emailing it to myself easily until i 
 get to grips with it better.  Then i hope to export this table to whatever 
 small back-end seems best.  My Sql coding gets rejected Syntax error in SQL 
 expression and then these SQL Status: HY000   Error code: 1000   Syntax 
 error in SQL expression
 SQL Status: HY000   Error code: 1000
 SQL Status: HY000   Error code: 1000   syntax error, unexpected $end, 
 expecting BETWEEN or IN or SQL_TOKEN_LIKE

 Here's 'my' code

 INSERT INTO OrgTable
 (IdOfOrg, IdOfPerson, OrgName)
 SELECT (IdOfOrg, IdOfPerson, OrgName)
 FROM  zzQuery1
 WHERE OrgName IS NOT NULL;

 Regards from
 Tom :)






 
 From: Alex Thurgood alex.thurg...@gmail.com
 To: users@global.libreoffice.org
 Sent: Friday, 11 January 2013, 20:46
 Subject: [libreoffice-users] Re: Base:  Action Queries

 Le 11/01/2013 21:28, Tom Davies a écrit :

 Hi Tom,

 I've exported a tiny part of the data, and ended up with 2 columns
 ClientID
 CompanyName
 Not all clients have a company name so there are a lot of blanks in the 
 2nd column.  I've written a query to just show the non-blanks (=non-nulls) 
 but now i want to make that into a table in it's own right.  Is there an 
 easy way to get a query to create the table for me or should i export as a 
 Csv?

 This might help
 http://www.techonthenet.com/sql/insert.php

 using INSERT ... SELECT


 Alex



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




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

[libreoffice-users] Switch off warnings

Hi!

When using PDF/A, the following messages were shown.

During PDF export the following problems occurred:

PDF/A forbids transparency. A transparent object was painted opaque instead.

Some objects were converted to an image in order to remove transparencies, 
because the target PDF format does not support transparencies. Possibly better 
results can be achieved if you remove the transparent objects before exporting.

I am fully informed. Is there a way to switch off these warnings? How?

Is there a better way to display the warnings, e.g. 
1. display warnings for 20 seconds and stop displaying them automatically, or 
2. display warnings in an action bar?

In both cases, users should be allowed to do other things without confirming 
that they see the warnings.

At present, users must press OK or the x before they can do other things.

Maybe, there should be a part like:
Tools - Options - LibreOffice - Warnings 
- 
( checked ) Enable warnings when XXX
( checked ) Enable warnings when YYY
( checked ) Enable warnings when ZZZ

This looks systematic.

Regards,
C. H. D.






_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
  
  
  
  
  
  
  
  

-- 
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] Base: Changing restoring (Default) font


Greetings,
I am running Base in LO 3.6.4.3.  In a form, I am trying to change the 
(Default) font without any progress.  I do not know where this 
(Default) font setting is located and the styles icon on the toolbar, 
along with the font window on the toolbar are grayed out if I have a 
control selected.  They are not grayed out if I do not have any control 
selected and then I can change the Default style font to another 
font.  However, when I select a control, the control properties dialog 
still has (Default) selected and the font displayed in the control is 
not the font I changed to in the style dialog.  Does anyone know where 
to set the font assigned to the (Default) font?


Second, related question:  Once the control's font is changed in the 
control properties dialog to something other than (Default), how does 
one get it back to (Default)?

The (Default) option is not available in the font selection dialog.

Thanks in advance.
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

[libreoffice-users] Base: Setting the default listbox entry


Greetings,
I am using LO 3.6.4.3 for Linux.  I am trying to set a default entry for 
a listbox based on a joined table.  The listbox has entries from the 
joined table as options.  One of those options is the character: - 
(dash).  I would like this option to be used whenever I do not set the 
listbox, rather than Base using NULL.  I am working in the listbox 
control's Properties-listbox dialog, Default selection box.  If I 
enter -, it gets changed to 0.  If I enter -, it gets changed to 
-.  I don't think either of these are what I want.  There is a 
continuation box ([...]) to the right of the Default selection box, but 
this icon does not seem to do anything.  The key number for the dash 
entry in the table is 1.  So, I tried entering 1 as the default 
selection, which resulted in 1.  I don't think this is what I want 
either. 
How do I get the default entry I want in this listbox control?

Is it possible?
Thanks.
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

[libreoffice-users] No version named 4.0.0.0 RC1

Hello!

I think the version numbers have not been refreshed properly.

I cannot report the bugs in LibreOffice 4 Release Candidate 1 here:

https://www.libreoffice.org/get-help/bug/

The error message I get is:

There is no version named '4.0.0.0 RC1' in the 'LibreOffice' product. 

Regards,
C. H. D.

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
  
  
  
  
  
  
  
  

-- 
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] Re: No version named 4.0.0.0 RC1

2013-01-11 Thread NoOp

On 01/11/2013 08:04 PM, C. H. D. wrote:
 Hello!
 
 I think the version numbers have not been refreshed properly.
 
 I cannot report the bugs in LibreOffice 4 Release Candidate 1 here:
 
 https://www.libreoffice.org/get-help/bug/
 
 The error message I get is:
 

https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOfficebug_status=UNCONFIRMED





-- 
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] Re: No version named 4.0.0.0 RC1

2013-01-11 Thread Dan Lewis


On 01/12/2013 12:14 AM, NoOp wrote:

On 01/11/2013 08:04 PM, C. H. D. wrote:

Hello!

I think the version numbers have not been refreshed properly.

I cannot report the bugs in LibreOffice 4 Release Candidate 1 here:

https://www.libreoffice.org/get-help/bug/

The error message I get is:


https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOfficebug_status=UNCONFIRMED

Does it make any difference if you use LibreOffice 4.0.0.1 RC1?

--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] Re: Base: Action Queries

2013-01-11 Thread Dan Lewis

If you are using Ubuntu, you can download MDB Viewer. It will open a 
Access database and reveal the database. With this you can export the 
tables. I think it does have some problems with exporting queries, but 
I'm not sure. It has been some time since I played around with it. Also, 
I seem to remember that Base can connect to an Access database using a 
driver (the bottom part of the Base wizard). As I understand it, the 
driver is part of the windows os. I think it may be AOO. If you use a 
Windows OS, then it should be in the list of drivers in the bottom drop 
down list with default value JDBC.


--Dan

On 01/11/2013 08:13 PM, Tom Davies wrote:

Hi :)
I think i need to explore this a bit more tomorrow.  I tried both types of 
quotes and no quotes.  Then i made the field names unique and all lower-case 
and i tried using a query as the source rather than a table.  Then i tried 
editing my Sql code to the most basic example on the page
http://www.techonthenet.com/sql/insert.php
but even once i took out the Select part the error message kept grumbling about 
it.  So i think i might need to write the code in Gedit or something and then copypaste 
the code into a fresh query.

I'm not quite sure what i'm doing wrong but that is not a big surprise.  I've 
got a bit of reading to do and some of that should make more sense now i've 
played around a bit.
Thanks all and regards from
Tom :)


From: Dan Lewis elderdanle...@gmail.com
To: users@global.libreoffice.org
Sent: Friday, 11 January 2013, 23:08
Subject: Re: [libreoffice-users] Re: Base:  Action Queries

   I wonder about the last line of your code:

WHERE OrgName IS NOT NULL;

Above this line you used  OrgName
   Your field has upper and lower case letters. When this is the
case, you must enclose the field's name in double quotes. So, I'm
thinking that this is likely the problem.

   A quote from the HSQLDB Guide (version 1.8):
name
   The character set for quoted identifiers (names) in HSQLDB is Unicode.
A unquoted identifier (name) starts with a letter and is followed by any
number of AS-
CII letters or digits. When an SQL statement is issued, any lowercase
characters in un-
quoted identifiers are converted to uppercase. Because of this, unquoted
names are in
fact ALL UPPERCASE when used in SQL statements. An important implication
of this
is the for accessing columns names via JDBC DatabaseMetaData: the
internal form,
which is the ALL UPPERCASE must be used if the column name was not
quoted in the
CREATE TABLE statement.
   Quoted identifiers can be used as names (for tables, columns,
constraints or indexes).
Quoted identifiers start and end with  (one doublequote). A quoted
identifier can con-
tain any Unicode character, including space. In a quoted identifier use
 (two double-
quotes) to create a  (one doublequote). With quoted identifiers it is
possible to create
mixed-case table and column names.

--Dan

On 01/11/2013 04:42 PM, Tom Davies wrote:

Hi :)
Thanks guys :)  Ok, so i am starting out with the embedded database against all advice but just so 
that i can keep emailing it to myself easily until i get to grips with it better.  Then i hope to 
export this table to whatever small back-end seems best.  My Sql coding gets rejected Syntax 
error in SQL expression and then these SQL Status: HY000   Error code: 1000   Syntax 
error in SQL expression
SQL Status: HY000   Error code: 1000
SQL Status: HY000   Error code: 1000   syntax error, unexpected $end, expecting 
BETWEEN or IN or SQL_TOKEN_LIKE

Here's 'my' code

INSERT INTO OrgTable
(IdOfOrg, IdOfPerson, OrgName)
SELECT (IdOfOrg, IdOfPerson, OrgName)
FROM  zzQuery1
WHERE OrgName IS NOT NULL;

Regards from
Tom :)

From: Alex Thurgood alex.thurg...@gmail.com
To: users@global.libreoffice.org
Sent: Friday, 11 January 2013, 20:46
Subject: [libreoffice-users] Re: Base:  Action Queries

Le 11/01/2013 21:28, Tom Davies a écrit :

Hi Tom,


I've exported a tiny part of the data, and ended up with 2 columns
ClientID
CompanyName
Not all clients have a company name so there are a lot of blanks in the 2nd 
column.  I've written a query to just show the non-blanks (=non-nulls) but now 
i want to make that into a table in it's own right.  Is there an easy way to 
get a query to create the table for me or should i export as a Csv?

This might help
http://www.techonthenet.com/sql/insert.php

using INSERT ... SELECT


Alex


--
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] Re: No version named 4.0.0.0 RC1

2013-01-11 Thread Joel Madero


On 01/11/2013 09:18 PM, Dan Lewis wrote:

On 01/12/2013 12:14 AM, NoOp wrote:

On 01/11/2013 08:04 PM, C. H. D. wrote:

Hello!

I think the version numbers have not been refreshed properly.

I cannot report the bugs in LibreOffice 4 Release Candidate 1 here:

https://www.libreoffice.org/get-help/bug/

The error message I get is:

https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOfficebug_status=UNCONFIRMED 


Does it make any difference if you use LibreOffice 4.0.0.1 RC1?

--Dan



I'm working on this right now.

Best Regards,
Joel


--
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] Re: No version named 4.0.0.0 RC1

2013-01-11 Thread Joel Madero


On 01/11/2013 09:18 PM, Dan Lewis wrote:

On 01/12/2013 12:14 AM, NoOp wrote:

On 01/11/2013 08:04 PM, C. H. D. wrote:

Hello!

I think the version numbers have not been refreshed properly.

I cannot report the bugs in LibreOffice 4 Release Candidate 1 here:

https://www.libreoffice.org/get-help/bug/

The error message I get is:

https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOfficebug_status=UNCONFIRMED 


Does it make any difference if you use LibreOffice 4.0.0.1 RC1?

--Dan

I made a mistake on freedesktop. The correct version is not RC1 but 
instead 4.0.0.1 rc, you should see this now in BSA and it'll work right. 
Please let me know if this doesn't correct the problem and apologies for 
the inconvenience.


Have a great weekend everyone!

Best Regards,
Joel

--
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] Re: Base scenario

2013-01-11 Thread Hank Alper

Ian
How are you defining your primary keys and your foreign keys ? From your
post, it looks like you have two tables, 'Members' and eMail. Implicit in
your post it appears that the primary key of 'Members' is 'Record ID'.
Also, the primary key of 'eMail' is 'Message ID' while a key called
'Members ID' is a foreign key in the 'eMail' table. I don't see anywhere
that you have specifically designated these keys as primary and foreign
keys. If you defined your tables in MySQL, I imagine you would have to add
the foreign key constraint and designate the primary keys in your
appropriate MySQL table definitions. If you do this, the relationships
window should show a connection between Members.Record ID and eMail.Members
ID. You might try , in the relationship window, to click on Record ID in
the Members table and drag to Members ID in the eMail table.
This dragging method works when using the embedded Database but I'm not
sure if it will transmit the necessary information to the remote database.
Hank

On Tue, Jan 8, 2013 at 9:32 AM, Ian Whitfield whitfi...@telkomsa.netwrote:

Hi All

Re - My previous post Have been doing some Googling etc and found the
'Relationships Window' for setting Relationships.

I can get the Window up, select my Tables but it _DOES NOT_ draw any
connecting lines or set any Relationships!!??

Is this another Gotcha of using MySQL and Base together? As it does
_NOT_ seem to work at all!!

I'm using PCLinuxOS 2012, LO Base 3.6.2.2 and MySQL 5.1.55

IanW
Pretoria RSA.

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
org users%2bh...@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

Re: [libreoffice-users] Switch off warnings

2013-01-11 Thread Joel Madero


On 01/11/2013 06:07 PM, C. H. D. wrote:

Hi!

When using PDF/A, the following messages were shown.

During PDF export the following problems occurred:

PDF/A forbids transparency. A transparent object was painted opaque instead.

Some objects were converted to an image in order to remove transparencies, 
because the target PDF format does not support transparencies. Possibly better 
results can be achieved if you remove the transparent objects before exporting.

I am fully informed. Is there a way to switch off these warnings? How?

Is there a better way to display the warnings, e.g.
1. display warnings for 20 seconds and stop displaying them automatically, or
2. display warnings in an action bar?

In both cases, users should be allowed to do other things without confirming 
that they see the warnings.

At present, users must press OK or the x before they can do other things.

Maybe, there should be a part like:
Tools - Options - LibreOffice - Warnings
-
( checked ) Enable warnings when XXX
( checked ) Enable warnings when YYY
( checked ) Enable warnings when ZZZ

This looks systematic.

Regards,
C. H. D.

Great idea, can you report it to bugzilla as an enhancement request. I 
can even imagine a scrolling warning across the bottomlots of 
options, I dig the idea though.



Best Regards,
Joel





_ _ _ _ _ _ _ _ _ _ _ _ _ _ _
   
   
   
   
   
   
   
   




--
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] Switch off warnings


Hi!

I have submitted the enhancement request. Thanks.

https://www.libreoffice.org/bugzilla/show_bug.cgi?id=59271

Regards,
C. H. D.





_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
  
  
  
  
  
  
  
  


--- 2013年1月12日 星期六，Joel Madero jmadero@gmail.com 寫道﹕

寄件人: Joel Madero jmadero@gmail.com
主題: Re: [libreoffice-users] Switch off warnings
收件人: users@global.libreoffice.org
日期: 2013年1月12日,星期六,下午2:57

On 01/11/2013 06:07 PM, C. H. D. wrote:
 Hi!
 
 When using PDF/A, the following messages were shown.
 
 During PDF export the following problems occurred:
 
 PDF/A forbids transparency. A transparent object was painted opaque instead.
 
 Some objects were converted to an image in order to remove transparencies, 
 because the target PDF format does not support transparencies. Possibly 
 better results can be achieved if you remove the transparent objects before 
 exporting.
 
 I am fully informed. Is there a way to switch off these warnings? How?
 
 Is there a better way to display the warnings, e.g.
 1. display warnings for 20 seconds and stop displaying them automatically, or
 2. display warnings in an action bar?
 
 In both cases, users should be allowed to do other things without confirming 
 that they see the warnings.
 
 At present, users must press OK or the x before they can do other things.
 
 Maybe, there should be a part like:
 Tools - Options - LibreOffice - Warnings
 -
 ( checked ) Enable warnings when XXX
 ( checked ) Enable warnings when YYY
 ( checked ) Enable warnings when ZZZ
 
 This looks systematic.
 
 Regards,
 C. H. D.
 
Great idea, can you report it to bugzilla as an enhancement request. I can even 
imagine a scrolling warning across the bottomlots of options, I dig the 
idea though.


Best Regards,
Joel
 
 
 
 
 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
                         


-- 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] Re: No version named 4.0.0.0 RC1