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