[libreoffice-users] Re: [libreoffice-l10n] Happy New Year 2016

2016-01-01 Thread Sylvia Sánchez
Thank you very much!! Same for you too!! Cheers, Sylvia -- 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:

[libreoffice-users] Happy New Year 2016

2016-01-01 Thread chandrakant dhutadmal
Hi All. Wish you and your family a very happy new year and lot of success ahead. Lets spread Libre Office like a fire around the world and make it the most used office software. Regards,Chandrakant Dhutadmal.Pune, India -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

2016-01-01 Thread Paul Steyn
Hi Don, Your SELECT statement is indeed incorrect; it seems as though you don't fully understand joins (I could be mistaken, but your syntax is off by enough to suggest this). Firstly, choose a format for your SELECT statement to make it easier to read. I've reformatted it below using one such

Re: [libreoffice-users] Checkbox in table cell (inside of a frame)

2016-01-01 Thread Brian Barker
At 08:15 31/12/2015 -0500, William Drescher wrote: I have a three col table inside of 3 linked frames. I would like to add a Checkbox in table cell. I followed the help instructions, but the checkbox icon does not drag from the form toolbar to the table. I suspect that I am missing a step.

Re: [libreoffice-users] LOBase Query - Left or Right Join?

2016-01-01 Thread Luuk
On 01-01-16 13:08, Don Parris wrote: Hi all, I have a set of tables for contacts, and a somewhat complex query that seeks all the available contact information on a subset of the contacts. By "incomplete result set", I mean I have one contact that does not show up in the query results, but

[libreoffice-users] LOBase Query - Left or Right Join?

2016-01-01 Thread Don Parris
Hi all, I have a set of tables for contacts, and a somewhat complex query that seeks all the available contact information on a subset of the contacts. By "incomplete result set", I mean I have one contact that does not show up in the query results, but should. I know why: that contact has phone

Re: [libreoffice-users] LOBase Query - Left or Right Join?

2016-01-01 Thread Don Parris
On Fri, Jan 1, 2016 at 10:59 AM, Luuk wrote: > > > > >> >> >> > > In design mode, right-click on the link between two tables, and click > 'edit'... > > > If you want to manually edit the SQL, the syntax is shown here: > >

[libreoffice-users] Re: LOBase Query - Left or Right Join?

2016-01-01 Thread Don Parris
Update: I did try re-writing the query with LEFT/RIGHT JOINS, but all I get are syntax errors. Maybe I have my SQL statement incorrect? SELECT "tCoreCategory"."category", "tCntEntity"."entity_name", "tCntPerson"."first_name", "tCntPerson"."last_name", "tCntAddress"."location_name",

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

2016-01-01 Thread Luuk
reply below On 01-01-16 18:06, Don Parris wrote: Update: I did try re-writing the query with LEFT/RIGHT JOINS, but all I get are syntax errors. Maybe I have my SQL statement incorrect? SELECT "tCoreCategory"."category", "tCntEntity"."entity_name", "tCntPerson"."first_name",