Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combining VFP and SQL Server data in a join
Message
 
 
To
10/11/2009 09:22:46
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
01433921
Message ID:
01434033
Views:
31
>Great lead, Naomi, thanks
>
>Running this script from the SQL Query analyzer returns sono (an indexed field in the DBF) almost as quickly as VFP returns it.
>
>SELECT sono from OPENQUERY(linkeddata, 'SELECT * FROM somast01 WHERE sono = " 236208"')
>
>That's exactly what I was looking for..

You're welcome - I was reading T-SQL forum last night and when I saw this thread I remembered your question.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform