How can I configure BASE so that it does not save the data automatically, but asks for a confirmation for saving the modified records?
Hello,
This is not a setting in Base. If using the Firebird embedded database, no transactions are saved (committed) until the .odb is saved. This does not work the same for other databases (no explanation for different direction taken).
You can also write a macro to accept transactions one-by-one (ie: as entered) using Before... events. See → Events
Other than the above, see database documentation specific to the database you are using.
Responding to your not an answer:
I do not know what Firebird is but BASE does save all records even if the saving command is not used. So this program is risky.
Base is not a database. Base is a front end to a database. As stated in the answer, Firebird is an embedded database (HSQLDB is the other) which a user can select from when creating a Base file. Currently you need Experimental features turned on to select Firebird.
Don’t now what your basis is for stating ...BASE does save all records even if the saving command is not used. as records are only saved when you elect to save them. The process is fairly the same in many different applications.
As stated in the answer, you can write a macro to present a message for each transaction you process.
Another option may be for you to have a form which requires you to press a button before the record is saved.
I do not know what Firebird is but BASE does save all records even if the saving command is not used. So this program is risky.
Please only use an answer if you are answering the original question.