Francesc Verdu
|
| Posted: 10/28/2004, 9:21 AM |
|
I'm new on CodeCharge Studio. The first problem I have is that I want make queries for mixed databases from several connections.
Let's say I have a connection using Visual Foxpro tables and an other connection using ms access tables. I want to display data from a "view" involving tables mixed from the two connections. I don't find the way for making this!
Anyone can help? Is this possible with CCS?
Thanks in advance,
Francesc
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 10/28/2004, 10:53 AM |
|
You cannot, whether with CCS or without CCS. An SQL statement has to be sent to one database that will process it. CCS doesn't limit you here.
However, you may achieve similar result with one connection - by linking Foxpro tables to MS Access or vice versa. This is not related to CCS though.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Tuong Do
|
| Posted: 10/28/2004, 5:23 PM |
|
Hi Francesc,
Try the before show row
ie retrieve data from one connection then in the before show row use the
CCDLookup to lookup for data in the other connection
<FrancescVerdu@forum.codecharge (Francesc Verdu)> wrote in message
news:241811c8f97ef2@news.codecharge.com...
>
> I'm new on CodeCharge Studio. The first problem I have is that I want make
> queries for mixed databases from several connections.
> Let's say I have a connection using Visual Foxpro tables and an other
> connection using ms access tables. I want to display data from a "view"
> involving tables mixed from the two connections. I don't find the way for
> making this!
> Anyone can help? Is this possible with CCS?
>
> Thanks in advance,
>
> Francesc
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Francesc Verdu
|
| Posted: 11/23/2004, 6:48 AM |
|
I tried linking FoxPro tables from MSAccess, but linked tables doesn't appear on CCS when retreiving the tablelist from a CCS connection. Surprisingly, Access Views DOES appear as 'tables' for CCS, so I created a view for every linked(foxpro) table, but I'm no sure this will be a 'solid' scenario...
Quote peterr:
You cannot, whether with CCS or without CCS. An SQL statement has to be sent to one database that will process it. CCS doesn't limit you here.
However, you may achieve similar result with one connection - by linking Foxpro tables to MS Access or vice versa. This is not related to CCS though.
|
|
|
|
Francesc Verdu
|
| Posted: 11/23/2004, 6:54 AM |
|
Thank you for the tip, i will try it... but I think it will work properly on some simple queries, but I guess it won't on more complex queries.
My goal is managing the mixed tables as a whole SINGLE database, creating queries regardless of the real nature of tables..
Quote Tuong Do:
Hi Francesc,
Try the before show row
ie retrieve data from one connection then in the before show row use the
CCDLookup to lookup for data in the other connection
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/24/2004, 12:14 AM |
|
I can see my linked tables in CCS if I used ODBC connection instead of JET. I guess this is just JET vs. ODBC issue, not related to CCS. CCS can only see what those drivers provide.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
