Bob,
>I moved my code over to another machine and the results returned as expected (not slow). I then restarted my main computer and tried again and got the rows returned as expected.
>
>Not sure what happened here but something was slowing it down and it was consistent. I tested it over and over and got the same results before restarting. Anyway, consider this resolved.
Glad you were able to resolve it!
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com