Hi,

I have just started using Foxpro 7, about a week ago!
I have a project, which works quite happily using one
database.
I have the database location at ..\gen002\sas.dbc
This database is the default database, and I have set it
up so that this is the one thatthat is always opened on the
initial screen.

Now I have been asked to change the set-up program so that
the User can see the older version of the data, which is
in a different folder:
..\gen001\sasdbc

The two databases are exactly the same as are table names,
but obviously the actual contents are different. In the
future there will be more databases, because a new one
will be produced every 3 months.

So, what I need is to be able to select a different
database from a combo box, where the user selects the
database_date. I thought that the way to do this was to use
the

SET DATABASE TO ..\gen001\sas.dbc

within the combo box click event

Unfortunately this comes up with Database "c\sas' is not open. So I changed it to

OPEN DATABASE ..\gen001\sas.dbc
and then
SET DATABASE etc etc

But then it comes up looking in the Visual Foxpro default directory.

Finally, I was able to place both databases into my project window! and thought that that would work but still says the database is not open.

All I am after is to be able to open one or more databases and set the one selected to the default!

Can someone please let me know what I'm doing wrong.

Thanks in advance

Cheers
Rob

PS Yes, I am new to Foxpro!