Find record in Delphi table starting with a string

Posted by Jenny on June 18, 2005

In Reply to: plz help me posted by mido on June 13, 2005

: hello there

: i've create a table in a form,i want 2 make a seach button in this table,exp
:i want 2 make a search for the Book beginning in letter A or else,wat is the procedure
:plz help me,10x 4 u

The Delphi table must be indexed on the field "Book". You find the first record where this field starts with A:

Table1.FindNearest(['A']);

If there is no index on a field, it's not possible. You could go through all the records, or use the Locate method, but that would not give you the FIRST book in alphabetical order that starts with an A.

Cheers,
Jenny