This may be the wrong newgroup, so pls accept apologies. For months now I've had a number of VFP6 tables linked via OLEDB driver from MS Access. The VFP tables can be large, say 150000 + records (not that large, I know).
I'm trying to do a fuzzy search on two fields from two textboxes. It looks something like this: "SELECT [fields] FROM [table] WHERE [field1] LIKE '%'+textbox1.value+'%' AND [field2] LIKE '%'+textbox2.value+'%' ORDER BY [fields] INTO CURSOR"
I'm trying to initiate query to a remote (thin pipeline) Progress database. I can pull the whole tables w/o any problems, except for the huge time lag. Due to the size of the tables I'm pulling from and the SLOW connection speed, I'm trying to filter on the initial remote view ...