Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing Different Databases
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00142919
Message ID:
00142921
Views:
29
>Quick Question...
>
>Can I access 2 Different Databases on 2 different connections
>and do a query between them??? Is this even do-able?
>
>(We have a very strange request to query information real-time
>between our Web Server on SQL Server Database A, and our
>Contact Management system on SQL Server Database B...)
>
>Thanx!
>Bob :-)

I think you could do it. Create two remote views, then you can create a view using those two views, or you could query the views...

select * from v_database1file,v_database2file into cursor combined

BOb
Previous
Reply
Map
View

Click here to load this message in the networking platform