>>Can anyone tell me how to search table without moving a record pointer?
>>I have table in record buffering mode. I'm adding a new record and I
>>want check some field contents before 'tableupdate'-ing. I used
>>KEYMATCH function but when I called it, validation rules for the record
>>activated. It seems to me that KEYMATCH is changing a recno of the
>>searched table.
>
>There's always something new to learn. I had not heard of the KEYMATCH()
>function until you mentioned it. From my quick tests, it does indeed seem
>to tell you if a given key is found in the index WITHOUT changing the
>record pointer.
>
>But I agree with the others who have suggested using the table AGAIN...
>
>Don Smith
Keep in mind that KeyMatch() will also find deleted records in the index ignoring the setting of Set Deleted.