Subject | Fake Multiple Rows in Singleton Error |
---|---|
Author | James N Hitz |
Post date | 2008-04-04T10:54:54Z |
Dear All,
I have recently been trying to use IBObjects to the create a small
project. The following query generates a 'Multiple Errors in Singleton
Fetch' error, using TIBObjects:
select
fileid,
refid,
(select register.fullname from register where register.regid =
refid) as Client,
filerefnum,
(select file_typedesc from file_types where file_types.file_typeid
= casefiles.filetypeid) as FileType,
subject,
casenum,
bu_by,
next_actiondate,
(select tx_reasons.txreasondesc from tx_reasons where
tx_reasons.txreasonid = casefiles.next_actiontype) as ActionType,
(select register.fullname from register where register.regid =
next_actionby) as Action_By,
'Case Files' AS Src
from casefiles
where f_weekofyear(next_actiondate) = f_weekofyear(current_date) and
is_active=1
Copy-Pasting the same code into isql or ibExpert executes the query as
expected and yields no errors, leading me to conclude that there is
really nothing wrong with the query, except maybe how IBO parses it.
Any ideas?
Delphi 7, IBO 4.8.4, Firebird 2.0.3.
Jamez
I have recently been trying to use IBObjects to the create a small
project. The following query generates a 'Multiple Errors in Singleton
Fetch' error, using TIBObjects:
select
fileid,
refid,
(select register.fullname from register where register.regid =
refid) as Client,
filerefnum,
(select file_typedesc from file_types where file_types.file_typeid
= casefiles.filetypeid) as FileType,
subject,
casenum,
bu_by,
next_actiondate,
(select tx_reasons.txreasondesc from tx_reasons where
tx_reasons.txreasonid = casefiles.next_actiontype) as ActionType,
(select register.fullname from register where register.regid =
next_actionby) as Action_By,
'Case Files' AS Src
from casefiles
where f_weekofyear(next_actiondate) = f_weekofyear(current_date) and
is_active=1
Copy-Pasting the same code into isql or ibExpert executes the query as
expected and yields no errors, leading me to conclude that there is
really nothing wrong with the query, except maybe how IBO parses it.
Any ideas?
Delphi 7, IBO 4.8.4, Firebird 2.0.3.
Jamez