Page Index Toggle Pages: 1 [2]  Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) using @modified effectively (Read 4737 times)
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: using @modified effectively
Reply #15 - Aug 25th, 2004 at 1:33pm
Print Post Print Post  
Too cool! Heres what the writeln window shows as soon as I enter "retrieve spec open".

Before Retrieve Spec Programming: no
After Retrieve Spec Programming: yes

Heres the programming that is in Retrieve Spec Open:
WriteLn("Before Retrieve Spec Programming: " + @Str(@Modified))
mark for deletion = 0
visibility(browse, 1)
visibility(thumb, 0)
visibility(quick search, 1)
WriteLn("After Retrieve Spec Programming: " + @Str(@Modified))

The line "mark for deletion" is a check box. I am setting it to the 'unchecked' state to narrow down all searched for products not 'discontinued'. It should not affect the data in the field.

Steve

ps. the other 2 events (on form entry and at the end of populating combo boxes gives a "No" response, so I assume those are ok)
  
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: using @modified effectively
Reply #16 - Aug 25th, 2004 at 1:39pm
Print Post Print Post  
If you place a writeln as the very first line of the on form entry event, does it show @modified as set? I am trying to determine if the @modified flag is not being reset when you hit F10 on the retrieve spec, before you run on form enter code.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: using @modified effectively
Reply #17 - Aug 25th, 2004 at 1:43pm
Print Post Print Post  
On form entry gives a "no" reponse.

Steve
  
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: using @modified effectively
Reply #18 - Aug 25th, 2004 at 1:50pm
Print Post Print Post  
Quote:
FYI - The @modified is triggering immediately, only in one of my forms. (the one with 3 combo boxes and a button to autopopulate them at retrieve spec open.)


In the form mentioned above, could you put in some writelns to narrow down when the @modified flag is being set?
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: using @modified effectively
Reply #19 - Aug 25th, 2004 at 2:05pm
Print Post Print Post  
If "yes" means the @modified is set, then it being set during:

On retrieve spec open - Mark for Deletion = 0
and
On form entry - If @update and checkbox1 <> 1 then checkbox1 = 0

The second line is to set all checkboxes to 0 if they are set to 'null'. However, these have been set to 0 or 1 for months. Again, no changes were made to the check boxes, but Sesame is still setting the @modified.

Looks like you can narrow down your bug hunt to just the check boxes(?)

Steve
  
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: using @modified effectively
Reply #20 - Aug 25th, 2004 at 3:16pm
Print Post Print Post  
Found and fixed.

It was erroneously setting the @modified flag if programming (not the user) set an LE to the same value already in the LE. So:

Company = Company

would erroneously set the flag. Sorry about that.

The fix wil be in the next release.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: using @modified effectively
Reply #21 - Aug 25th, 2004 at 3:25pm
Print Post Print Post  
Great.

Thanks for fixing it.

Steve
  
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: using @modified effectively
Reply #22 - Aug 25th, 2004 at 3:30pm
Print Post Print Post  
In the meantime, change your code to:

If @update and checkbox1 <> 1 and checkbox <> 0 then checkbox1 = 0

and you should be okay.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: using @modified effectively
Reply #23 - Aug 25th, 2004 at 3:33pm
Print Post Print Post  
OK. Thanks for the tip. Always helpfulf!

Steve

Edit. helpfulf! = helpfull! Smiley
  
Back to top
IP Logged
 
Page Index Toggle Pages: 1 [2] 
Send Topic Send Topic Print Print