Versions des environnements
Network:
Windows 2008 Server
>>Yes, you can create a Linked Server to FoxPro data using the VFP OleDB driver and then use OPENQUERY, but to my experience and knowledge you'll end up pulling the entire FoxPro table in before the data becomes available in the SQL world.
>
>That's generally true (though you can qualify with a WHERE clause in the query), though perhaps true in some way with a few other options as well
Yes, I believe also that you can you a WHERE clause, but I'm pretty sure that that WHERE clause is only within the FoxPro data. You can't use values from the SQL data in the OPENQUERY WhERE clause.
Précédent
Suivant
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