I am using a tADOTable connected to a bdgrid to display the contents of the table. I want to implement a search so the user can enter a partial value that can be contained ANYWHERE in a field value (not just as a prefix) and then hit the search button. I can move the grid to the record position once I know it. Also if they hit search again, it should look for the NEXT match, and so on till there are no more matches, then I can offer them to start at the top again.
Using the Datasets find and locate do me no good since I can only search on a field prefix. If the field contained "This is the current record" I want to be able to locate that record searching on "the" or it is were more like the tsql like then "%the%" or "*the*".
I can scan the grid manually, but this is slow and you can tell the speed is not good.
Anyone know how I can do this?
Thanks,
David
Start Free Trial
