I don't choose to ignore anything, otherwise I wouldn't ask. I'll read it
again!

Mal

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Thursday, 5 September 2002 17:39
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Dynamic Query


At 04:33 PM 05-09-02 +1000, you wrote:

>Helen,
>
>Thanks. I got it sorted in the end with this info.
>
>With my query as:
>
>SELECT DISTINCT GROUPS.GRP_DESCRIPTION,
> SPRITEDETAIL.SD_DESCRIPTION,
> SPRITEDETAIL.SD_CAMERA,
> SPRITEDETAIL.SD_IPLOOKUPID,
> IPLOOKUP.ID,
> IPLOOKUP.IPL_DESCRIPTION,
> IPLOOKUP.IPL_IPADDRESS,
> IPLOOKUP.IPL_LOCAL
>FROM SPRITEDETAIL
> INNER JOIN GROUPS ON (SPRITEDETAIL.SD_GROUPID = GROUPS.ID)
> INNER JOIN IPLOOKUP ON (SPRITEDETAIL.SD_IPLOOKUPID = IPLOOKUP.ID)
>
>(no WHERE clause)
>
>and
>
>KeyLinks: SD_IPLOOKUPID=IPLOOKUP.ID
>MasterLinks: SD_IPLOOKUPID=IPLOOKUP.ID
>
>and the datasource pointing to the lookup table
>
>all seems to be working fine now. I didn't need to use any
>parameters...does this sound OK.

No.
Re-read what I wrote last time.
Or just ignore it if you choose to.

HB.



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/