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 >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 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 >jsloz...@gmail.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 > > > -- 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] 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 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 jsloz...@gmail.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] Need help to "translate" mdb file in odb
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 -- Jean Milot - Directeur Technique jmi...@dotriver.eu - www.dotriver.eu 24 b rue Baldassini, F-69007 Lyon Fixe: +33 (0)4 2746 39 80 Direct: # 87 Hotline: # 89 Fax: # 81 Mob: +33 (0)6 68 15 58 17 DotRiver sur Euronews, rubrique hi-tech http://bit.ly/12iDC8h Renouvellement du label Lyon ville équitable et durable http://bit.ly/Rwv5F9 DotRiver, membre du consortium "nuage-France" http://bit.ly/LNIfMr Pas à pas, agissons au quotidien pour préserver notre environnement. N'imprimez que si nécessaire, réduisez vos déchets informatiques, économisez l'énergie en utilisant les solutions DotRiver. -- 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