Re: [SOLVED] [libreoffice-users] Counting Instances
On Mon, 30 Dec 2013 17:47:54 +1100 Keith Bates ke...@new-life.org.au wrote: Paul suggested using Subtotals on the column with the song title, but I found this sorted just that column which separated the song titles from other fields. I guess I could have selected the other fields as part of the sorting/sub-totalling, Yes, sorry, I should have mentioned this. You will want to select all the columns that have data, they will be sorted together. but the pivot table has the advantage of giving the information without messing with the data. Yes, I also found it the best solution. I too haven't really used them much. Hopefully I will remember them next time I need this. Glad you found a solution that worked well for you. Paul -- 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] Table of Contents - Crash
I am using an iMac 10.9.1. and LO 4.1.2. and whenever I enter Insert Indexes and Tables Indexes and Tables, LO crashes and I have to recover. I tried re-Boot, re-Download LO to no avail. Downloaded LO 4.2.1 and it works. Can someone confirm a bug in LO4.1.2 Tink -- View this message in context: http://nabble.documentfoundation.org/Table-of-Contents-Crash-tp4090132.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Changing email address - address is spam?
I need to change my subscription address to an email that is from my domain - I sent the subscription request and got the following *bilbo2.documentfoundation.org rejected your message to the following email addresses:* users+subscr...@global.libreoffice.org mailto:users%2bsubscr...@global.libreoffice.org *bilbo2.documentfoundation.org gave this error: Reject, id=14317-02 - SPAM * Your message wasn't delivered because the recipient's email provider rejected it.* Diagnostic information for administrators:* Generating server: AMSPR05MB264.eurprd05.prod.outlook.com Total retry attempts: 1 users+subscr...@global.libreoffice.org bilbo2.documentfoundation.org Remote Server returned '554 5.7.0 Reject, id=14317-02 - SPAM' Original message headers: Received: from [192.168.1.67] (217.39.50.78) by AMSPR05MB264.eurprd05.prod.outlook.com (10.242.95.27) with Microsoft SMTP Server (TLS) id 15.0.842.7; Mon, 30 Dec 2013 14:43:31 + Message-ID:52c18692.1080...@gbpcomputing.co.uk Date: Mon, 30 Dec 2013 14:43:30 + From: Gordon Burgess-Parkergor...@gbpcomputing.co.uk User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.2.0 MIME-Version: 1.0 To:users+subscr...@global.libreoffice.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Return-Path:gor...@gbpcomputing.co.uk X-Originating-IP: [217.39.50.78] X-ClientProxiedBy: DBXPR03CA019.eurprd03.prod.outlook.com (10.141.8.147) To AMSPR05MB264.eurprd05.prod.outlook.com (10.242.95.27) X-Forefront-PRVS: 0076F48C8A X-Forefront-Antispam-Report: SFV:SPM;SFS:(10009001)(619001)(199002)(189002)(80976001)(74876001)(36756003)(76176001)(74706001)(33656001)(74366001)(50466002)(80022001)(65956001)(66066001)(76786001)(76796001)(65806001)(47446002)(74482001)(74502001)(74662001)(79102001)(59766001)(77982001)(59896001)(31966008)(63696002)(83506001)(81686001)(73894003)(81816001)(54316002)(56776001)(621065002)(25636003)(85306002)(83072002)(85852003)(47776003)(56816005)(90146001)(77096001)(87976001)(49866001)(47736001)(50986001)(47976001)(23756003)(83322001)(4396001)(51856001)(80316001)(46102001)(81342001)(76482001)(81542001)(64126003)(42186004)(69226001)(54356001)(53806001)(59316009)(25626001);DIR:OUT;SFP:1501;SCL:5;SRVR:AMSPR05MB264;H:[192.168.1.67];CLIP:217.39.50.78;FPR:;RD:InfoNoRecords;A:0;MX:1;LANG:; X-OriginatorOrg: gbpcomputing.co.uk Reporting-MTA: dns; AMSPR05MB264.eurprd05.prod.outlook.com Final-recipient: RFC822;users+subscr...@global.libreoffice.org Action: failed Status: 5.7.0 Remote-MTA: dns; bilbo2.documentfoundation.org X-Supplementary-Info: bilbo2.documentfoundation.org #5.7.0 smtp;554 5.7.0 Reject, id=14317-02 - SPAM -- 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] Table of Contents - Crash
** Reply to message from Tinkerer j_taylo...@btinternet.com on Mon, 30 Dec 2013 04:30:08 -0800 (PST) I am using an iMac 10.9.1. and LO 4.1.2. and whenever I enter Insert Indexes and Tables Indexes and Tables, LO crashes and I have to recover. I tried re-Boot, re-Download LO to no avail. Downloaded LO 4.2.1 and it works. Can someone confirm a bug in LO4.1.2 Tink In LO 4.1.4 on a MacBook Pro 10.9.1 the same combination brings up the expected dialog box. Cliff -- 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] libreoffice writer freezes in ubunt 12.04
Friends, I am using libreoffice Version: 4.1.4.2 in ubuntu 12.04. I am able to open even big documents and work on it without any problem. However when i try to select a word and change the font color or highlight color etc, the libreoffice write freezes completely. To see if this could be related to the desktop effects, I have tried using both classic ubuntu and ubuntu 2D desktops. In both the cases, the freezing persists. Any idea how i can resolve it. Thanks, Bala -- C. Balasubramanian -- 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] Problem with export to PDF
Hi, I am not sure how to raise an issue so I am trying this list. I am finding that exporting from .xls to pdf format results in a corrupted file sometimes but not always. This happens when I am using Calc (with a .xls file) and I have created a Text insert, or have inserted an image. The first time I click on the pdf button at the top of the screen the output sometimes shows the text or image displaced from the position it has in the Calc page. Usually if I repeat by simply clicking on the pdf icon again I then get the correct output. If I fail to check the pdf file every time this can result in the corrupted output being sent by me to someone important. Is there a solution please? Thank you -- Para cualquier consulta adicional contacte con nosotros Mike Gunner, Director *INFORMATICA MATRAVERS S.L.U.* Especialistas en nuevas tecnologías para la educación m...@infomat.es Tel: 977 80 33 38 Móvil: 644489431 +44 843 532 4587 / +44 2380 986218 www.infomat.eswww.aula-activa.es www.avifi.com */Antes de imprimir, piensa en el Medio Ambiente. Be green - keep it on the screen./* AVISO LEGAL La informació continguda en aquest missatge de correu electrònic és confidencial i pot gaudir del caràcter de reservada, està destinada exclusivament al seu destinatari i l’accés o qualsevol altre ús d’aquest missatge per part de qualsevol altre persona no estan autoritzats i poden ser il•legals, pel que si no és vostè el seu destinatari li demanem que destrueixi aquest document. Este correo electrónico se dirige sólo a su destinatario, pudiendo contener información confidencial. Si Ud. no es el destinatario, debe saber que su lectura, copia y uso está prohibida. Le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda a su destrucción. El correo electrónico vía Internet no permite asegurar la confidencialidad de los mensajes que se transmiten ni su integridad, seguridad o correcta recepción. This e-mail and any attachments are for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please inform the sender and promptly delete this e-mail and any attachment and all copies. -- 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] Changing email address - address is spam?
I need toi change my subscription address to an email that is from my domain - I sent the subscription request and got the following *bilbo2.documentfoundation.org rejected your message to the following email addresses:* users+subscr...@global.libreoffice.org mailto:users%2bsubscr...@global.libreoffice.org *bilbo2.documentfoundation.org gave this error: Reject, id=14317-02 - SPAM * Your message wasn't delivered because the recipient's email provider rejected it.* Diagnostic information for administrators:* Generating server: AMSPR05MB264.eurprd05.prod.outlook.com Total retry attempts: 1 users+subscr...@global.libreoffice.org bilbo2.documentfoundation.org Remote Server returned '554 5.7.0 Reject, id=14317-02 - SPAM' Original message headers: Received: from [192.168.1.67] (217.39.50.78) by AMSPR05MB264.eurprd05.prod.outlook.com (10.242.95.27) with Microsoft SMTP Server (TLS) id 15.0.842.7; Mon, 30 Dec 2013 14:43:31 + Message-ID: 52c18692.1080...@gbpcomputing.co.uk Date: Mon, 30 Dec 2013 14:43:30 + From: Gordon Burgess-Parker gor...@gbpcomputing.co.uk User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.2.0 MIME-Version: 1.0 To: users+subscr...@global.libreoffice.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Return-Path: gor...@gbpcomputing.co.uk X-Originating-IP: [217.39.50.78] X-ClientProxiedBy: DBXPR03CA019.eurprd03.prod.outlook.com (10.141.8.147) To AMSPR05MB264.eurprd05.prod.outlook.com (10.242.95.27) X-Forefront-PRVS: 0076F48C8A X-Forefront-Antispam-Report: SFV:SPM;SFS:(10009001)(619001)(199002)(189002)(80976001)(74876001)(36756003)(76176001)(74706001)(33656001)(74366001)(50466002)(80022001)(65956001)(66066001)(76786001)(76796001)(65806001)(47446002)(74482001)(74502001)(74662001)(79102001)(59766001)(77982001)(59896001)(31966008)(63696002)(83506001)(81686001)(73894003)(81816001)(54316002)(56776001)(621065002)(25636003)(85306002)(83072002)(85852003)(47776003)(56816005)(90146001)(77096001)(87976001)(49866001)(47736001)(50986001)(47976001)(23756003)(83322001)(4396001)(51856001)(80316001)(46102001)(81342001)(76482001)(81542001)(64126003)(42186004)(69226001)(54356001)(53806001)(59316009)(25626001);DIR:OUT;SFP:1501;SCL:5;SRVR:AMSPR05MB264;H:[192.168.1.67];CLIP:217.39.50.78;FPR:;RD:InfoNoRecords;A:0;MX:1;LANG:; X-OriginatorOrg: gbpcomputing.co.uk Reporting-MTA: dns; AMSPR05MB264.eurprd05.prod.outlook.com Final-recipient: RFC822;users+subscr...@global.libreoffice.org Action: failed Status: 5.7.0 Remote-MTA: dns; bilbo2.documentfoundation.org X-Supplementary-Info: bilbo2.documentfoundation.org #5.7.0 smtp;554 5.7.0 Reject, id=14317-02 - SPAM -- 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: [SOLVED + CAVEAT] [libreoffice-users] rounding problem with Base
Hi :) You can make a Feature Request usignt he bug-report system https://wiki.documentfoundation.org/QA/BugReport Just hunt around the drop-downs to find the one that has Feature request at the bottom of it's list. At least i think it's at the bottom, they might have moved it up in the last couple of years. Regards from Tom :) On 29 December 2013 19:48, Ivan Sergio Borgonovo m...@webthatworks.it wrote: On Fri, 27 Dec 2013 19:06:58 +0100 Ivan Sergio Borgonovo m...@webthatworks.it wrote: To make the change in format permanent you've to build a view from the query and change the format there otherwise if you change the format in the query the format is lost next time you run the query. A bit weird. If I could give a suggestion I'd make the default format for numbers in queries follow the same schema as in postgresql (and most DB I know). NUMERIC(A, N) * NUMERIC(B, M) - NUMERIC(A + B, N + M) and FLOAT/DOUBLE all significant digits. On Fri, 27 Dec 2013 15:57:47 + Tom Davies tomc...@gmail.com wrote: Hi :) Are you saying you have solved this problem yourself without help from the list or has the problem just changed a bit? To summarize it for posterity: I wasn't able to appreciate if any change I was doing to the type used (NUMERIC(N, M) or FLOAT or DOUBLE) in SQL operations was effective since all I could get out from the DB was 2 decimals either in simple format (1234567898,31) or scientific format (6,23E+015). Not being able to see any change tricked me into thinking that no matter what type I was using there was no effect on precision since I'm used to something like: test=# select 1.01::numeric(4,2)*2.02::numeric(4,2); ?column? -- 2.0402 (1 row) The problem was just a problem of output format that can be set once you run the query, and in the result window right click on the column name and change the format. Thanks for the moral support anyway. -- Ivan Sergio Borgonovo http://www.webthatworks.it -- 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] Changing email address - address is spam?
On 30/12/2013 19:03, Tom Davies wrote: Hi :) Errr, could you try again? I guess you probably have tried a couple of times so i think we need to forwards tis to the mailing lists postmaster which should be listed at the bottom of the page about How To subscribe. Regards from Tom :) I've done that - got an Out of Office until 7th Jan:-) -- 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] Happy 2014 and Calendar
Dear Community, I would like to wish you all a magnific and splendid new year! 2014 is coming and it's time to celebrate. I offer for you this simple card and calendar: Card: https://owncloud.documentfoundation.org/public.php?service=filest=2411f4e6c737a523e639dd01750b8113 Calendar: https://owncloud.documentfoundation.org/public.php?service=filest=df37a6b4294ff4ff0a0a686f71731fe3 I'm sharing the source file and feel free to use. Card: SVG file: https://owncloud.documentfoundation.org/public.php?service=filest=89566bb10ea5269d2082b03f8e080367 Calendar: SVG file: https://owncloud.documentfoundation.org/public.php?service=filest=fb01a48e1f06ceceac91d831664d6c77 Best, -- Eliane Domingos de Sousa Comunidade LibreOffice Brasil Brazilian LibreOffice Community Liberte-se, para editar textos, planilhas e apresentações usehttp://pt-br.libreoffice.org/ é totalmente de graça. Experimente o sistema de perguntas e respostas da Comunidade LibreOffice Brasil:http://ask.libreoffice.org/pt-br/questions/ -- 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] mysterious foreign key integrity constraint violation
I've 2 tables:
Table:Products with ProductName as primary key.
ProductName Inventory
--- -
product1 100
product2 200
Table:Suppliers with SupplierName as primary key.
SupplierName PhoneNumber
---
supplier1 111-
supplier2 222-
when I attempt to create a relationship:
SupplierSuppliesProduct
between them, using the ToolsRelationship menu selection,
I get a Relation Design window with
both Tables and their fields displayed in the upper left.
In that window, I select the InsertNew Relation, menu item
resulting in a Relations window with:
Tables Involved
Products Suppliers
Fields Involved
Products Suppliers
-
[OK] [Cancel] [Help]
I enter ProductName under the Products column
and SupplierName under the Suppliers column, then press
the OK button, resulting in an error window containing
error message:
SQL Status: 23000
Error code: -177
Integrity constraint violation -no parent
product1, table: Products in statement
[ALTER TABLE Products ADD FOREIGN KEY
(ProductName) REFERENCES Suppliers
(SupplierName)]
Googling sql foreign key got hit:
http://en.wikipedia.org/wiki/Foreign_key#Defining_foreign_keys
which contained:
a foreign key is a field (or collection of fields) in one table
that uniquely identifies a row of another table.
which is exactly what I want. That hit also contained:
ALTER TABLE TABLE identifier
ADD [ CONSTRAINT CONSTRAINT identifier ]
FOREIGN KEY ( COLUMN expressionexpression}... )
REFERENCES TABLE identifier [ ( COLUMN expression {, COLUMN
expression}... ) ]
[ ON UPDATE referential action ]
[ ON DELETE referential action ]
which contains some of the same key words as the error message.
However, it doesn't help with the error message because I'm
not trying to alter the Products table, as the error message
suggests, I'm trying to create a new table, SupplierSuppliesProduct,
containing a relationship between two already existing tables. The
new table would look something like:
Table: SupplierSuppliesProduct
with primary keys SupplierName,ProductName
showing which Supplier supplies which Product.
How should I do that?
TiA.
-regards,
Larry
--
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] mysterious foreign key integrity constraint violation
You could resolve this with a foreign key in the Products table (would
require a new field) in which you store the primary key of the
applicable row in the suppliers table. This way one supplier could
supply more than one product. However, this would not cover the case
where one product can be supplied by more than one supplier. For that
you would need a third table just to handle the many-to-many relationship.
On 12/30/2013 6:39 PM, Larry Evans wrote:
I've 2 tables:
Table:Products with ProductName as primary key.
ProductName Inventory
--- -
product1 100
product2 200
Table:Suppliers with SupplierName as primary key.
SupplierName PhoneNumber
---
supplier1 111-
supplier2 222-
when I attempt to create a relationship:
SupplierSuppliesProduct
between them, using the ToolsRelationship menu selection,
I get a Relation Design window with
both Tables and their fields displayed in the upper left.
In that window, I select the InsertNew Relation, menu item
resulting in a Relations window with:
Tables Involved
Products Suppliers
Fields Involved
Products Suppliers
-
[OK] [Cancel] [Help]
I enter ProductName under the Products column
and SupplierName under the Suppliers column, then press
the OK button, resulting in an error window containing
error message:
SQL Status: 23000
Error code: -177
Integrity constraint violation -no parent
product1, table: Products in statement
[ALTER TABLE Products ADD FOREIGN KEY
(ProductName) REFERENCES Suppliers
(SupplierName)]
Googling sql foreign key got hit:
http://en.wikipedia.org/wiki/Foreign_key#Defining_foreign_keys
which contained:
a foreign key is a field (or collection of fields) in one table
that uniquely identifies a row of another table.
which is exactly what I want. That hit also contained:
ALTER TABLE TABLE identifier
ADD [ CONSTRAINT CONSTRAINT identifier ]
FOREIGN KEY ( COLUMN expressionexpression}... )
REFERENCES TABLE identifier [ ( COLUMN expression {, COLUMN
expression}... ) ]
[ ON UPDATE referential action ]
[ ON DELETE referential action ]
which contains some of the same key words as the error message.
However, it doesn't help with the error message because I'm
not trying to alter the Products table, as the error message
suggests, I'm trying to create a new table, SupplierSuppliesProduct,
containing a relationship between two already existing tables. The
new table would look something like:
Table: SupplierSuppliesProduct
with primary keys SupplierName,ProductName
showing which Supplier supplies which Product.
How should I do that?
TiA.
-regards,
Larry
--
Dale Erwin
Jr. 28 de Julio 657, Depto. 03
Magdalena del Mar, Lima 17 PERU
http://leather.casaerwin.org
--
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] mysterious foreign key integrity constraint violation
Hi Larry, Larry Evans schrieb: I've 2 tables: Table:Products with ProductName as primary key. ProductName Inventory --- - product1 100 product2 200 Table:Suppliers with SupplierName as primary key. SupplierName PhoneNumber --- supplier1 111- supplier2 222- [..] However, it doesn't help with the error message because I'm not trying to alter the Products table, as the error message suggests, I'm trying to create a new table, SupplierSuppliesProduct, containing a relationship between two already existing tables. The new table would look something like: Table: SupplierSuppliesProduct with primary keys SupplierName,ProductName showing which Supplier supplies which Product. How should I do that? First define this third table as new table and then set the relationships. It is a n:m structure. Kind regards Regina -- 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] mysterious foreign key integrity constraint violation
On 12/30/2013 06:39 PM, Larry Evans wrote:
I've 2 tables:
Table:Products with ProductName as primary key.
ProductName Inventory
--- -
product1 100
product2 200
Table:Suppliers with SupplierName as primary key.
SupplierName PhoneNumber
---
supplier1 111-
supplier2 222-
when I attempt to create a relationship:
SupplierSuppliesProduct
between them, using the ToolsRelationship menu selection,
I get a Relation Design window with
both Tables and their fields displayed in the upper left.
In that window, I select the InsertNew Relation, menu item
resulting in a Relations window with:
Tables Involved
Products Suppliers
Fields Involved
Products Suppliers
-
[OK] [Cancel] [Help]
I enter ProductName under the Products column
and SupplierName under the Suppliers column, then press
the OK button, resulting in an error window containing
error message:
SQL Status: 23000
Error code: -177
Integrity constraint violation -no parent
product1, table: Products in statement
[ALTER TABLE Products ADD FOREIGN KEY
(ProductName) REFERENCES Suppliers
(SupplierName)]
Googling sql foreign key got hit:
http://en.wikipedia.org/wiki/Foreign_key#Defining_foreign_keys
which contained:
a foreign key is a field (or collection of fields) in one table
that uniquely identifies a row of another table.
which is exactly what I want. That hit also contained:
ALTER TABLE TABLE identifier
ADD [ CONSTRAINT CONSTRAINT identifier ]
FOREIGN KEY ( COLUMN expressionexpression}... )
REFERENCES TABLE identifier [ ( COLUMN expression {, COLUMN
expression}... ) ]
[ ON UPDATE referential action ]
[ ON DELETE referential action ]
which contains some of the same key words as the error message.
However, it doesn't help with the error message because I'm
not trying to alter the Products table, as the error message
suggests, I'm trying to create a new table, SupplierSuppliesProduct,
containing a relationship between two already existing tables. The
new table would look something like:
Table: SupplierSuppliesProduct
with primary keys SupplierName,ProductName
showing which Supplier supplies which Product.
How should I do that?
TiA.
-regards,
Larry
You need to add a field to table Products that contains the name
contained in Suppliers.SupplierName such that
Products.NewField = Suppliers.SupplierName
Table:Products with ProductName as primary key.
ProductName Inventory Supplier
--- -
product1 100 supplier1
product2 200 supplier1
product3 125 supplier2
The database has no way of knowing which supplier/product are related to
each other.
You will also need to add a field to the Products table that indicates
which entry is current. When you first set up the products table there
will be only one supplier for each product, but over time, the supplier
will change. If you don't want to keep a history of past suppliers then
you will not need the current field.
--
_
°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] Re: mysterious foreign key integrity constraint violation
On 12/30/13 18:21, Regina Henschel wrote: Hi Larry, Larry Evans schrieb: I've 2 tables: Table:Products with ProductName as primary key. ProductName Inventory --- - product1 100 product2 200 Table:Suppliers with SupplierName as primary key. SupplierName PhoneNumber --- supplier1 111- supplier2 222- [..] However, it doesn't help with the error message because I'm not trying to alter the Products table, as the error message suggests, I'm trying to create a new table, SupplierSuppliesProduct, containing a relationship between two already existing tables. The new table would look something like: Table: SupplierSuppliesProduct with primary keys SupplierName,ProductName showing which Supplier supplies which Product. How should I do that? First define this third table as new table and then set the relationships. It is a n:m structure. Kind regards Regina Ah! Yes. Tried it and it works. Seems obvious now. Thanks. -regards, Larry -- 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] Changing email address - address is spam?
Hi :) Errr, could you try again? I guess you probably have tried a couple of times so i think we need to forwards tis to the mailing lists postmaster which should be listed at the bottom of the page about How To subscribe. Regards from Tom :) On 30 December 2013 15:03, Gordon Burgess-Parker gordonb...@gmail.com wrote: I need toi change my subscription address to an email that is from my domain - I sent the subscription request and got the following *bilbo2.documentfoundation.org rejected your message to the following email addresses:* users+subscr...@global.libreoffice.org mailto:users%2bsubscr...@global.libreoffice.org *bilbo2.documentfoundation.org gave this error: Reject, id=14317-02 - SPAM * Your message wasn't delivered because the recipient's email provider rejected it.* Diagnostic information for administrators:* Generating server: AMSPR05MB264.eurprd05.prod.outlook.com Total retry attempts: 1 users+subscr...@global.libreoffice.org bilbo2.documentfoundation.org Remote Server returned '554 5.7.0 Reject, id=14317-02 - SPAM' Original message headers: Received: from [192.168.1.67] (217.39.50.78) by AMSPR05MB264.eurprd05.prod.outlook.com (10.242.95.27) with Microsoft SMTP Server (TLS) id 15.0.842.7; Mon, 30 Dec 2013 14:43:31 + Message-ID: 52c18692.1080...@gbpcomputing.co.uk Date: Mon, 30 Dec 2013 14:43:30 + From: Gordon Burgess-Parker gor...@gbpcomputing.co.uk User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.2.0 MIME-Version: 1.0 To: users+subscr...@global.libreoffice.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Return-Path: gor...@gbpcomputing.co.uk X-Originating-IP: [217.39.50.78] X-ClientProxiedBy: DBXPR03CA019.eurprd03.prod.outlook.com (10.141.8.147) To AMSPR05MB264.eurprd05.prod.outlook.com (10.242.95.27) X-Forefront-PRVS: 0076F48C8A X-Forefront-Antispam-Report: SFV:SPM;SFS:(10009001)(619001)(199002)(189002)(80976001)(74876001)(36756003)(76176001)(74706001)(33656001)(74366001)(50466002)(80022001)(65956001)(66066001)(76786001)(76796001)(65806001)(47446002)(74482001)(74502001)(74662001)(79102001)(59766001)(77982001)(59896001)(31966008)(63696002)(83506001)(81686001)(73894003)(81816001)(54316002)(56776001)(621065002)(25636003)(85306002)(83072002)(85852003)(47776003)(56816005)(90146001)(77096001)(87976001)(49866001)(47736001)(50986001)(47976001)(23756003)(83322001)(4396001)(51856001)(80316001)(46102001)(81342001)(76482001)(81542001)(64126003)(42186004)(69226001)(54356001)(53806001)(59316009)(25626001);DIR:OUT;SFP:1501;SCL:5;SRVR:AMSPR05MB264;H:[192.168.1.67];CLIP:217.39.50.78;FPR:;RD:InfoNoRecords;A:0;MX:1;LANG:; X-OriginatorOrg: gbpcomputing.co.uk Reporting-MTA: dns; AMSPR05MB264.eurprd05.prod.outlook.com Final-recipient: RFC822;users+subscr...@global.libreoffice.org Action: failed Status: 5.7.0 Remote-MTA: dns; bilbo2.documentfoundation.org X-Supplementary-Info: bilbo2.documentfoundation.org #5.7.0 smtp;554 5.7.0 Reject, id=14317-02 - SPAM -- 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] Problem with export to PDF
Hi :) There are a couple other ways to generate Pdfs. 1. From the file menu click on Export to Pdf and that should give you a pop-up with tons of choices. I usually untick them all except for the compression. For versions i might want to print from i choose lossless compression 2. From the File menu choose Print but set the properties to Print to file and then hunt around to find how to set the format to Pdf rather than Ps. Regards from Tom :) On 30 December 2013 17:50, MATRAVERS, Mike m...@infomat.es wrote: Hi, I am not sure how to raise an issue so I am trying this list. I am finding that exporting from .xls to pdf format results in a corrupted file sometimes but not always. This happens when I am using Calc (with a .xls file) and I have created a Text insert, or have inserted an image. The first time I click on the pdf button at the top of the screen the output sometimes shows the text or image displaced from the position it has in the Calc page. Usually if I repeat by simply clicking on the pdf icon again I then get the correct output. If I fail to check the pdf file every time this can result in the corrupted output being sent by me to someone important. Is there a solution please? Thank you -- Para cualquier consulta adicional contacte con nosotros Mike Gunner, Director *INFORMATICA MATRAVERS S.L.U.* Especialistas en nuevas tecnologías para la educación m...@infomat.es Tel: 977 80 33 38 Móvil: 644489431 +44 843 532 4587 / +44 2380 986218 www.infomat.eswww.aula-activa.es www.avifi.com */Antes de imprimir, piensa en el Medio Ambiente. Be green - keep it on the screen./* AVISO LEGAL La informació continguda en aquest missatge de correu electrònic és confidencial i pot gaudir del caràcter de reservada, està destinada exclusivament al seu destinatari i l’accés o qualsevol altre ús d’aquest missatge per part de qualsevol altre persona no estan autoritzats i poden ser il•legals, pel que si no és vostè el seu destinatari li demanem que destrueixi aquest document. Este correo electrónico se dirige sólo a su destinatario, pudiendo contener información confidencial. Si Ud. no es el destinatario, debe saber que su lectura, copia y uso está prohibida. Le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda a su destrucción. El correo electrónico vía Internet no permite asegurar la confidencialidad de los mensajes que se transmiten ni su integridad, seguridad o correcta recepción. This e-mail and any attachments are for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please inform the sender and promptly delete this e-mail and any attachment and all copies. -- 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] Happy 2014 and Calendar
Eliane: Thank you very much ... both are great ! Happy New Year Regards, Jorge - Mensaje original - De: Eliane Domingos de Sousa elianedomin...@libreoffice.org Para: users@global.libreoffice.org Enviados: Lunes, 30 de Diciembre 2013 14:59:12 Asunto: [libreoffice-users] Happy 2014 and Calendar Dear Community, I would like to wish you all a magnific and splendid new year! 2014 is coming and it's time to celebrate. I offer for you this simple card and calendar: Card: https://owncloud.documentfoundation.org/public.php?service=filest=2411f4e6c737a523e639dd01750b8113 Calendar: https://owncloud.documentfoundation.org/public.php?service=filest=df37a6b4294ff4ff0a0a686f71731fe3 I'm sharing the source file and feel free to use. Card: SVG file: https://owncloud.documentfoundation.org/public.php?service=filest=89566bb10ea5269d2082b03f8e080367 Calendar: SVG file: https://owncloud.documentfoundation.org/public.php?service=filest=fb01a48e1f06ceceac91d831664d6c77 Best, -- Eliane Domingos de Sousa Comunidade LibreOffice Brasil Brazilian LibreOffice Community Liberte-se, para editar textos, planilhas e apresentações usehttp://pt-br.libreoffice.org/ é totalmente de graça. Experimente o sistema de perguntas e respostas da Comunidade LibreOffice Brasil:http://ask.libreoffice.org/pt-br/questions/ -- 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
