Subject | Bug in IBOQuery: Infinite occurrence of Error message "Multiple Rows in Singleton Fetch" |
---|---|
Author | Raymond Kennington |
Post date | 2002-11-17T01:30:34Z |
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
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