--- In IBObjects@yahoogroups.com, Svein Erling Tysvaer
<svein.erling.tysvaer@...> wrote:

>
> p3pp3rh3ad wrote:
> > After upgrading to 4.8 (with FB1.54) I am getting an EIB_ISCError
> > exception when a key is pressed in any field while trying to

update a

> > record:
> >
> > ISC ERROR CODE: 335544569
> > ISC ERROR MESSAGE:
> > Dynamic SQL Error
> > SQL error code = -204
> > alias PATIENT conflicts with an alias in the same statement
> >
> > PATIENT is the table name, I'm not using an alias. Insert works

OK.

> > What should I be looking for?
>
> Tell us what components you are using, and how you are using them

(e.g.

> TIB_Query or TIBOQuery, 'SELECT... FROM...', KeyLinks, RequestLive).
>

I have a TIB_DataSource conected to a TIB_Cursor with KeyLinks set to
the PATIENT primary key (PATIENT.PATNUM) (KeyLinksAutoDefine = True).
CheckRequired = True, PreparedEdits = True, Pessimistic Locking = True
Update SQL:

UPDATE PATIENT SET
PATNUM = :PATNUM, /*PK*/
BIRTHDATE = :BIRTHDATE,
FNAME = :FNAME,
GENDER = :GENDER,
INITIAL = :INITIAL,
LNAME = :LNAME,
PATIENTID = :PATIENTID,
PATNOTES = :PATNOTES
WHERE
PATNUM = :OLD_PATNUM