RonB
|
| Posted: 05/21/2002, 2:05 PM |
|
It's great that I can use different connections to different database for
listboxes in records. I would like the possibilty though to do the same in
grids. For example:
At my company there are three main databases
-mysql for the intranet (because of speed and security reasons)
-oracle is used for client registration software(we are a drug addiction
treatment center)
-solid database in human resource management software
In all three employee data is kept. I would like to cut that down to one.
the two other databaseswould then get their employee numbers from the main
database. As I said it works fine for record sets but now I want to display
information that uses employee data so I'll have to join the employee table
from database1 with let's say database2. I know have to write the code in
some before or the day after event myself. Would be nice if I could use the
query generator by being able to choose tables from all connections.
RonB
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 05/24/2002, 2:19 AM |
|
Currently this should be done by using custom sql statement.
I've notified our developers about this wish.
--
Alex
CodeCharge Developer
"RonB" <r.borkent@123chello.nl> wrote in message
news:acecqa$cdb$1@news.codecharge.com...
> It's great that I can use different connections to different database for
> listboxes in records. I would like the possibilty though to do the same in
> grids. For example:
> At my company there are three main databases
> -mysql for the intranet (because of speed and security reasons)
> -oracle is used for client registration software(we are a drug addiction
> treatment center)
> -solid database in human resource management software
>
> In all three employee data is kept. I would like to cut that down to one.
> the two other databaseswould then get their employee numbers from the main
> database. As I said it works fine for record sets but now I want to
display
> information that uses employee data so I'll have to join the employee
table
> from database1 with let's say database2. I know have to write the code in
> some before or the day after event myself. Would be nice if I could use
the
> query generator by being able to choose tables from all connections.
>
> RonB
>
>
|
|
|
|
|
