To all, Thanks for all the input. I'll let you know I resolve this. Myron Finegold
-----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] On Behalf Of David M. Blocker Sent: Sunday, October 27, 2002 9:40 PM To: [EMAIL PROTECTED] Subject: Re: Renaming a Database and Application OK, I'm stumped!! David Blocker ----- Original Message ----- From: "Myron Finegold" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, October 27, 2002 7:36 PM Subject: RE: Renaming a Database and Application > David, > Don't think I'm ok, here is why. > I just deleted the old app using 'delete' in the object manager. So, > here's what I'm let with. The new db - called FLRS and the new app named > AAF03. When I open the new db (no problem) then click on the 'apps' tab > in the object manager and highlight the app (AAF03) and click on > 'design' and I get the following error message; -ERROR-Unable to connect > the requested database:D:\RBW\AAF\AAF03.APX( 7). The interesting thing > is that 1. The application runs fine without the old db and 2. The > changes I made to the application, with the old db still in the folder, > work when I run the application. > > One final note, all of the database files (rb*) and all of the > application files (ap*) are in the same folder. > > I really do appreciate all the brain power going into this. > > Myron Finegold > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] > On Behalf Of David M. Blocker > Sent: Sunday, October 27, 2002 7:11 PM > To: [EMAIL PROTECTED] > Subject: Re: Renaming a Database and Application > > 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/ > > ================================================ > 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/
