infotba
|
| Posted: 11/18/2002, 1:38 AM |
|
2 database connections in 1 project is ok
-http://www.gotocode.com/art.asp?art_id=96&-
What about 2 databases on 1 page ?
Regards
|
|
|
 |
xbill
|
| Posted: 11/18/2002, 9:45 AM |
|
With CC-
you would have to hand code some
custom events and tune the connections
on the events on the object.
With CCS-
multiple database connections are built in.
You define the connections in the "Project settings"
and then "Connections".
To change the connection on an object (grid,record,etc)
select the "Properties" box -"Data Tab" and
then three dots beside the second field "Connection".
-bill
|
|
|
|
elaine
|
| Posted: 06/25/2003, 10:11 AM |
|
I have a grid object where one of the fields is an ID from a table in ANOTHER database than the one selected for the grid object. I want to display the value and not the ID. How can I do this? CCS only allows me to select one DB connection per object.
Thanks,
Elaine
|
|
|
|
Tom
|
| Posted: 06/25/2003, 12:02 PM |
|
Easiest way to do this is to create a 'view' in one database of the table in the other database. I'm not sure what db you are using but doing this is much easier and allows you to attach to one connection.
|
|
|
|
