<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"><channel><category>pcsoft.us.windev</category><copyright>Copyright 2026, PC SOFT</copyright><lastBuildDate>30 Nov 2015 21:25:53 Z</lastBuildDate><pubDate>30 Nov 2015 21:25:53 Z</pubDate><description>Hi,&#13;
&#13;
I want to do the following:&#13;
&#13;
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.&#13;
&#13;
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.&#13;
&#13;
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.&#13;
Is this correct?&#13;
&#13;
How do i get the unique id of the client as a parameter to the procedure? &#13;
I need to find out which record was added or has been updated.&#13;
&#13;
The above triggers will be performed on the server machine only.&#13;
&#13;
Thanks in advance for your help/insights!&#13;
&#13;
Pedro</description><ttl>30</ttl><generator>WEBDEV</generator><language>en_US</language><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55208-database-update-add-trigger/read.awp</link><title>Database update / add trigger</title><managingEditor>moderateur@pcsoft.fr (El moderador)</managingEditor><webMaster>webmaster@pcsoft.fr (El webmaster)</webMaster></channel></rss>
