Alastair,
To answer your questions -
The app file is 9k.
I'm working at home so, I'm running on a stand alone machine.
Running XP Prof
The database name is FLRS
The application name is now AAF03.
Below is the startup I'm using;
STARTUP
CONNECT FLRS
SET COLOR WHITE ON CYAN
SET CAPTION 'All About Floors'
SET VAR vINV# TEXT
SET NULL ' '
Below is the start of the app.
$COMMAND
AAF03
DISCONNECT
SET QUOTE = '
SET VAR SAVE_MESSAGES = (CVAL('MESSAGES'))
SET VAR SAVE_ERROR = (CVAL('ERROR'))
SET MESSAGES OFF
SET STATICDB OFF
SET ROWLOCKS ON
DEBUG SET MESSAGES ON
RUN STARTUP IN AAF03.APX
SET ERROR MESSAGES OFF
DEBUG SET ERROR MESSAGES ON
NEWPAGE
SET COLOR WHITE ON CYAN
SET BELL ON
LABEL LBEG1
NEWPAGE
CHOOSE PICK1 FROM MENU0000 IN AAF03.APX
SET V PICK11 = (SSUB(.PICK1,1)), +
PICK12 = (SSUB(.PICK1,2))
CLEAR VAR PICK1
IF PICK12 = '[ESC]' THEN
GOTO LEND1......
......
Myron Finegold
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]
On Behalf Of Alastair Burr
Sent: Sunday, October 27, 2002 3:59 PM
To: [EMAIL PROTECTED]
Subject: Re: Renaming a Database and Application
Ok, it was worth a try and I don't mind being wrong - much!!
If you want to send me the .app file I'll take a look at it for you or -
if
it's not too big, only a "k" or two at most - then post it to the list
(preferably as part of an e-mail, not an attachment) if you prefer to
let
everyone put their brains to it. You've got me intrigued now - there
must be
something that's causing your problem.
Another thought, are you on a network and got a mapped drive that's
dynamic
in some way or reverts to the original database?
Regards,
Alastair.
----- Original Message -----
From: "Myron Finegold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 27, 2002 6:57 PM
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/
