(UTC)
  Lantica User Forum › Archived Topics › Archived Topics › Field Changed Indicator
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Field Changed Indicator (Read 450 times)
jerry.frazier
Member
*
Offline


No personal text

Posts: 16
Location: Fort Worth, Texas
Joined: Feb 12th, 2004
Field Changed Indicator
Feb 29th, 2004 at 7:24pm
Print Post Print Post  
I am trying to address a performance problem.  I have some code that only needs to run if the information in a specific field changes.  Is there any way to determine if the value of a specific field has changed since the record was loaded or created?  I do not want to run the code just because some other field changed on the form.

Thanks,

Jerry Frazier
  
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Field Changed Indicator
Reply #1 - Feb 29th, 2004 at 8:16pm
Print Post Print Post  
Quote:
I have some code that only needs to run if the information in a specific field changes.  Is there any way to determine if the value of a specific field has changed since the record was loaded or created?  I do not want to run the code just because some other field changed on the form.


I think this should be workable if you put the code in "On Element Change" event. If you are tracking a lot of such fields, you might want to have that in Global Code section and make indirect field reference.  Please let us know, if this works for you. Everyone is trying to learn here from each other, that is what I like the best about this forum. Moreover, it is not closed on weekends and holidays.  Grin
  
Back to top
 
IP Logged
 
jerry.frazier
Member
*
Offline


No personal text

Posts: 16
Location: Fort Worth, Texas
Joined: Feb 12th, 2004
Re: Field Changed Indicator
Reply #2 - Feb 29th, 2004 at 8:32pm
Print Post Print Post  
That works.  I have read the manuals from cover to cover.  I knew there had to be a way.  I was confusing On Element Change with On Element Exit.  I am working with converted code and there were some extensive XLOOKUPs the were being driven on every field change.  By putting the code under On Element Change, it is only driven when actually needed.  This improves the response for the entire form. 

Thanks a lot!

Jerry Frazier
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge