Le 2011-06-20 à 13:01, Roxy Robinson <rocma...@ranchwireless.com> a écrit :
> From what I've seen on this list since signing on about 10 days ago, there > should > perhaps also be a "split" list between Windows users and Linux users! Well, I'm on Mac... > Roxy > > > Le 20/06/11 02:56, Denis Poitras a écrit : > > Hi Denis, > > >> (excuse my english, I speak french) > > You know, we have a French user mailing list too... > > >> >> The problem is in Propriety list zone on the data tab, for list content, >> on the > form, to concatenate PREFIX FIRSTNAME FAMILY NAME, I have this: >> >> SELECT "PREFIX"."Prefix" || ' ' || "PRENOMS"."Prenom" || ' ' || >> "NOMS"."Nom", > "PERS"."Idpp" FROM "PERS" >> LEFT JOIN "PREFIX" ON "PREFIX"."Cprefix" = "PERS"."PREFIXC" >> LEFT JOIN "PRENOMS" ON "PRENOMS"."Cpr" = "PERS"."PRENOMC" >> LEFT JOIN "NOMS" ON "NOMS"."Idnom" = "PERS"."NOMC" >> ORDER BY "NOMS"."Nom" >> >> It's work but each time I quit this base and reopen it, Base keep only the >> first > line of this sql things... >> > > Sounds like a bug. I'm a bit surprised that you don't use an ALIAS for > your SELECT CONCAT statement - have you tried with an ALIAS and did it > make any difference ? > > i.e. SELECT "PREFIX"."Prefix" || ' ' || "PRENOMS"."Prenom" || ' ' || > "NOMS"."Nom" AS 'NOMCOMPLET' > > There may also be an issue with the SQL parser that is built-in to LibO. > > Alex > > > -- > Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org > In case of problems unsubscribing, write to postmas...@documentfoundation.org > 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 > > > -- > Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org > In case of problems unsubscribing, write to postmas...@documentfoundation.org > 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 > -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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