Database Methods

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 11.2 (Modified)


Database methods are methods that are automatically executed by 4D when a general session event occurs.

To create or open and edit a database method:

1. Open the Explorer window.

2. Select the Methods page.

3. Expand the Database Methods theme.

4. Double click on the method.

or:

1. Select the method.

2. Press Enter or Return.

You edit a database method in the same way as any other method.

You cannot call a database method from another method. Database methods are automatically invoked by 4D at certain points in a working session. The following table summarizes execution of database methods:

Database Method4D local4D Server4D remote
On StartupYes, OnceNoYes, Once
On ExitYes, OnceNoYes, Once
On DropYes, MultipleNoYes, Multiple
On Web ConnectionYes, MultipleYes, MultipleYes, Multiple
On Web AuthenticationYes, MultipleYes, MultipleYes, Multiple
On Backup StartupYes, MultipleYes, MultipleYes, Multiple
On Backup ShutdownYes, MultipleYes, MultipleYes, Multiple
On Server StartupNoYes, OnceNo
On Server ShutdownNoYes, OnceNo
On Server Open ConnectionNoYes, MultipleNo
On Server Close ConnectionNoYes, MultipleNo
On SQL AuthenticationYes, MultipleYes, MultipleYes, Multiple

For detailed information about each of the database methods, see the following sections:

On Startup Database Method

On Exit Database Method

On Drop Database Method

On Web Connection Database Method

On Web Authentication Database Method

On Backup Startup Database Method

On Backup Shutdown Database Method

On SQL Authentication Database Method

On Server Startup Database Method (4D Server Reference manual)

On Server Shutdown Database Method (4D Server Reference manual)

On Server Open Connection Database Method (4D Server Reference manual)

On Server Close Connection Database Method (4D Server Reference manual)


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next