Thank you for your response.
I agree that using two datawindows side by side would by far be the easiest method,
but unfortunately, my two result sets would each return a different number of records
depending on the retrieval arguments. Therefore, the records usually wouldn't
naturally match up horizontally.
Looks like moving the data between datastores and buffers is the only alternative....
wish me luck! ;-)
>>> "Hensel, Russ" <[EMAIL PROTECTED]> 11/08/99 03:44PM >>>
I find that you can usually put 2 datawindows next to each other to get the
effect you need. If that does not work use a data window with spare columns
( things like 1, '' ) use it against 1 dbms. Use a data store for the other
dbms, then you move the data around in code. It will work for any 2
different types of databases. Not fast, but it works.
Russ
-----Original Message-----
From: Jill M. Claus [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 08, 1999 1:58 PM
To: Klebe, Paul E.; [EMAIL PROTECTED]
Subject: RE: PFCSIG: Connecting to Two Databases
Although I would find it extremely useful - I have not
figured out a way to combine information from two different databases into
one datawindow.
Maybe someone else in the user group may have a suggestion.
If you do get a solution from someone addressed to your personal email
address, could you please forward it to me? This is something I really need
as well.
>>> "Klebe, Paul E." <[EMAIL PROTECTED]> 11/08/99
10:15AM >>>
Thanks. This means that although you can display information
from two
different databases in two different datawindows in a
window, you cannot
directly combine two tables from different databases on the
same
datawindow.
How do you combine information from the two different
databases into the
same window? Can you use a common id column multiple times
and a cached
dropdown_datawindow to display various fields from the other
database?
I would like to develop a single common name-address
database that is
used throughout the commission rather than using separate
tables in each
database for our 8 divisions.
-----Original Message-----
From: Jill M. Claus [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 04, 1999 12:13 PM
To: [EMAIL PROTECTED]
Subject: RE: PFCSIG: Connecting to Two Databases
Hi Paul,
This is the first time I did it, so it may not be the best
way... but it
works!
I added some comments below that may help you ...
>>> "Klebe, Paul E." <[EMAIL PROTECTED]> 11/03/99
03:12PM >>>
My name is Paul Klebe, I work for the North Dakota Public
Service
Commission. I have an upcoming project where I will be
attempting to
connect to two different databases. Would you be willing to
talk to me
about doing this. I am not getting where you are getting the
connection
to two different databases.
-----Original Message-----
From: Jill M. Claus [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 03, 1999 1:39 PM
To: [EMAIL PROTECTED]
Subject: RE: PFCSIG: Connecting to Two Databases
I got it working - thanks everyone!
For anyone curious, I changed the n_tr instance variable to
be global
and edited the application manager pfc_open event code to
be:
// enable transaction registration (the registration service
is need
when using more than one database)
gnv_app.of_SetTrRegistration(TRUE)
// register SQLCA (the connection to the first database
which was
connect to the usual way)
gnv_app.inv_trregistration.of_Register(SQLCA)
// connect to and register ABRN_MRS database (the second
database)
// create the second transaction object - note that you must
have "n_tr
gtr_amrs" identified as a global variable
gtr_amrs = CREATE n_tr
// copy connection info from the first database called SQLCA
to the
second database called gtr_amrs - it copies the user id,
password,
database name, server name, etc. from the definition of the
first
database connection to the definition of the second database
connection
il_return = SQLCA.of_CopyTo(gtr_amrs)
// re-assign the database name to the second definition
gtr_amrs.Database = "your_2nd_database_name"
// re-assign the server name to the second definition - if
it's
different
gtr_amrs.ServerName = "your_2nd_server_name"
// connect to the second database
ll_return = gtr_amrs.of_Connect()
If ll_return <> 0 then MessageBox("Error", "Unable to
connect.")
// register the second database with the registration
service
gnv_app.inv_trregistration.of_Register(gtr_amrs)
Then when ever you want to retrive data from the 2nd
database, you would
say... (in the window's open event)
li_return = dw_1.of_SetTransObject(gtr_amrs)
dw_1.retrieve()
instead of...
li_return = dw_1.of_SetTransObject(SQLCA)
dw_1.retrieve()
Hope this helps!
Jill
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST
SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING
MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
