Hot Topic (More than 10 Replies) command button to another application (Read 1812 times)
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
command button to another application
Apr 30th, 2013 at 5:26pm
Print Post Print Post  
I am trying to put a command button in one application that will open another application. I used the deferredOpen command and it worked.........but only if no one else is in the new application.  Then it gives me an error msg that application is in use.  Is there another way to do this?  What would also be nice if I could specify which form to open in the other application.
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: command button to another application
Reply #1 - Apr 30th, 2013 at 6:40pm
Print Post Print Post  
If you want two copies of Sesame to be able to view the same application files at the same time, you will need to be client/server with a minimum of two client licenses.

The other application can use SBasic programming to open any of its forms. Using file I/O may allow the "calling application" to tell the second application which form to open.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: command button to another application
Reply #2 - May 1st, 2013 at 2:10pm
Print Post Print Post  
Hello Deb,

Make sure you are using the same file path in the call for DeferredOpenApplication() that appears at the top of the Sesame window when you open the DB file using File->Open Application. You can get the locked message if a Sesame client opens the file as C:\Sesame2\Data\MyFile.db and the DeferredOpenApplication() is trying to open the file as Q:\MyFile.db

-Ray
  

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



Posts: 123
Joined: Oct 5th, 2011
Re: command button to another application
Reply #3 - May 2nd, 2013 at 5:42pm
Print Post Print Post  
Hi Ray,

This is the command I used:

deferredOpenApplication("s:\pacific coast fruit products.db")

Now it is giving me msg  that data base failed to open.
  
Back to top
 
IP Logged
 
Ben
Lantica Support
*****
Offline



Posts: 218
Joined: Apr 7th, 2005
Re: command button to another application
Reply #4 - May 2nd, 2013 at 8:27pm
Print Post Print Post  
Hello Deb,

What is the full message you receive? Is it telling you that the file is locked, or that the file is read-only?
  
Back to top
IP Logged
 
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
Re: command button to another application
Reply #5 - May 2nd, 2013 at 10:45pm
Print Post Print Post  
tells me that database s:\pacific coast fruit products.db failed to open.
  
Back to top
 
IP Logged
 
Ben
Lantica Support
*****
Offline



Posts: 218
Joined: Apr 7th, 2005
Re: command button to another application
Reply #6 - May 3rd, 2013 at 1:31pm
Print Post Print Post  
Okay, in the Sesame window that is already open perform these steps:
- Select File>Open Application
- Select the Pacific Coast Fruit Products database
- If it opens, take note of the file path shown at the top of the Sesame window

What is the file path?
  
Back to top
IP Logged
 
Ben
Lantica Support
*****
Offline



Posts: 218
Joined: Apr 7th, 2005
Re: command button to another application
Reply #7 - May 3rd, 2013 at 1:38pm
Print Post Print Post  
You may also encounter the situation you are in if you are working in a standalone instance of Sesame Designer (not connected as a client to Sesame Server) and try to test the button in Preview Mode. Are you in Sesame or Sesame Designer?
  
Back to top
IP Logged
 
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
Re: command button to another application
Reply #8 - May 3rd, 2013 at 3:04pm
Print Post Print Post  
Thanks Ben.....It does work from the program itself.  Very very very slow.  But it works.
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: command button to another application
Reply #9 - May 3rd, 2013 at 5:10pm
Print Post Print Post  
Unless it is also very very very big, it should not be slow.

Can you provide a precise explanation of your setup?

Client/Server?

Standalone?

How large are both application files, dsr/db dat/ddt?

How much memory does your system(s) have?

Is your network having troubles when you run client/server?

If you are running client/server, you should be able to pre-load the application, meaning that switching between the two should be very quick. It will also prevent file locking issues when loading an application someone else has open.
  

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



Posts: 123
Joined: Oct 5th, 2011
Re: command button to another application
Reply #10 - May 14th, 2013 at 4:05pm
Print Post Print Post  
One thing I have since realized.  It is only MY computer that is very very slow. It never used to be that slow. Everyone else on the network is fine.     Something has happened?
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: command button to another application
Reply #11 - May 14th, 2013 at 8:22pm
Print Post Print Post  
[Ray, pull the debmckee flag out! She's on to us! Wink]

Deb,

I assume your computer wasn't always the slowest...

Does your computer have less memory?

Are you running out of disk space?

If client/server, is your network card, wire, or router port failing?

Do you have significantly different entries in your sesame.ini file?

Is your computer overheating?

Is your computer being tasked to perform other operations at the same time?
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged