Databases

I am not able to change the "database" in a form by issuing the statement "set default to c:\MyApp\Train" When I do issue the statement, the form continues to display the original database such as c:\MyApp. Running the form continues to use the table that is part of the database that was in use when the forms DE was use at the time the tables were added to the form. Is there another way to change the forms database, or am I missing something?

TIA

Cowboy
Sun Jun 27 11:57:01 CDT 2004

Sorry for the duplicates, I got a message this did not post.

"Cowboy" wrote:

> I am not able to change the "database" in a form by issuing the statement "set default to c:\MyApp\Train" When I do issue the statement, the form continues to display the original database such as c:\MyApp. Running the form continues to use the table that is part of the database that was in use when the forms DE was use at the time the tables were added to the form. Is there another way to change the forms database, or am I missing something?
>
> TIA

Fred
Sun Jun 27 14:47:36 CDT 2004

If your data tables were located at a sub-folder other than MyApp, like your
training folder that's under MyApp, you'd be able to switch to a different
set.

If your's was set up as:

c:\MyApp\Training
c:\MyApp\Testing
c:\MyApp\Live

If your data was in any of the 3 above subfolders to MyApp, you should be
able to switch with the SET DEFAULT.

I think your problem is that your original design has your tables in MyApp,
not in one of it's subfolders.

Fred
Microsoft Visual FoxPro MVP

"Cowboy" <Cowboy@discussions.microsoft.com> wrote in message
news:E60DF3FD-EC2C-4FA8-AB96-33E28D955CEB@microsoft.com...
> Sorry for the duplicates, I got a message this did not post.
>
> "Cowboy" wrote:
>
> > I am not able to change the "database" in a form by issuing the
statement "set default to c:\MyApp\Train" When I do issue the statement,
the form continues to display the original database such as c:\MyApp.
Running the form continues to use the table that is part of the database
that was in use when the forms DE was use at the time the tables were added
to the form. Is there another way to change the forms database, or am I
missing something?
> >
> > TIA

swdev2
Mon Jul 05 15:54:13 CDT 2004

OK Boy of Cow --
sounds like you are using the data environment of the form to do things with
your tables.
go into the BeforeOpenTables Event -
and start writing code that will check
live or training ? set the path, and SET THE DATABASE

that should be a good starting point - but if you have tables referenced in
the codebase of the form
by some hardcoded path ?

its time to ditch that design and start again

regards [Bill]

--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting
mySql / VFP / MS-SQL

"Cowboy" <Cowboy@discussions.microsoft.com> wrote in message
news:688BEBE7-B11A-4384-9BAA-C5753ACE94EC@microsoft.com...
> I am not able to change the "database" in a form by issuing the statement
"set default to c:\MyApp\Train" When I do issue the statement, the form
continues to display the original database such as c:\MyApp. Running the
form continues to use the table that is part of the database that was in use
when the forms DE was use at the time the tables were added to the form. Is
there another way to change the forms database, or am I missing something?
>
> TIA