pcsoft.us.windevCopyright 2026, PC SOFT5 Jan 2016 19:41:00 Z5 Jan 2016 11:58:00 ZHi, is anyone effectively using server triggers? I want to use a server trigger to keep track of changed records in a dozen tables. The trigger is saving the tablename + unique keyvalue in a separate tbl_journal I created. I'm using the code below in the trigger and defined it as an after-modify/add/delete trigger on several tables. However in 3 days and after about 5000 records I already noticed 2 failures. 1. the triggercode was gone in the hfsql database (something like "procedure xxxx not found when executing trigger") I had to add the code again using wdmodfic 2. an error saying "Internal error of WDVM DLL." After disabling the triggers the error was gone, but then I miss my trigger functionality of course (I could not restart the hfsql engine because of numerous active users in other database) So it seems to me the servertriggers are NOT reliable. Any comments? PROCEDURE AddToJournal() sTable is string sMode is string nRecordUID is int nRecordUID2 is int sField is string WHEN EXCEPTION IN sTable = H.FileName SWITCH Upper(sTable) CASE "TBL_ADRESSEN" sField = Tbl_Adressen.AdresID..Name nRecordUID = Tbl_Adressen.AdresID CASE "TBL_DP" sField = "TBL_DP" nRecordUID = "DPID" CASE "TBL_FIBERDATA" sField = Tbl_Fiberdata.FiberdataID..Name nRecordUID = Tbl_Fiberdata.FiberdataID CASE "TBL_OPDRACHTEN" sField = Tbl_Opdrachten.OpdrachtID..Name nRecordUID = Tbl_Opdrachten.OpdrachtID CASE "TBL_OPDRACHTENSTATUS" sField = Tbl_OpdrachtenStatus.OpdrachtenStatusID..Name nRecordUID = Tbl_OpdrachtenStatus.OpdrachtenStatusID CASE "TBL_OPDRACHTENPLANNING" sField = Tbl_OpdrachtenPlanning.PlanningID..Name nRecordUID = Tbl_OpdrachtenPlanning.PlanningID CASE "TBL_OPDRACHTENPLANNINGSTATUS" sField = Tbl_OpdrachtenPlanningStatus.OpdrachtenPlanningStatusID..Name nRecordUID = Tbl_OpdrachtenPlanningStatus.OpdrachtenPlanningStatusID CASE "TBL_PARAMETERS" sField = Tbl_Parameters.ParametersID..Name nRecordUID = Tbl_Parameters.ParametersID CASE "TBL_PROJECTEN" sField = Tbl_Projecten.ProjectenID..Name nRecordUID = Tbl_Projecten.ProjectenID CASE "TBL_PROJECTEN_X_ADRESSEN" sField = Tbl_Projecten_X_Adressen.IDTbl_Adressen_Tbl_Projecten..Name nRecordUID = Tbl_Projecten_X_Adressen.IDTbl_Adressen_Tbl_Projecten CASE "TBL_REDENEN" sField = Tbl_Redenen.RedenID..Name nRecordUID = Tbl_Redenen.RedenID CASE "TBL_WERKNEMERS" sField = Tbl_Werknemers.WerknemersID..Name nRecordUID = Tbl_Werknemers.WerknemersID CASE "TBL_WONINGCORPORATIES" sField = Tbl_WoningCorporaties.WoningCorporatieID..Name nRecordUID = Tbl_WoningCorporaties.WoningCorporatieID CASE "TBL_M_FIBERDATA" sField = Tbl_M_Fiberdata.FiberdataID_M..Name nRecordUID = Tbl_M_Fiberdata.FiberdataID_M END IF sField <> "" THEN HReset(Tbl_SyncJournal) Tbl_SyncJournal.KoppelTabel = sTable Tbl_SyncJournal.Actie = sMode Tbl_SyncJournal.KoppelID = nRecordUID Tbl_SyncJournal.KoppelID2 = nRecordUID2 Tbl_SyncJournal.Koppelveld = sField Tbl_SyncJournal.CreationDateTime = DateSys()+TimeSys() IF NOT WL.HAdd(Tbl_SyncJournal) THEN LogbookEvent(dbgInfo(dbgProcess),ErrorInfo(errCode),ErrorInfo(errMessage),1) END END DO s is string = DateToString(DateSys(),"DD-MM-YYYY") + " " + TimeToString(TimeSys(),"HH:MM:SS") s += CR + dbgInfo(dbgProcess) s += CR + ErrorInfo(errFullDetails) WriteErrorToAscii(s) // END30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55732-hfsql20-server-triggers/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55732-hfsql20-server-triggers-55737/read.awp5 Jan 2016 19:41:00 ZCurtis, serverside trigger do get triggered by sql statement, that's the main reason for me. Because I also have a website an…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55732-hfsql20-server-triggers-55737/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55732-hfsql20-server-triggers-55737/read.awpHFSQL20 server triggersguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55732-hfsql20-server-triggers-55736/read.awp5 Jan 2016 16:23:00 ZI only have experience with client side triggers, but sql queries won't set off the trigger. Not sure if it's the same for serve…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55732-hfsql20-server-triggers-55736/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55732-hfsql20-server-triggers-55736/read.awpHFSQL20 server triggers