Re: [libreoffice-users] Re: Base and SQL problems

Le 2011-06-20 à 13:01, Roxy Robinson <rocmar62@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+help@global.libreoffice.org
> In case of problems unsubscribing, write to postmaster@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+help@global.libreoffice.org
> In case of problems unsubscribing, write to postmaster@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+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@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