----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, September 12, 2001 1:57 PM
Subject: Re: [IBO] TIB_LookupCombo in a grid


> Dion,
> your SQL seems just fine - excepting that I can only see three candidates
for LookupCombos (I assume you have sensible indexes defined). You are
> using a TIB_Query, aren't you (I got a bit confused when you said 'Source
Table')?
>
> There's of course a bit more to using LookupCombos in a grid, but you've
hopefully read about all that in the Getting Started Guide.
>
> Set
>
> Dion wrote:
>
> > Hi all,
> >
> > I just need confirmation as to the efficiency of the SQL code in the
Source
> > Table. I placed the 4 TIB_lookupCombo's in a grid:-
> >
> > The Source Table reflects the relationship between MARKETER, FUND,
> > OPTION(FUND) and GROUP.
> >
> > SELECT
> > PERSONID
> > , OPTIONNAME
> > , FUNDNO
> > , GROUPNAME
> > , MARKETERID
> > , DOI
> > , (SELECT NAME
> > FROM FUND f
> > WHERE f.FUNDNO=m.FUNDNO)
> > AS THEFUNDNAME
> > , (SELECT FIRSTNAME
> > FROM MARKETER a
> > WHERE a.PERSONID=m.PERSONID)
> > AS MARKETERNAME
> > , (SELECT NAME
> > FROM GROUPS g
> > WHERE g.NAME=m.GROUPNAME)
> > AS GROUPNAME
> > FROM MEMBERINFUND m
> >
> > WHERE (m.PERSONID = :APERSONID)
> >
> > Thanks,
> > Dion.
> >
> > >
> > > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> > >
> > >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>