Normal Topic [Solved] Mystery applications in Sesame Server (Read 888 times)
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
[Solved] Mystery applications in Sesame Server
Oct 8th, 2007 at 6:26am
Print Post Print Post  
Solution: User has DATABASE RETENTION: ON set in his INI file.

While Sesame Server (2.0.3) was open, but working in standalone Designer, I was sometimes seeing applications showing on the Server.  I thought perhaps another user was in, but they were not, and the names were from "older" applications that I was not currently using.

I was going in as admin and removing them.  Shutting down the Sesame Server and restarting it again.  Some hours later, process was repeated.  My response was the same.

I finally "caught" one of the names being added to the application list.  It seems to be happening whenever I was importing an XML file.  I suspect the XML files may have had names from earlier "old" applications and that is where the names were coming from.

If this is normal, I find it confusing to see these names listed as active applications.
If this is not normal, then I guess you need to follow up on this.

Thanks again for listening.

PS-I did not have any problems importing XML files with 2.0.3 like I did earlier.  I will have to locate the older file with the MassUpdate programming and see if that works OK now.lved
« Last Edit: Oct 8th, 2007 at 5:25pm by Hammer »  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Mystery applications in Sesame Server
Reply #1 - Oct 8th, 2007 at 5:23pm
Print Post Print Post  
This can probably be marked as SOLVED.  Not a mystery any more.

In another posting Ray asked me if DATA RETENTION was On/Off.  I checked, found it was ON, and I realized why I was seeing these application names. 

Some startup icons were using my sesame.ini file, and some were not.  But this setting was causing applications to stay loaded for faster opening.  Not a problem to remove them when I know no one else was using them.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: [Solved] Mystery applications in Sesame Server
Reply #2 - Oct 8th, 2007 at 5:42pm
Print Post Print Post  
Giving this a little more thought may cause me to change some work habits. 

If I can remember to do it, I may add a Revision ID to the Application Name before I reconcile.  Then I will see different names in the Server Application List that will be more meaningful to me.  Rather than seeing the same name three times, I will see NameR1, NameR2, NameR3, etc. 

Not sure of the impact on programming yet, will probably not be a problem unless I am doing an exact match to Application Name.  But then I can just modify the program to use @Left(@Application,@Length(@Application)-2) if I am using the last two characters for Revision ID.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: [Solved] Mystery applications in Sesame Server
Reply #3 - Oct 8th, 2007 at 6:00pm
Print Post Print Post  
Hello Bob,

@SelectTreeItem() calls that reference the application menu will be affected if you add a revision number to the Application Title. What you can do is instead of hard coding the application title into the @SelectTreeItem() statements use @Application and concat it in.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: [Solved] Mystery applications in Sesame Server
Reply #4 - Oct 8th, 2007 at 7:25pm
Print Post Print Post  
Quote:
What you can do is instead of hard coding the application title into the @SelectTreeItem() statements use @Application and concat it in.

I have been using this method with great success. Here is a sample:
@SelectTreeItem(@Application + "!Forms!Add Data!Invoice!Invoice")
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: [Solved] Mystery applications in Sesame Server
Reply #5 - Oct 8th, 2007 at 11:12pm
Print Post Print Post  
Thanks to Ray and Carl.
I usually use @Application in Tree calls.  I don't see a problem there.  Internal programming should adapt automatically unless I do an exact compare to the Application Name string value (see below).

But I think perhaps I did not explain well.
My intent is to use AppNameR1, then AppNameR2, then AppNameR3 in Application Manager.

My formulas could still use @Application with no additional changes, no need to add suffix, etc.  Because thry should call the current AppNameRx which will be the same as the TreeTop.

My concern was if I did something like this, without the Revision:
If @Application() ="Appname"  Then {....  then I would need to keep changing the programing to add the "Rx".

But if I did this:
If @Left(@Application,@Length(@Application)-2) = "AppName" Then {....  I would not have to change the programing.

Hope that makes more sense.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: [Solved] Mystery applications in Sesame Server
Reply #6 - Oct 9th, 2007 at 2:15am
Print Post Print Post  
Bob_Hansen wrote on Oct 8th, 2007 at 11:12pm:
Hope that makes more sense.

Yes, it does.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: [Solved] Mystery applications in Sesame Server
Reply #7 - Oct 9th, 2007 at 1:08pm
Print Post Print Post  
Bob_Hansen wrote on Oct 8th, 2007 at 11:12pm:
But if I did this:
If @Left(@Application,@Length(@Application)-2) = "AppName" Then {....  I would not have to change the programing.


The only think I would do is make it minus 3 rather than minus 2 and just pad the revision number to two places. This way you allow for 99 revisions rather than 9 revisions. Also if you change your programming to be such then the application title will always need to have a revision number in it, or 3 extra chars at the end.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: [Solved] Mystery applications in Sesame Server
Reply #8 - Oct 9th, 2007 at 5:04pm
Print Post Print Post  
Thanks Ray.

You are correct, I would use more spaces.  I was just trying to provide an example of the technique.

Actually, I think the use of checking for the application name for decisions might only happen if I had some common code that needed to perform differently, maybe for different customers.  Bu having a different application name in the Sesame Server application list does make sense.

Thanks again for the explanations that tied all of these together for me.  It was a rough weekend.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged