pcsoft.us.windevCopyright 2026, PC SOFT17 Mar 2016 17:03:00 Z10 Mar 2016 14:38:00 ZI need to run a procedure in every client whenever a new record is inserted in the database (the record is not inserted by the client). I know for HFSQL C/S you can use 'Server triggers'. But not for MSSQL. Now I run a query every minute to see if there is a change but I need to have 'no latency' and running this procedure from every client every second will increase the load too much (WAN access). What would be the best practice to do this? Cheers, Adri30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56877/read.awp17 Mar 2016 17:03:00 Zif everything is on the same machine (service, webdev server and windev clients) you can use Shared memory zones for the notific…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56877/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56877/read.awp[WD20] Kick client application based on database update (MSSQL)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56875/read.awp17 Mar 2016 15:21:00 ZHi Adri, I checked and you are right... well, the funny thing is that it the help says clearly that it IS supported, but the …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56875/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56875/read.awp[WD20] Kick client application based on database update (MSSQL)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56874/read.awp17 Mar 2016 15:12:00 ZHi Paulo, The records are inserted via another application. It is a WinDev Application Server that receives events via a sock…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56874/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56874/read.awp[WD20] Kick client application based on database update (MSSQL)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56873/read.awp17 Mar 2016 14:54:00 ZAdri, The records are inserted by your app or by some external one that you can't control? When you say "the record is not i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56873/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56873/read.awp[WD20] Kick client application based on database update (MSSQL)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56872/read.awp17 Mar 2016 14:49:00 ZHi Fabrice, As far as I know HVersion doesn't support OLEDB nor Native Access. We use MSSQL so it looks like HVersion won't h…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56872/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56872/read.awp[WD20] Kick client application based on database update (MSSQL)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56871/read.awp17 Mar 2016 14:30:00 ZHello Adri, why not simply use hversion? Best regardshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56871/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56871/read.awp[WD20] Kick client application based on database update (MSSQL)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56868/read.awp17 Mar 2016 13:51:00 ZThanks all for your responses. Will do some testing and post the results here. Cheers, Adrihttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56868/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56868/read.awp[WD20] Kick client application based on database update (MSSQL)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56863/read.awp16 Mar 2016 19:35:00 ZHello Adri As the source of the change is your Windev application, you could overload the HAdd command with your own and pick…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56863/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56863/read.awp[WD20] Kick client application based on database update (MSSQL)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56859/read.awp16 Mar 2016 13:54:00 ZThe best option is to solve this at the mssql level. One option is to use xp_cmdshell in one mssql trigger to run your program.…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56859/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56859/read.awp[WD20] Kick client application based on database update (MSSQL)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56858/read.awp16 Mar 2016 13:31:00 ZTry using sockets. When your clients start the app, have them register in a table. When they add/edit a record send a notifi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56858/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56858/read.awp[WD20] Kick client application based on database update (MSSQL)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56794/read.awp10 Mar 2016 17:33:00 ZIt looks like 'event notifications' is only for database-level actions (create table, add column, add index etc, but not for ins…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56794/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56794/read.awp[WD20] Kick client application based on database update (MSSQL)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56791/read.awp10 Mar 2016 16:22:00 Ztry event notifications https://msdn.microsoft.com/en-us/library/ms190427(v=sql.105).aspxhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56791/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56790-wd20-kick-client-application-based-database-update-mssql-56791/read.awp[WD20] Kick client application based on database update (MSSQL)