>>I have foxpro 2.6 databases on more locations.
>>
>>I can not changes the locations
>>
>>I what to make an ODBC connection to tables on both location.
>>
>>Now i have 2 connection.
>>
>>I have to make a query over 2 databases from both locations
>>
>>lsql = 'select * from tableloc1,tableloc2 where tableloc1.zipcode=tableloc2.zipcode'
>>
>>
>>=sqlexec(connection1,lsql,"temp") &&Not connection2
>>I can only use connection this does not wotk
>>
>>Can someone help me
>>
>>Kinde regards
>>
>>
>>
>>Jan Dorresteijn
>
>You cannot run a single SQL Query against two databases that reside on seperate remote machines via ODBC. You will either have to access them as native tables or if you must use ODBC then you will have to perform seperate SQL queries against each table and return whatever subset of data is possible into cursors. Then run your sql against the two cursors.
Thanks fo your reply
I was affraid for that
I that case i have to combine the directories but that gives
a lot of problems
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement