Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
New Member
Posts: 1
Registered: ‎04-30-2010

Riskk of using Triggers?

I’m new to SLX development (LAN Client v7.2.2) and am currently supporting a heavily customized installation that includes synchronized remote databases.  I would like to understand any risks that may occur when using triggers to calculate and update custom table fields within the SLX sysdba schema.  In particular I’m concerned this could somehow lead to a situation where the remote dbs need to be re-cut.  But, like I mentioned, the risks (if any) are not clear to me.

 

The new fields are not needed by remote users and are not displayed via the client.  Their primary intent is for reporting purposes (by concurrent users - using Visual Analyzer I think).  I’m creating the fields via the SLX DB admin tool so I know the field will sync to the remotes, but since the data is set from the trigger I don’t expect the values to sync out.

 

Thanks!

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Riskk of using Triggers?

There certainly are risks. As you are aware:

  A -  any data changed IN SalesLogix via a trigger will not sync.. period.. since triggers do not (and cannot) communicate w/the "provider"

 

  B - Trigger creation does not "sync" to a remote (user or office)

 

  C - There's a major danger of "loosing" a trigger if you Add or Drop a field in a SalesLogix table via the SalesLogix DB manager - see:

          http://community.sagesaleslogix.com/t5/IdeaLogix/Change-the-way-SalesLogix-Adds-Drops-fields-via-the... 

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Silver Contributor
Posts: 835
Registered: ‎03-24-2009

Re: Riskk of using Triggers?

Additionally, there is an issue with using triggers: the conflict resolution process of synchronization is based on date times of sync/TEF files and when different user's change an Account Name or what have.....triggers may upset this delicate dance of who's data change wins.

 

Our system doesn' t use Sync, and has many triggers on it....mostly for resumming aggregates or MAX value fields used in Business Intelligence reporting....so no affect here...

 

But

 

Your mileage will vary....

RJ Samp