Hello Bill: The situation I ran into is that I have built my applications around a single database "name" for all of my databases. This has worked great over the years.
Recently I have been moving to terminal services and creating a backup of large file which involves opening up the original dbc and the target dbc. What you suggest will work and what Ricardo suggests will work, but I am not going to rewrite my applications to implement a backup routine. The bug-a-boo is that dbc's don't have aliases like tables. You can only really have one database open with one name. We know we can put views in their own dbc. They will also look for one name or "alias" as I call it, but you can only have one. It makes perfect sense to me now, but it would be nice if the dbc could have an alias like a table. Maybe it will in the next version! ;^) Jeff Jeff Johnson [EMAIL PROTECTED] 623-582-0323 Fax 623-869-0675 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of Bill Anderson > Sent: Friday, May 18, 2007 7:32 PM > To: [EMAIL PROTECTED] > Subject: Re: Multiple Databases Same Name > > Jeff Johnson wrote: > > > > That will work for my project but I need to make sure I close the dbc. > I > > discovered that, while tables can have aliases, the dbc can not. If you > > have a dbc opened you can put any path in front of it you want. It will > > always use the last one opened. You can't do SET DATABASE TO > > c:\path\dbc.dbc. You also can't open it again without closing it. It > will > > only set it to one name. So in a sense the dbc name is the alias. > > > > The lesson I have learned from this is that you can only have one > database > > open with the same name at the same time or you will get unpredictable > > results. I have been having a problem with this type of application on > > terminal services when users switch sites. This helped me identify the > > problem I have been having. > > > (Coming in late...) Can you have a unique view name in each DBC (it > doesn't need to be used, just have a unique name), use ADATABASES() to > cycle through the open databases, testing for the existence of said view? > > Bill > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
