Lantica User Forum - displaying all records on Open Sesame

(UTC)

Lantica User Forum › Archived Topics › Archived Topics › displaying all records on Open Sesame

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: [1] 2

Send Topic

Print

Hot Topic (More than 10 Replies)

displaying all records on Open Sesame (Read 2064 times)

FSGROUP Full Member Offline No personal text Posts: 179 Location: Edmonton, Alberta, Canada Joined: Jan 14^th, 2004	displaying all records on Open Sesame Mar 12^th, 2004 at 11:18pm	Print Post
	I would like to have all the records in the database displayed when I open an application, as opposed to going to Search/update and performing an F10. Is this possible? I thought about macros, but they only run in a form, so that's a no go. Any advice? Thanx.


	WWW IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: displaying all records on Open Sesame Reply #1 - Mar 12^th, 2004 at 11:26pm	Print Post
	Quote: I thought about macros, but they only run in a form Macros can be recorded and run from any point. It is event programming that can only be run from a form. A macro can also be launched when Sesame itself is launched using the "-macro" flag.

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

FSGROUP Full Member Offline No personal text Posts: 179 Location: Edmonton, Alberta, Canada Joined: Jan 14^th, 2004	Re: displaying all records on Open Sesame Reply #2 - Mar 12^th, 2004 at 11:54pm	Print Post
	Thanx for the reply. If I wanted all the client machines to open a particular application when the desktop item was clicked, do I change the Target properties on the Server? Or on each client? I'm a little confused as the target properties for each client is "C:\Sesame\Program\sesame.exe -client Fsgserver" and the application is located on the server as "D:\Apps\Sesame\CMS.db". What should the target properties look like if I want to achieve the above? Thanx a bunch.


	WWW IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: displaying all records on Open Sesame Reply #3 - Mar 13^th, 2004 at 12:12am	Print Post
	The macro is relative to the the CWD of the server. So you would specify the server normally: sesame -server machine_name Then each client: sesame -macro open_all.mac -client machine_name App.db If you need to specify the paths to the macro file and the App file, they would both be the paths as the server knows them.

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

FSGROUP Full Member Offline No personal text Posts: 179 Location: Edmonton, Alberta, Canada Joined: Jan 14^th, 2004	Re: displaying all records on Open Sesame Reply #4 - Mar 15^th, 2004 at 4:28pm	Print Post
	I have the following: sesame -macro data\macros\open_all.mac -client Server data\App.db that command seems to open the application, but it doesn't run the macro. however, i do see "open_all.mac" in the Macro box at the top near the navigation record. Do i need to specify the full macro path? I didn't do this for the app., so i'm just wondering.. Also, does it just load the macro, or should it be running it too? Thanx


	WWW IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: displaying all records on Open Sesame Reply #5 - Mar 15^th, 2004 at 5:00pm	Print Post
	Are the paths relative to the client's or the server's CWD? In either case, try using the full server path to the files.

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

FSGROUP Full Member Offline No personal text Posts: 179 Location: Edmonton, Alberta, Canada Joined: Jan 14^th, 2004	Re: displaying all records on Open Sesame Reply #6 - Mar 15^th, 2004 at 5:32pm	Print Post
	the paths are relative to the server's CWD. I used absolute paths with no luck. The app opens, the macro loaded, but the macro is not executed. clues?


	WWW IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: displaying all records on Open Sesame Reply #7 - Mar 15^th, 2004 at 6:15pm	Print Post
	What are you asking it to do, and by what means? Does it work if you just load it right after startup using the menu? Are you playing it back in the same context in which it was recorded?

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

FSGROUP Full Member Offline No personal text Posts: 179 Location: Edmonton, Alberta, Canada Joined: Jan 14^th, 2004	Re: displaying all records on Open Sesame Reply #8 - Mar 15^th, 2004 at 6:33pm	Print Post
	i want to click on the Sesame destop icon and have my application open and have all the records in the DB displayed. So in the macro, I have click on Search/Update (in the command tree) and execute an F10. The playback works, the only problem being the -macro flag does not execute the macro. It just loads it.


	WWW IP Logged

FSGROUP Full Member Offline No personal text Posts: 179 Location: Edmonton, Alberta, Canada Joined: Jan 14^th, 2004	macro flag on Sesame target Reply #9 - Mar 18^th, 2004 at 7:04pm	Print Post
	does that load and run the macro or just simply load it? thanx


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: displaying all records on Open Sesame Reply #10 - Mar 18^th, 2004 at 7:23pm	Print Post
	-macro loads and runs the macro.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

FSGROUP Full Member Offline No personal text Posts: 179 Location: Edmonton, Alberta, Canada Joined: Jan 14^th, 2004	Re: displaying all records on Open Sesame Reply #11 - Mar 18^th, 2004 at 10:34pm	Print Post
	i just discovered that having application security removes the ability to run a macro upon opening the app. from Sesame target properties. Is there a way around this? Thanx


	WWW IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: displaying all records on Open Sesame Reply #12 - Mar 18^th, 2004 at 10:39pm	Print Post
	Having a login does not remove that ability. But the macro must take that security into account. In other words, the macro must login. This can be a little difficult to record. The trick is to, while recording, open the database - thus forcing the password dialog to appear. That will allow you to record logging in as part of the macro. You will, of course, need to record a separate macro for each .db file you intend to open with security.

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

Bharat_Naik Senior Member Members Offline Ever ready to learn and share Posts: 1202 Location: Chicago, Illinois Joined: Dec 16^th, 2003	Re: displaying all records on Open Sesame Reply #13 - Mar 18^th, 2004 at 10:49pm	Print Post
	Mark, In Q&A, on opening the module, we can using F6 to bring on the UserID and Password dialog box and after entering them once, you do not have to worry about entering the password or username thereafter. I think that was very convenient and if something like that could be implemented in Sesame, it will cut through re-entering the password again for different applications. Just a thought.


	IP Logged

FSGROUP Full Member Offline No personal text Posts: 179 Location: Edmonton, Alberta, Canada Joined: Jan 14^th, 2004	Re: displaying all records on Open Sesame Reply #14 - Mar 19^th, 2004 at 4:05pm	Print Post
	So if I have to record the login as part of the macro, that means a different macro has to be created for each user who opens the same .db file?


	WWW IP Logged

Page Index Toggle

Pages: [1] 2

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

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

Valid XHTML

Valid CSS

Powered by Perl

Source Forge