The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
How to create triggers in SalesLogix?
Posted: 03 Aug 07 12:02 AM
|
I checked the SLXTRIGGERS table and found that SLX has created triggers through dll and calling them.
--> SELECT * FROM SLXTRIGGERS
How to create our own triggers? Is there any option for this?
Thanks in advance,
Rekha |
|
|
|
Re: How to create triggers in SalesLogix?
Posted: 04 Aug 07 9:09 AM
|
SlxTriggers is a closed area inSalesLogix that is reserved for Sage SalesLogix development Only. There is NO documentation (white papers, note,etc) on SlxTriggers and AFAIK there will never be.
Partners do not have access to this either and I was told we would not ever be given access.
--
rjl |
|
|
|
Re: How to create triggers in SalesLogix?
Posted: 14 Sep 07 12:53 PM
|
How evil is it to create my own SQL triggers directly on a table? I've done this on my development system for the CONTACT & ACCOUNT tables to notify a user when an account or contact has been re-assigned to them (via the account manager field).
It seems to be working quite well in the development area, any possible complications or concerns with moving this into production? |
|
|
|
Re: How to create triggers in SalesLogix?
Posted: 14 Sep 07 1:06 PM
|
| Do you have remotes? If you update any data in the trigger then it won't sync. Also the trigger could cause problems with cutting remotes. If all you're doing is sending some notifications then there's little harm. |
|
|
|
Re: How to create triggers in SalesLogix?
Posted: 14 Sep 07 1:09 PM
|
No there are no data updates being made in the trigger, it just sends out an email with the contact/account name, old & current account manager names and a link back to the record.
Just curious, why would updating data through the trigger cause sync issues with the remotes? I'm assuming that SLX monitors changes and queues up data to send to the remotes so directly changing it in SQL will cause the change to be missed? |
|
|
|
Re: How to create triggers in SalesLogix?
Posted: 14 Sep 07 1:12 PM
|
| No, SLX does not monitor changes to the database itself. It will only sync out to remotes what passes through the SLX OLEDB Provider. When you update a table directly in SQL, the SLX Provider knows nothing of it, so it will not sync that data out. Make sense? |
|
|
|
Re: How to create triggers in SalesLogix?
Posted: 14 Sep 07 1:15 PM
|
| SLX SyncLogging will only happen if the SQL is issued through the SLXProvider. Since the trigger code lives in the database and works directly againist the database any changes the trigger code makes do not go through the SLX Provider. Which means the SLX Sync File will not be written, which means the changes will not be sent to remotes. |
|
|
| |
|