slxdeveloper.com Community Forums

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!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Active Form Modified property

Lawrence Reid
Posts: 63

Active Form Modified property Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Sep 07 3:13 PM

The lan dev reference lists the Modified. It states Boolean. Read-only. Accessing this property causes the form to loop through all of its bound controls and compare the current values of the bound properties with the corresponding values that were retrieved from the database when the controls were populated with data. If a mismatch is found, Modified returns True.

We have some forms with several controls. Is there a control property that holds the original data value or do they re-query the DB? Basically, how do they do this? I would also like to know if there is a way to know which field changed and what its original value was.

[Reply][Quote]

Vladimir
Posts: 93

Re: Active Form Modified property Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Sep 07 2:09 AM

1. You can store values of fields in the temporary variables when your form is open (OnChange,OnOpen) and then compare values.
2. You can write a trigger on update/insert for table. It is more effective when many forms "look at" one table.

[Reply][Quote]

Lawrence Reid
Posts: 63

Re: Active Form Modified property Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Sep 07 8:53 AM

Thanks for the suggestions. I currently testing the Modified flag in the OnValidate event after all validation has passed. I am querying the DB for current values and testing each field. This is a pain because I have to remember to add all new fields to the script. I am just looking for the easy or lazy, automated, way to determine what fields changed.

[Reply][Quote]

Vladimir
Posts: 93

Re: Active Form Modified property Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Sep 07 9:11 AM

If you use standard entities such as account, contact, opportunity you can set property RecordChanges = T for the fields, and if values will modify then record will inserted in table history with description "database change"

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 6/20/2025 10:36:27 AM