Chaning the database of a dade query

rbuser

Hello,

I found this tech tip, but it is unclear to me.

---------------
In some cases, you may decide that the
DatabaseName needs to be modified at a later date.

We recommend that the DatabaseName
refer to a TDatabase connection component or to
a FieldAlias to provide flexibility for changing
the connection parameters.
----------------

I am using IBX. What do you mean by "refer to a tdatabase connection"? I
have a transaction component and of course a database component. How do I
tell RAP which transaction or which tIBDatabase to use?

In the same techtip you of course explain in detail how to access the sql
object and pass the database. But it also says "we recomment that the
databasename refer to a tdatabase" and then "A second way to handle this
issue is to implement some code that specifies a DatabaseName whenever a
template is loaded.".

I would like to know how to implement the FIRST way ;-).

"We recommend that the DatabaseName
refer to a TDatabase connection component or to
a FieldAlias to provide flexibility for changing
the connection parameters."

Thank you!

nardmoseley

For an example of a correct configuration using Interbase Express, check out
RBuilder\Demos\EndUser Databases\Interbase\IBExpress. Open the example and
check the Designer.DataSettings values. The SessionType is set to IBXSession
and the DatabaseName is set to euDatabase which is the Name of the
IBDatabase component that resides on the same form.



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com