----- Original Message -----
From: "Joe Martinez" <joe@...>
To: "IB Objects" <IBObjects@yahoogroups.com>
Sent: Thursday, August 22, 2002 2:29 PM
Subject: [IBO] IBO Doesn't like this query
> I have the following query:
>
> select * from products
> left outer join vendorproducts on
> prodbarcode=vpupc and prodsource=vpvendor
> where vpcost = 0
> or vpcost is null
>
> I'm using a TIBOQuery.
>
> The query executes fine. I am able to retreive the number of rows. No
> problem there.
> Then I start scrolling through the dataset. I come to a row where a
> record in products matches more than one record in vendorproducts. IBO
> gives me the following error:
>
> Multiple rows in singleton fetch.
> Check KeyLinks and JoinLinks properties.
> select * from products
> left outer join vendorproducts on
> prodbarcode=vpupc and prodsource=vpvendor
> WHERE PRODBARCODE=? /* BIND_0 */
>
> This worked perfectly fine before, under the BDE.
>
> I would be happy to check the KeyLinks and JoinLinks, except that this
> is a dynamic query, typed in by the user. The user doesn't have access
> to those properties. Even if I gave them access, they shouldn't have to
> mess with those as an end user. It is a valid SQL statement, so it
> should work, right?
>
> I do also have a "detail" TDBGrid, linking the above query to a
> TIBOTable (vendorproducts) in a master/detail relationship
> (MasterSource, etc.) on prodbarcode=vpupc. Could that be what's
> complaining? TIBOTable doesn't have a JoinLinks property. I tried
> setting KeyLinks to VPVENDOR and VPVENDPARTNO (the key fields for that
> table), but it didn't make a difference.
>
> Help!
>
> -Joe
>
>
>
>
>
___________________________________________________________________________
> 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/
>
>