Subject Re: [IBO] ISC_ERROR 335544652 multiple rows in singleton select
Author Lester Caine
w1n9man wrote:

> -- STOP PRESS -----
> I was just checking something using IBO Console and guess what ?
> ISC_ERROR 335544652 from IBO Console !!

That sounds like a good starting point. What were you checking?
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