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