Re: [libreoffice-users] Re: Bug\feature in LO Base master\slave form linking

Vladimir,

On Sun, 2011-06-26 at 16:57 +0000, Vladimir Drobyshevsky wrote:

> Have a nice day, Jay!
>
>
> planas <jslozier <at> gmail.com> writes:
>
> > Hi Vladimir,
> >
> > ...
> >
> > > Is it possible to change the way of LO making relation's query or to
> > > find an another way to solve my problem?
> > >
> > > Thank you in advance!
> > >
> > > P.S. I have no subscription to this mailing list so send your answers
> > > to my address too, please!
> > >
> > > -- 
> > > Sincerelly yours,
> > > Vladimir G. Drobyshevsky
> > > Wanna call me? Do it right now: +7 912 2473415
> >
> > My limited experience with SQL suggests you should qualify the typeID
> > fields to remove any ambiguity. I have had this problem when working
> > directly the outside database and developing queries for it. If one did
> > properly qualify the ambiguous fields you get a similar error message.
>
> Thank you for answer!
>
> You absolutelly right in your sugesstion, but WHERE clause is changed
> automatically (by adding 'AND "typeID" = :link_from_ProductID' ) by LO, as I
> wrote above. I would be very grateful if you can show me solution to change it.
>
> -- 
> Sincerelly yours,
> Vladimir G. Drobyshevsky
> Wanna call me? Do it right now: +7 912 2473415


I will show my limited experience I would not use ". The dialect I am
most familiar with does not normally use them. So my query would be
written:

SELECT invTypes.typeName AS Name,
invTypes.description AS Description,
invTypeMaterials.quantity AS Qty,
invTypeMaterials.typeID
FROM EDB.public.invTypes AS invTypes,
EDB.public.invTypeMaterials AS invTypeMaterials
WHERE invTypes.typeID = invTypeMaterials.materialTypeID

I am not sure if another dialect SQL requires the ".  I am looking at my
reference book SQL Server. I would think the dialects would not very
that much but I have surprised before.
-- 
Jay Lozier
jslozier@gmail.com

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