As the article below notes, almost every application needs data searching. In Visual FoxPro, the first time out, many developers use a browse or a grid. Or a user enters a value into a text box and the code behind it might look like: IF SEEK(tcValue) DO FORM details ENDIF But from Foxite and Jijo Pappachan, comes a very cool and easy to use Lookup class. The class handles both SQL and VFP backends with ease, allowing for smart optimization. Of course, if you're already using a framework, you may already have something like this - but this is something that should certainly be put into an updated FFC on VFPX . If you've ever used the existing FoxPro Foundation Classes search tool, it's pretty limited. This one is definitely more in line with how applications are looking these days. The sample pages don't work quite right and it needs a few tweaks to handle large field names but it can be easily called manually. lo = NEWOBJECT("lookupdata","lookup") U
Solutions for Today; Ready for Tomorrow. Andrew MacNeill's blog about development, technology, Visual FoxPro, databases, community and occasionally, some off-topic discussions.