Roxy, On Mon, 2011-06-20 at 13:47 -0400, Denis Poitras wrote:
> Le 2011-06-20 à 13:01, Roxy Robinson <[email protected]> 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 [email protected] > > In case of problems unsubscribing, write to > > [email protected] > > 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 [email protected] > > In case of problems unsubscribing, write to > > [email protected] > > 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 > > > I use Windows and Linux - one for work and one at home. Some of the issues are not OS specific either. -- Jay Lozier [email protected] -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] 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
