Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View or CA to join native and ODBC tables
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01386669
Message ID:
01386742
Views:
37
I can't even think about that. Right now all I can think about is your location. Don't even come around here showing off like that. <g>

You and Strahl. Man! I've been to Hawaii three times, last in 2000. Looking forward to the next trip, but don't know what that will be. Looking forward to diving again at Molokini Crater.

As for you answer, thanks. I may try that, but since I have the CAs set up now, that may be the quicker approach.


>Not quite the same issue I've had in the past because I don't use CA's - but what I've done before is create remote views, then create a local view to join the remote views - this way you can be hitting multiple data-sources.
>
>>I believe I tried not long ago to create a view that joined a table in the DBC to one that was not in the DBC. Is there a way to do this? IIRC, VFP was not allowing me to do this. My situation is that I need to join two tables in my DBC to a cursor created via a CA that originates from a Firebird database. I was thinking maybe I could do it all with a CA, but a CA makes you select your datasource type and you can't select two (native and ODBC). Perhaps if the native tables are already open, it will "just work." I only have to update one of the native VFP tables, so that part is not very demanding. Has anyone done something like this before?
>>
>>Thanks,
>>
>>Russell Campbell
eCost.com continues to rip people off
Check their rating at ResellerRatings.com
Previous
Reply
Map
View

Click here to load this message in the networking platform