DB search records
Posted on 2001-07-24
To search through DB records I use this:
if Edit1.Text <> '' then
ADOQuery1.Locate('Name', Edit1.Text, [loCaseInsensitive, loPartialKey]);
This is On change event of the edit box.So when I begin typing my grid scrolls accordingly
to the matching entry.Works fine...
The problem is this:
When my grid displays the result of my search (I have entered a full name) how am I to continue searching
through my DB records?Say the match is right but it is not the right person...i.e I am looking another person with the same name...How am I to go arround this problem as there are many same names and surnames?
I had in mind to put a button next to edit with "new search" caption on it so when the name
is in the edit and I hit this button I get taken to the next person with the same name.
How am I to do this?