I would like to make a search function on a dataset which makes a partial comparison of the ginen string (aFindDialog.FindText ). I try using the Locate function but I always get the first record matching the text whereas I want to proceed to the next matching record if there are more than one. So I always get to be shown the first matching record of the dataset and can't move on the next one. The database is Access..
My Code is:
Result := False
if aFindDialog.FindText <> '' then
Result := Tadodataset(aFindDataset).Locate (aFindFieldName, aFindDialog.FindText, [loPartialKey, loCaseInsensitive]);