Multiple Databases with Paradox
Dear Digital Metaphors:
I know that DADE does not support multiple databases. However, using a data
dictionary to supply Table & Field names, is possible to use Paradox aliases
(ie., :DBSYSTEM:Table.db) in the table name in order to acces multiple
databases in a single query. This work fine while the aliases was defined
with SQL Explorer but in my case I create the Databases dynamically, and in
this case DADE is not be able to find the table.
Do you have any idea to solve this problem?.
Thank you.
--
Ing. Carlos M. Sotomayor
Grte. de Tecnolog?a
www.arizmendicomputos.com
www.arizmendi.com
TE 5235-7000/7005
I know that DADE does not support multiple databases. However, using a data
dictionary to supply Table & Field names, is possible to use Paradox aliases
(ie., :DBSYSTEM:Table.db) in the table name in order to acces multiple
databases in a single query. This work fine while the aliases was defined
with SQL Explorer but in my case I create the Databases dynamically, and in
this case DADE is not be able to find the table.
Do you have any idea to solve this problem?.
Thank you.
--
Ing. Carlos M. Sotomayor
Grte. de Tecnolog?a
www.arizmendicomputos.com
www.arizmendi.com
TE 5235-7000/7005
This discussion has been closed.
Comments
We do not have any experience with creating BDE Aliases dynamically.
The ReportBuilder DADE Plug-in for the BDE is located in
RBuilder\Source\daDBBDE.pas. The method TdaBDESession.GetDatabaseNames calls
TSession.GetAliasNames.
My guess is that the BDE is caching the alias information or perhaps the
Delphi Session object is doing this. Try searching Google groups for any
issues related to this.
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com