|
| Database update / add trigger |
| Iniciado por peter.serneels, 30,nov. 2015 21:25 - No hay respuesta |
| |
| | | |
|
| |
| Publicado el 30,noviembre 2015 - 21:25 |
Hi,
I want to do the following:
When (from any computer in the network) a user adds a client to the database (customers file), the HFSQL server should generate an xml document with the data of the customer. This xml document will be picked up by a third party application.
When (from any computer in the network) a user updates the details of a client in the database (customers file), the HFSQL server should generate an xml document with the new data of the customer. This xml document will be picked up by a third party application.
I presume i need to create a local procedure in the analisys and create a trigger that calls the procedure when an add or update command is performed in the customers file.
Is this correct?
How do i get the unique id of the client as a parameter to the procedure?
I need to find out which record was added or has been updated.
The above triggers will be performed on the server machine only.
Thanks in advance for your help/insights!
Pedro |
| |
| |
| | | |
|
| | | | |
| | |
|