| Subject | RE: [IBO] Error using query with updatable view |
|---|---|
| Author | |
| Post date | 2018-01-05T12:41:20Z |
I now uploaded a zip file with a reproducable case.
Database has 2 tables, one base class table and one derived class table.
It also have a view, which combines both tables using a join.
It also have a trigger, that makes it updateable (I did not put in Delete trigger yet).
I did not put in any KeyLink property here as it did not change anything.
I don't run the project, I only edit it in Delphi 2007.
Open Query1 and open the dataset, see 1 row in data tab.
Now OK the dialog, get DB_KEY error.
If you unprepare, you can OK the dialog.
Database has 2 tables, one base class table and one derived class table.
It also have a view, which combines both tables using a join.
It also have a trigger, that makes it updateable (I did not put in Delete trigger yet).
I did not put in any KeyLink property here as it did not change anything.
I don't run the project, I only edit it in Delphi 2007.
Open Query1 and open the dataset, see 1 row in data tab.
Now OK the dialog, get DB_KEY error.
If you unprepare, you can OK the dialog.