Will you please send me a test app that will duplicate this condition?

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Christian Mautendorfer" <phase-list@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, June 07, 2001 8:24 AM
Subject: [IBO] Problem with Locate Method


> Hi,
>
> depending on a GroupID I select a range of Records belonging to that
group.
> Then I try to locate a certain record in that group using the Locate
mehod.
> This works fine if the record exists that I'm trying to locate.
> If this record doesn't exist the Locate method (in TIB_Query) throws an
> exception
> instead of simply returning False.
>
> The Errortext is:
> "Multiple Rows in Singelton Fetch
>
> Check Keylinks and Joinlinks properties
>
> Select B.*
> From VBaseValueList B, VGroupsXBaseValueList G
> Where VBaseValueList.ID=? /* Bind_0 */"
>
> My SQL statement is:
> SELECT B.*
> FROM VBASEVALUELIST B, VGROUPSXBASEVALUELIST G
> WHERE (B.ID = BASEVALUELIST_ID)
> and (G.GROUPS_ID = :GROUPS_ID)
> and (VTYPE > 0)
>
>
> VBaseValueList is a View on BaseValuelist:
> Create View VBaseValueList as Select * from BaseValueList where Status =
0;
>
> VGROUPSXBASEVALUELIST is a the same kind of View on a Corsstable between
> Groups and BaseValueList.
>
> VType is at the moment always > 0.
>
> In the locate I try to find a certain B.ID value. (Int64)
>
> TIA for the Help
>
> Regards,
> Chris
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>