Subject Bug in IBOQuery: Infinite occurrence of Error message "Multiple Rows in Singleton Fetch"
Author Raymond Kennington
Bug in IBOQuery: Infinite occurrence of Error message "Multiple Rows in Singleton Fetch"

In the IDE of D6, editing the query. The data displayed ok.

Edited the data in IB_SQL and committed the changes.

Clicked the refresh button on the IBOQuery/Data page and have to kill the instance of D6
and reboot Windows to recover memory.

--------
Error

Multiple rows in singleton fetch

Check KeyLinks and JoinLinks properties

SELECT ID, Name, Sex, "SIre ID" AS ParentID FROM Animal A1
WHERE ID=?/* BIND_0 */
UNION
SELECT ID, Name, Sex, "Dam ID" AS PreantID FROM Animal A1
WHERE Sex = 'F'
AND NOT EXISTS (SELECT "Dam ID" FROM Animal A2 WHERE A2."Dam ID" = A1.ID)
--------

However, the query I had entered that produced the data is:

SELECT ID, Name, Sex, "SIre ID" AS ParentID FROM Animal A1
WHERE Sex = 'M'
AND NOT EXISTS (SELECT "Sire ID" FROM Animal A2 WHERE A2."Sire ID" = A1.ID)
UNION
SELECT ID, Name, Sex, "Dam ID" AS PreantID FROM Animal A1
WHERE Sex = 'F'
AND NOT EXISTS (SELECT "Dam ID" FROM Animal A2 WHERE A2."Dam ID" = A1.ID)

KeyLinks: ID
JoinLinks: nil

--
Raymond Kennington
Programming Solutions
W2W Team B