[RBG7-L] - Re: Two data bases - One form menu

[Javier Valencia]

Emmitt: I like your solution; there is no reason why we could not have more that one database open at the same time…it is Windows after all…the more the merrier… Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================   -----Original Message----- From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of Emmitt Dove Sent: Friday, February 18, 2005 10:13 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Two data bases - One form menu   Another idea, Bob, is to have your first application LAUNCH rbg7 with a .dat file to execute.  If you include the |W option, the first instance will wait for the LAUNCHed application to terminate before resuming. Thanks Dawn and Larry for the quick replies.   In this particular case, the ODBC (Sattach etc.) route is not an option but a good idea none the less.  In many cases it should work great.   The idea of controlling the method by the start up file will work fine though.  Thanks Larry, I should have thought of that!  Easy to implement and will work fine.   Thanks again everyone.  The list probably saved me a lot of time trying to rehash a problem already elegantly solved. -Bob   -------------- Original message -------------- > > I have an application that is form menu driven. I now have a > > small app that must be located in a separate database. I want > > to put a menu option on my main form to switch to the new data > > base, run an application then return to the main menu. > > You EEP should set a variable to signal what you want to do, then issue > CLOSEWINDOW. Your main menu code should look like this: > > LABEL ShowMenu > EDIT USING MainMenu > IF (SignalCondition) THEN > RUN OtherApp -- Includes commands to connect new database > CONNECT OriginalDB > GOTO ShowMenu > ENDIF > > -- > Larry > Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. 40 Lindeman Drive Trumbull, CT  06611 (203) 673-2231 [EMAIL PROTECTED] [EMAIL PROTECTED]