| Subject | Re: USING SECOND DATABASE |
| From | Mervyn Bick <invalid@invalid.invalid> |
| Date | Thu, 20 Nov 2014 09:08:15 +0200 |
| Newsgroups | dbase.getting-started |
On Wed, 19 Nov 2014 10:15:28 +0200, CORNELIUS <jcmsoftware@gmail.com> wrote: > Hi there, > > I have a problem switching database on local disc c: > > I started of with a local database (stellocal) in the same folder as the > program (c:\hpstel\jcmcps) > > The database with customer info is in database stelsystem (c:\hpstel\dbf) > When working the program will open and set database to the above and it > works well. > > That is until I wanted to add next customer with database stelsystem2 > under c:\hpstel\dbf2 > > Is there a way to let the program on one database at a time or do I > have to also have to make a different folder and have a second program > running there (taking up space) > > I am used to dbase 5 where we simple used the set path to command that > worked very nice. > > If anyone can please help me I will be very grateful for the help. All you need to do is firstly set up a folder for each customer with the appropriate files and then set up a BDE alias for each folder. You can either use the BDEAdministrator or bdealias.cc in the dUFLP to set up these aliases. In you program, to change customers, set the database object and all query objects active properties false, change the databasename property to the alias for the next customer and then set the database active property true before you set the query objects' active properties true. You only need one copy of your program if you only want to work on data for one customer at a time. Mervyn. | |