Subject | Alias conflicts with another alias on the same statement error |
---|---|
Author | sboydlns |
Post date | 2011-11-11T21:10:32Z |
I'm using IBO 4.9.14 with Delphi XE2. When attempting to update a row 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.
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.