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]
