Subject RE: [IBO] IBO4.6 and FB2
Author Alan McDonald
> My conversion and testing of 4.6 and FB2 is going OK but I have a really
> hard to find exception. The message is
>
> Project PCC.exe raised exception class EIB_ISCError with message
> 'ISC ERROR
> CODE:335544359
>
> ISC ERROR MESSAGE:
> attempted update of read-only column
> '. Process stopped. Use Step or Run to continue.
>
> If I switch to 1.5.3 on the same database, I get no exception and
> I can get
> an SQL monitor dump of the traffic during the form creation. It shows
> nothing untoward e.g. missing aliasing or calculated fields in the update
> statement.
> The message is curious with regard to '.
> i.e. it's not telling me anything about the fieldname.
> Stepping thru the debugger is painful. The closest I have got to
> it is that
> it occurs in the SysExecPrepare procedure IB_Components but I'm
> damned if I
> can catch the statement which excepts.
>
> Don't suppose anyone else is going thru something similar?
> Alan
>

It seems that I cannot put any kind of even the simplest update statement in
the update SQL box of the IB_Query in question without this exception coming
up.
If I put an update statement with fixed values into another table it works
but not even a fixed update statement e.g. UPDATE TABLEINQUESTION SET
PKFIELD=1
will work. The excpetion is thrown which appears wrong for the pk field of
the table...
any clues anyone would be appreciated.
Alan