Myron I think you are actually FINE - there IS NO PROBLEM: "The result is the same, after saving the app (step 9) and clicking on the databases tab in the object manager, I am now connected to the old db, not the new one."
"The interesting part of all this is that when I run the application it works with the new database not the old one." I THINK this means that: 1. You did the modification of the application, so you had to be connected to the database before you started in order to be allowed to begin. 2. You saved the changes 3. You returned to the R. prompt expecting to be CONNECTED now to the new database. Which would NOT be true - you changed the APPLICATION: ie you changed the line in the code which says CONNECT so that when you run it, it connects the NEW database, but you did not connect the new db at any time during the process! SO I think you are OK - if when yhou RUN the new app it uses the new database, you're fine! David Blocker ----- Original Message ----- From: "Myron Finegold" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, October 27, 2002 6:25 PM Subject: RE: Renaming a Database and Application > Claudine, > Tried the copy process again - as per below. > The result is the same, after saving the app (step 9) and clicking on > the databases tab in the object manager, I am now connected to the old > db, not the new one. > > The interesting part of all this is that when I run the application it > works with the new database not the old one. > > Myron Finegold > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] > On Behalf Of Claudine Robbins > Sent: Sunday, October 27, 2002 4:37 PM > To: [EMAIL PROTECTED] > Subject: RE: Renaming a Database and Application > > There are 3 files for every application. If you move the app, I believe > you should you move all 3 (.app; .apx; .apw). This from Rbase Help: > > ===== > To copy/rename an application: > > 1 If the Object Manager is not open, choose Tools: Object Manager... > 2 Click the Apps tab. > 3 Select an application. > 4 Click the Copy button. > 5 Enter the name for the copied application. > 6 Click the OK button. > After copying an application, you must open and save it in the > Application Designer to have the .APW file reflect the new application > name. > > 7 In the Object Manager, select the copy of the application. > 8 Click the Design button. > 9 Choose File: Save. > 10 Double-click the control-menu box, which is located in the upper-left > corner of the Application Designer to close the application. > ===== > > Also, if you edit the .app file outside of application express, you > won't be able to keep your changes (Rbase will recreate the .apx from > the .apw and bypass your changes). I have had to manually recreate apps > this way before by printing the .app file and then following the logic > to recreate the app in application express. Not much help I'm afraid... > > ~Claudine :) > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] > On Behalf Of Myron Finegold > Sent: Sunday, October 27, 2002 12:58 PM > To: [EMAIL PROTECTED] > Subject: RE: Renaming a Database and Application > > Alastair, > Thanks for even engaging the brain on a Sunday. > I did as you suggested. The app file has only one connect statement and > it is; connect dbname. (I do use the application express.) > > I'll try playing with the db later... > Will keep everyone posted. > > Myron Finegold > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] > On Behalf Of Alastair Burr > Sent: Sunday, October 27, 2002 9:19 AM > To: [EMAIL PROTECTED] > Subject: Re: Renaming a Database and Application > > Myron, > > It sounds to me like your app has the path as well as the db name > somewhere > in it. > > Try this: > > Open the .app file with an editor, WordPad or NotePad will do, and > search > for the CONNect command. > > You should find it once (at least). > > If - in every case - it contains only the db name, ie: "CONNect dbName" > then > this is not your problem. > However, if it contains, for example, "CONNect \dbfiles\dbName" then > wherever you copy your db to is going to have no effect. > > If this is the problem then let the list know and someone will be able > to > tell you how to sort it out. It is easy enough to edit the .app file but > you > would then lose the ability to use Application Express which I gather > you > want to use. (It's Sunday afternoon and my thinking cap is hung up for > the > weekend!!) > > Close WordPad or NotePad or whatever you use _without_ saving the file! > > Regards, > Alastair. > > > ----- Original Message ----- > From: "Myron Finegold" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, October 27, 2002 1:34 PM > Subject: RE: Renaming a Database and Application > > > > David, > > I did setup a new folder, then used the reload command to move the db > > into the folder created, then I moved the app in the new folder - by > > itself - the app runs, but you can't 'design' it. Then I moved the old > > db into the folder and 'design' works fine because it is connecting to > > the old db. The question is this, why does 'design' think I'm still > > using the old db? I'm still plugging away. If I get an answer, I'll > let > > everyone know. > > > > Myron Finegold > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] > > On Behalf Of David M. Blocker > > Sent: Saturday, October 26, 2002 6:57 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Renaming a Database and Application > > > > Myron > > > > Is the application file in the same directory as the database? I'd try > > move > > the new database and a COPY of the old database and application to a > new > > directory. Then open the application, change teh database name and > save. > > Then delete the old database copy - does that work? > > > > David Blocker > > > > ----- Original Message ----- > > From: "Myron Finegold" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Saturday, October 26, 2002 2:46 PM > > Subject: RE: Renaming a Database and Application > > > > > > Albert, Yep - I typed it just as shown. That is the way it is in the > > doc's. > > However, I did try your way and the reload worked. However, I still > > can't > > 'design' the app in the new folder (I moved the app over). I'm still > > getting > > an error message, a new one, -ERROR- Unable to connect the requested > > database CNUMB (7). CNUMB is a column in a table. I'll let everyone > know > > how I make out. > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] > > On Behalf Of Albert Berry > > Sent: Saturday, October 26, 2002 3:18 PM > > To: [EMAIL PROTECTED] > > Subject: RE: Renaming a Database and Application > > > > Myron, did you type the forward slash? or only here in the list. The > > forward slash will give R:Base indigestion. > > > > R>reload d:\backup\asdf > > will work as long as the directory backup exists, and there is enough > > room allocated for the database. > > > > Myron Finegold <[EMAIL PROTECTED]> wrote: > > > > >Reload isn't working. > > > > > >I'm connected to the existing db named FLRS > > >At the r prompt I type (not the r>) - R>reload d:\backup/asdf > > >Backup is a folder on the d drive, asdf is the new db name > > >Rbase gives me an error message -ERROR- illegal database name (9) > > > > > >As long as we are doing this, > > >When I rename the old database and try to design the application, I > > >Get this error message > > >-ERROR- Unable to connect the requested database d:\mdfprog\late.rb4 > > > > > >So, it would appear that the rb4 file isn't being updated to the new > > >database name > > > > > > > > >-----Original Message----- > > >From: [EMAIL PROTECTED] > [mailto:owner-rbase-l@;sonetmail.com] > > >On Behalf Of Bernard Lis > > >Sent: Saturday, October 26, 2002 11:41 AM > > >To: [EMAIL PROTECTED] > > >Subject: Re: Renaming a Database and Application > > > > > >Why Don't you just reload to a new name? > > > > > >----- Original Message ----- > > >From: Myron Finegold > > >To: [EMAIL PROTECTED] > > >Sent: Friday, October 25, 2002 7:51 PM > > >Subject: Renaming a Database and Application > > > > > >Has anyone experienced this? > > >Platform win2k > > >R:Base version - 1.859xRT03 > > > > > >Goal - to rename a database and a corresponding application. > > > > > >What I did - Opened the object manager and highlighted the existing > DB > > > went to 'copy' and entered the new database name, clicked ok, so far > > >no > > > problem. Then I highlighted the old app name and went to copy and > > > entered a new app name, again no problem. Then, I went into 'design' > > > opened the new app and changed the startup file to connect to the > new > > >database. > > > Then saved the new app, however this is where the problem comes in. > > >After > > > saving the app and then going back to the database tab the old DB, > > not > > >the new is > > > now open. If I delete the old DB I can't 'design' the app. > > > > > >Does anyone know why? > > > > > >Myron Finegold > > >Port Authority of NY&NJ > > >[EMAIL PROTECTED] > > > > > > > > >================================================ > > >TO SEE MESSAGE POSTING GUIDELINES: > > >Send a plain text email to [EMAIL PROTECTED] > > >In the message body, put just two words: INTRO rbase-l > > >================================================ > > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > >In the message body, put just two words: UNSUBSCRIBE rbase-l > > >================================================ > > >TO SEARCH ARCHIVES: > > >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > > > > > -- > > Albert Berry > > Full Time Consultant to > > PSD Solutions > > 350 West Hubbard, Suite 210 > > Chicago, IL 60610 > > 312-828-9253 Ext. 32 > > > > > > __________________________________________________________________ > > The NEW Netscape 7.0 browser is now available. Upgrade now! > > http://channels.netscape.com/ns/browsers/download.jsp > > > > Get your own FREE, personal Netscape Mail account today at > > http://webmail.netscape.com/ > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
