Thank You, Emitt and Gunnar, I was not thinking about the command as an EEP but it is. The MAIN MENU form is always open. Is it possible to close that main menu while running an EEP that it called? I tried EXITFORM (which I think is a DOS command only). I also tried the Windows equivalent, CLOSEWINDOW but that command was also rejected for EEPs.
I will have to work more on attaching foreign data sources and I will look at the notes on DYNAMICALLY DSN . I will ask more when I have had time to work through what you have suggested. Thanks again, Sharon ----- Original Message ----- From: "Gunnar Ekblad" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, August 20, 2004 1:26 PM Subject: [RBG7-L] - Re: Multiple Databases in One Directory Sharon & Emitt To Expand further on Emmits reply to Gunnars Reply to Sharon's question. One of the very best features is the DYNAMICALLY DSN (see help and From the Edge!) Gunnar Ekblad Kontema IT AB H�stholmsv�gen 32 S-131 30 NACKA 070 545 50 38 [EMAIL PROTECTED] -----Ursprungligt meddelande----- Fr�n: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] F�r Emmitt Dove Skickat: den 20 augusti 2004 18:55 Till: RBG7-L Mailing List �mne: [RBG7-L] - Re: Multiple Databases in One Directory To expand on Gunnar's reply, and assuming that you are in an EEP, you will have to use SCONNECT/SATTACH to accomplish what you wish. Before you can use these commands you must establish a system DSN for the datasource. Once the datasource is established, try working through the menus once (Utilities/Connect SQL Datasource) to show yourself that you can establish such a connection. Then, for instance, if you set up a system DSN for concomp you could: SCONNECT concomp IDENTIFIED BY NONE SATTACH contact USING custid Then the contact table would be available from within your database. Note that if you have STATICDB on, the SATTACH will be temporary. >Hi All, > >I am back to work after a long trip around the >country and needing help already. > >It old version I was able to use CONN <otherdb> >from within my program. Now in 7.1, I am getting >the following error message: >Illegal command in Entry/Exit Procedure. > >Two databases reside in the same directory. >The main database is almost always in use. >However sometimes the user needs to look into >the secondary database for archived data. > >I think using SATTACH or SCONNECT would be better >than disconnecting from the main database in some cases, >but I am not getting these commands to work. >However, there are cases where I need to be connected to >the secondary database only, such as to load in a new form. > >How do I now get into that secondary database from within >my codelocked application? > >Thanks for help. > >Sharon Lima Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. 40 Lindeman Drive Trumbull, CT 06611 (203) 673-2231 [EMAIL PROTECTED] [EMAIL PROTECTED]
