[libreoffice-users] Need help to translate mdb file in odb

2013-07-12 Thread Jean Milot
Hello, I have a mdb file and i want to use it with LibreOffice so I need to translate all the macro, form ... for LibreOffice. But i have some difficult to do it. For example, how to concatenate 2 field in my SQL Request. I have tried : - [NAME] + [FIRSTNAME] , ok but i need an espace -

Re: [libreoffice-users] Need help to translate mdb file in odb

2013-07-12 Thread Jay Lozier
Jean The Concat() function would be Concat(Name, ' ', Firstname) the column names are not in brackets in standard SQL. This will work with MySQL/MariaDB - I am copying it out a book. For the second line [NAME] + + [FIRSTNAME] try [NAME] + ' ' + [FIRSTNAME] often ' are used to denote a

Re: [libreoffice-users] Need help to translate mdb file in odb

2013-07-12 Thread Tom Davies
.  Regards from Tom :)  From: Jay Lozier jsloz...@gmail.com To: users@global.libreoffice.org Sent: Saturday, 13 July 2013, 1:35 Subject: Re: [libreoffice-users] Need help to translate mdb file in odb Jean The Concat() function would be Concat(Name