Groups > dBase > Getting Started with dBase > Re: Multiple tables in one Databasefile




Multiple tables in one Databasefile

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
about | contact