I have a rather slim DB_Modul, which holds database1, ... I just make you a screenshot.
There you see 6 components.
1)
The three at the left side are the base of all my work and work for a lot of of design-frames.
The three right ones, I am not sure (IBQuery_Allgemein and datasource_Allgemein):
Have I used them anywhere?
a)
How to find out best?
As I had troubles in the past in adding queries (you do not want to know details), I hesitate, just to delete them.
Sure, I can backup all before and hope, the problem will not turn out as such after 3 weeks of further work.
b)
The IBSQLMonitor: What does it do? Can I delete it or will then stop a working comfort function I am not aware of its benefits?
2)
The harder question:
I want to setup forms, which allow the user to edit tables. This query1 (not sure, if there is any use of it, as all my frames have their own queries) - this seems to shout "use me for this"!
If I use it, how to do best?
Shall I convert the db_modul into a form?
If yes, - how?
At the moment I tend to make an own unit / form for every table, which shall be edited. Never the less, there should be a base-form, which allows to select the table-to-edit. How to put it? In a new form? Put a class for this edit into my db_modul? Will this work at all?
The base of my ideas and plans is this demo project:
.....try to link it.... I cannot find this attachment any more... it was from our genius here, whose name are only 2 letters, which I always forget. What I do not forget, is how helpful it was. And therefore I saved it. Must have been about beginning of December 2022.
I just post the project again.
(download recommended for all, who want to edit db-tables by a Lazarus-form, generates a DB!)
Thank you for all answers, hints and ideas of your own practice.