Ask Your Question
0

BASE: how to have BASE ask before saving record?

asked 2020-07-17 14:05:53 +0200

Marty3 gravatar image

updated 2020-07-18 04:02:45 +0200

How can I configure BASE so that it does not save the data automatically, but asks for a confirmation for saving the modified records?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2020-07-23 03:11:42 +0200

Ratslinger gravatar image

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.

edit flag offensive delete link more

Comments

@Marty3,

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 ...(more)

Ratslinger gravatar imageRatslinger ( 2020-07-25 03:01:59 +0200 )edit
0

answered 2020-07-25 02:46:54 +0200

Marty3 gravatar image

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.

edit flag offensive delete link more

Comments

Please only use an answer if you are answering the original question.

Ratslinger gravatar imageRatslinger ( 2020-07-25 02:53:54 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-07-17 14:05:53 +0200

Seen: 62 times

Last updated: Jul 25