I have an application which has hundreds of functions with SQL statements as in the image attached. I would like to add offline mode functionality to it.
For this project, all what I need is a sample Delphi code to insert SQL statement and its parameters into a table. This code will be used to update the same table in another db file. I will need this code as well.
So basically, the sample should have two buttons, one to read the sql code and add it to the table. And the other one will read the sql statement and update the same table in another db file.
Since there are hundreds of functions as in the attached image which require this functionality, the code to be added to those functions should be very simple and not be more than 2-3 lines.
The sample code should use: