--- In IBObjects@yahoogroups.com, "w1n9man" <trevorgoldsmith@e...> wrote:

>
> --- In IBObjects@yahoogroups.com, Lester Caine <lester@l...> wrote:
> > 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
>
> Lester,
>
> I was checking the WORKING table on update trigger. WORKING is a temp
> table with 4 fields and has the UID field set up as a primary key. I
> was trying to add a time to the finish field to check that the on
> update trigger would fire. After the trigger has fired the record is
> deleted (by another trigger on USERS Table) so at any given time there
> should only be one refernce to a UID in the table. I have tested the
> constraints for uniqueness on the UID field and they work.
>
> The table is set up like this:
>
> UID Integer NOT NULL PRIMARY KEY
> START TIME NOT NULL
> FINISH TIME
> ONDATE DATE NOT NULL
>
> I am at my wits end on this and I can honestly say that I have never
> had so much trouble updating one value in a table.
>
> Cheers
>
> Trevor

Lester,

Don't bother replying to the message above - I don't have the time to
mess about trying to fix this - I am going to use another database.
I was under the impression that this was supposed to be RAD, but I
don't think that 5 days spent on trying to apply an update to a single
field of a single table is what you would call RAD.

Thanks

Trevor