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

Hi :)
Jean is not yet fully registered so please CC his address in all replies.  


Also i think my email address got compromised so i have changed my password but if i sent any 
emails in the last hour or so please just delete them.  The last legit one i sent to this list was 
over 12hours ago.  

Regards from 

Tom :)  






> ________________________________
> From: Jay Lozier <jslozier@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, ' ', 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 string not ".
>
> On Fri, 12 Jul 2013 18:33:31 -0400, Jean Milot <jmilot@dotriver.eu> wrote:
>
> > 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
> > - [NAME] + " " + [FIRSTNAME] , doesn't work
> > - LTRIM( coalesce( "NAME", '' ) || ' ' || "FIRSTNAME" ) , doesn't work
> > - "NAME" || ' ' || "FIRSTNAME", doesn't work
> > - CONCAT( [NAME], [FIRSTNAME] ), doesn't work
> >
> > How i can make it ???
> >
> > Thanks for your help.
> >
> > If someone could help me to "translate" the file, it would be nice
> >
> > Sincerely,
> >
> > Jean Milot
>
>
> -- 
> Jay Lozier
> jslozier@gmail.com
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@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+unsubscribe@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