| Subject | Re: [IBO] ISC_ERROR 335544652 multiple rows in singleton select |
|---|---|
| Author | Lester Caine |
| Post date | 2004-11-01T07:33:10Z |
w1n9man wrote:
This problem normally happens when you try and link fields that are not
'unique' and so I suspect you have two entries that are the same ID
number. Triggers and links in IBO will then complain when you try and
use a query that needs one record, but is seeing to two.
A quick fix in FB1.5 is to 'SELECT FIRST 1', but the real problem is
probably in how you are populating the data, and needs a 'UNIQUE' index
or even a 'PRIMARY KEY' on the field you are trying to link to.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
> -- STOP PRESS -----That sounds like a good starting point. What were you checking?
> I was just checking something using IBO Console and guess what ?
> ISC_ERROR 335544652 from IBO Console !!
This problem normally happens when you try and link fields that are not
'unique' and so I suspect you have two entries that are the same ID
number. Triggers and links in IBO will then complain when you try and
use a query that needs one record, but is seeing to two.
A quick fix in FB1.5 is to 'SELECT FIRST 1', but the real problem is
probably in how you are populating the data, and needs a 'UNIQUE' index
or even a 'PRIMARY KEY' on the field you are trying to link to.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services