Subject | auto-search ? |
---|---|
Author | Robbie |
Post date | 2010-04-22T00:02:30Z |
Not sure if this is the correct term ... but let me explain that for which I am looking.
I've seen programs which, as you type one character at a time ( let's say a Vehicle Identification Number ( VIN ) ) and for each character the end-user types, the application moves down to the 1st record in the VIN Data file which starts with that character. As the end-user types the 2nd character, it moves down to the 1st record which starts with those 2 characters, etc, till it either finds the VIN for which they're searching or when it the application has moved to one record below where the VIN would be sorted in Ascending order.
I'm wondering if that can be coded in FireBird, either as a procedure or function or combination there-of.
I've seen programs which, as you type one character at a time ( let's say a Vehicle Identification Number ( VIN ) ) and for each character the end-user types, the application moves down to the 1st record in the VIN Data file which starts with that character. As the end-user types the 2nd character, it moves down to the 1st record which starts with those 2 characters, etc, till it either finds the VIN for which they're searching or when it the application has moved to one record below where the VIN would be sorted in Ascending order.
I'm wondering if that can be coded in FireBird, either as a procedure or function or combination there-of.