|
| Multiple tables in one Databasefile |
 |
Fri, 04 Apr 2008 02:58:18 -050 |
|
| Post Reply
|
| Re: Multiple tables in one Databasefile |
 |
Fri, 4 Apr 2008 12:00:22 -0400 |
In article <CCG#kmilIHA.644@news-server>, mulenker@yahoo.de says...
> Is it possible to create one Databasefile which contains several tables ?
A datamodule (.DMD) is a bag of rowsets. It allows you to link tables,
to create calculated fields, etc.
Datamodules can be create with dQuery (dBASE's Datamodule Designer) or
by hand (using an existing DMD as a blueprint).
Jean-Pierre Martel, editor
The dBASE Developers Bulletin
|
| Post Reply
|
| Re: Multiple tables in one Databasefile |
 |
Fri, 4 Apr 2008 14:07:30 -0700 |
"Dieter Mulenker" <mulenker@yahoo.de> wrote in message
news:CCG%23kmilIHA.644@news-server...
> Is it possible to create one Databasefile which contains several tables ?
In addition to what Jean-Pierres posted:
You can setup an Alias in the BDE and it treats all the tables in that alias
as if it were 1 single database. It is not technically a true database file
in which all tables exist but it is treated the exact same way.
oodml would be to drop a database object on the form and then, any query
objec that you drop on that form will need to be assigned to that database
or actually any database.
xdml would be as follows:
open database yourDatabase
set data to yourDatabase
use anyTable in that database
if you try to use a table that is not in that database it will fail to open,
unless you open that database and spcify it as follows:
open database otherDatabase
use :otherDatabase:TablefromOtherDatabase
or
select * from :otherDatabase:TablefromOtherDatabase
Hope this helps.
Greg Hill
|
| Post Reply
|
|
|
|
|
|
|
|
|
|