DAU question - IB Update Query
lazarus / 16-Databases

----------------------------------------------------------------------
Nicole · 2023-02-18 16:33

To show you, what I want to do will be illustrated best by a
screenshot.
I allow to choose tables. Dependent to the user's choice a query is
generated and the DBGrid is filled.
There are vaious panels, which appear or not, the user can check, all
this works nicely.
It is displayed and can be edited direclty in the DB by the NavBar.
I use an IBQuery and an IBUpdateQuery.

All works, besides "delete rows".

There is an error message "cannot find..." and then a field name,
which - is not inside the table.
If I check the SQL.Delete context, - yes there is this very field.
Points at a different table.

So my DAU-question:
Where and how can I refresh the SQL-delete-text, which I hoped, that
the Nav Bar "-"-Icon shall do for me?

----------------------------------------------------------------------
delphi2pk · 2023-02-21 07:02

I think you are joining multiple tables in IBQuery.

----------------------------------------------------------------------
Nicole · 2023-02-21 11:37

yes I do, is this wrong?