Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Nilson Rishi
  Where is Nilson Rishi?
 Bangkok
 Thailand
 Nilson Rishi
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: performance issue with remote view
Thread ID: 104117 Message ID: 104149 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Saturday, August 12, 2006 4:35:12 AM         
   


The candidate list will always have CUSTOMER ID and name as the only 2 columns?
Is it possible to make a generic SQLSelect statement:
lcSelect="SELECT customer_id,left(title+' '+first_name+' '+lastname,30) as customer_name from customer where "+cSearchType+" LIKE ?"+lvVariant+'"'

So that just one SQLScript could be used for all fields for all tables?

I thank you very much for your detailed instructions.
Nilson

ENTIRE THREAD

performance issue with remote view Posted by Nilson Rishi @ 8/11/2006 4:54:12 PM
RE: performance issue with remote view Posted by Martin Sellwood @ 8/11/2006 5:07:20 PM
RE: performance issue with remote view Posted by Bernard Bout @ 8/11/2006 5:41:43 PM
RE: performance issue with remote view Posted by Nilson Rishi @ 8/11/2006 6:07:03 PM
RE: performance issue with remote view Posted by Jim Winter @ 8/11/2006 6:22:31 PM
RE: performance issue with remote view Posted by Nilson Rishi @ 8/11/2006 6:35:47 PM
RE: performance issue with remote view Posted by Kiran Kumar Singh @ 8/11/2006 7:16:34 PM
RE: performance issue with remote view Posted by Ken Murphy @ 8/12/2006 1:40:04 AM
RE: performance issue with remote view Posted by Nilson Rishi @ 8/12/2006 4:35:12 AM
RE: performance issue with remote view Posted by tushar @ 8/12/2006 1:29:17 PM
RE: performance issue with remote view Posted by Nilson Rishi @ 8/12/2006 5:32:29 PM
RE: performance issue with remote view Posted by Ken Murphy @ 8/12/2006 2:53:31 PM
RE: performance issue with remote view Posted by Nilson Rishi @ 8/12/2006 5:28:46 PM