aclhkaclhk
Posts: 3
|
| Posted: 06/02/2010, 2:44 AM |
|
I am new to codecharge studio.
I need to display records from tables of 2 databases. pls advise if this is supported.
|
 |
 |
datadoit
|
| Posted: 06/02/2010, 5:49 AM |
|
CCS allows for multiple connections to multiple locations/databases.
-Each- record form or grid can use -one- of those connections.
|
|
|
|
aclhkaclhk
Posts: 3
|
| Posted: 10/19/2010, 3:50 AM |
|
i have two databases. could we link the records from tables of different database?
database->table->fields
db1->customer->customer_id, login, pass
db2->customer_order ->customer_id, order_id, item, qty, price
after customer login, the list of orders for that customer will be displayed.
pls advise if this is possible.
|
|
|
|
aclhkaclhk
Posts: 3
|
| Posted: 10/19/2010, 4:29 AM |
|
if yes, pls briefly advise how to do so or which examples could illustrate this.
|
|
|
|
rho
Posts: 85
|
| Posted: 10/19/2010, 4:42 AM |
|
Hi aclhkaclhk,
to do this in CCS, you have to write custom code: first get the records from the db1-connection, then get the additonal data from the db2-connection, combine the results, and finally display the results.
In CCS, it is not possible to simply "link tables" from different databases, as this is something that should be handled within the database you use (ie, the database would link additional tables from another database which are then available through a single db-connection). See if your database supports "linked tables".
Cheers, Rob.
|
|
|
|
|
