Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remote View

Status
Not open for further replies.
JoeReed

JoeReed

Programmer
Joined
Nov 3, 2003
Messages
10
Location
US
Greetings...

Is their anyway to base a remote view on an INNER JOIN with a local dbf?

I have a local dbf (qty: 179) and I want to select only the records that match via "SUBS" field with a SQL table (qty: 500,000+).

I've done it using a remote view on all 500,000+ records but I didn't know if there was a quicker way.

Thanks in advance...
 
Status
Not open for further replies.

Similar threads

stanlyn
  • Locked
  • Question Question
Master/Detail Remote View Form Sample Needed
Replies
3
Views
303
stanlyn
stanlyn
stanlyn
  • Locked
  • Question Question
Apps Standardized on Remote Views or SPT or CursorAdapters or Any
Replies
4
Views
364
stanlyn
stanlyn
Rajesh Karunakaran
  • Locked
  • Question Question
Accessing VFP data from a remote server using OLEDB from outside of LAN
Replies
1
Views
276
GriffMG
GriffMG
stanlyn
  • Locked
  • Question Question
Converting Set Filters to Remote Views
2
Replies
22
Views
854
Chris Miller
Chris Miller
GirishSharma
  • Locked
  • Question Question
View Form Wizard Code
2
Replies
27
Views
1K
TamarGranor
TamarGranor

Part and Inventory Search

Sponsor

Back
Top