GetRecordIndexByNearKey |
Databases | |
Aptilis 1 |
GetRecordIndexByNearKey(ArrayName[], Key, Index [, FromWhere])
GetRecordIndexByNearKey works exactly like
getRecordIndexByKey
except that it does an approximative search.
Here, I will just explain how to do the keys.
See getRecordIndexByKey
for programming examples.
getRecordIndexByNearKey is not case sensitive.
GetAllRecordsByKey and GetAllRecordsByNearKey are more high-level and allow you to retrieve several records directly, in one go.
Examples
To do an aproximate search, use the special characters
'?' for any one letter, and '*' for any group of letter.
"blue" | will match 'blue', exactly. |
"f*" | All fields begining with 'f'. |
"*i" | All fields ending with 'i'. |
"*a*" | All fields containing the letter 'a'. |
"?ree" | All words of any first letter ending in 'ree', like 'tree' or 'free'. |
"*a" | Anything ending with the letter a, like 'ha' or 'armada' |
etc... |
Notes
The patterns used by 'GetRecordIndexByNearKey' are exactly the same as
the ones used by Match.