4D v14

Stored procedures on client machines

Home

 
4D v14
Stored procedures on client machines

Stored procedures on client machines  


 

 

Stored procedures can be executed on one or several 4D client machines. Stored procedures on client machines are executed the same as way as stored procedures on the server, except that on the client they can invoke data entry. Refer to the Stored Procedures section for further information.

Any client machine executing stored procedures triggered by a server or another client machine, should explicitly be registered for this session. There are two methods to register a client: it can automatically be registered when connecting or through programming.

The "Register Clients at Startup For Execute On Client" check box is available in the Database Settings, on the “Network options” tab of the “Client-Server” page:

When this option is checked, each 4D client machine connecting to the database is automatically referenced with 4D Server as being able to execute stored procedures. A 4D Client type process named according to the client machine is created on the server. An equivalent process is also created on each client machine.

It is possible to register one or several client machines using programming. It allows you to select the client machines that needs to be registered and to define their registration name.
The "Process" theme contains the REGISTER CLIENT command which allows you to register a client machine under any name.

No matter how the client machines have been registered, you can unregister them for the current session using the UNREGISTER CLIENT command ("Process" theme) for a given client. The registration process (named according to the client) disappears from the user process group on the server machine as well as on the client.

Note: You can get the list and the task distribution (number of methods still to be executed) for the clients registered for a given session using the GET REGISTERED CLIENTS command.

For further information on these commands, refer to the 4D Language Reference manual.

 
PROPERTIES 

Product: 4D
Theme: 4D Server and the 4D Language

 
ARTICLE USAGE

4D Server Reference ( 4D v13)
4D Server Reference ( 4D Server v12)
4D Server Reference ( 4D v14 R2)
4D Server Reference ( 4D v14)
4D Server Reference ( 4D v14 R3)
4D Server Reference ( 4D Server v14 R4)

Parent of : Stored procedures on client machines ( 4D Server v11 SQL Release 6)