IBX NavBar - Edit Some Tables - good styles?
lazarus / 16-Databases

----------------------------------------------------------------------
Nicole · 2022-11-08 18:24

For a handful of tables, I want to offer that they are editable within
a DBGrid or an TDynamicGrid.
There is a RadioGroupbox, where the user can choose WHICH table.

This is the easy part.
What shall I put behind it?

One Query for all or one query for each table?
One NavBar for all DBGrid-contents / queries?
Ond DBGrids for each of them?
This would mean, that I would have to write complex visible-hide-
routines for all of them.

How the queries look alike:
Most are just
select * from myTable
but there will be some with shall use a begin and end-date.

What I think, there may be troubles are messed-datas and open queries
and half filled grids.

How would you organize this best?

I would prefer to have one query and one grid.
Nevertheless, I am not sure, if this may lead to a mess, if the
navbar  comes at work. It would be a huge problem, if he changes some
values in the wrong table.

Thank you for all hints.
And keep in mind: IBX needs the update, insert and delete query to be
filled in, that the navbar works. What this means in case, the SQL-
text is changed, - I am not sure.