Roxy,

On Mon, 2011-06-20 at 13:47 -0400, Denis Poitras wrote:

> 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
> > 
> 

I use Windows and Linux - one for work and one at home. Some of the
issues are not OS specific either.

-- 
Jay Lozier
jsloz...@gmail.com

-- 
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

Reply via email to