Subject | RE: [IBO] Alias conflicts with another alias on the same statement error |
---|---|
Author | Support List |
Post date | 2011-11-14T16:18:50Z |
Steve,
Also, let me know what version of IB/FB you are using.
Thanks,
Jason
> I'm using IBO 4.9.14 with Delphi XE2. When attempting to update a rowPlease provide me with a sample application for this error.
> using a TIB_Cursor I get the following error:
>
> Alias CT_GRID_COLUMNS conflicts with another alias in the same statement.
>
> CT_GRID_COLUMNS is the name of the table. It appears as though it is also
> being used as an alias, because the update SQL generated by IBO looks like
> this:
>
> UPDATE CT_GRID_COLUMNS CT_GRID_COLUMNS
> SET CT_GRID_COLUMNS.CGC_USER_ID = :CGC_USER_ID,
> CT_GRID_COLUMNS.CGC_GRID_NAME = :CGC_GRID_NAME,
> CT_GRID_COLUMNS.CGC_COLUMN_PROPERTIES = :CGC_COLUMN_PROPERTIES
> WHERE CURRENT OF C34126448462533611
>
> By "update" I mean that I am doing this:
>
> qry.Edit;
> qry.FieldByName('field1').AsString := 'some value';
> ...
> qry.Post;
>
> I have RequestLive := True and I have tried with KeyLinksAutoDefine :=
> True and False both.
Also, let me know what version of IB/FB you are using.
Thanks,
Jason