>>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.
>Use again and sql are good for not moving the pointer but what if you want to check a buffered record too (BTW keymatch is worst for me)?
>You should use the buffered table - go check and return. Problem is firing valid events. For that I first check the current record, save contents to an object var, fill with values that are valid (and dummy placeholders), do my check, return to the record and restore contents from saved obj var.
>Cetin
Now this is not clear to me - I've had just the oposite trouble:
- enter a value into a field (bound control)
- its valid method wants to know if this key exists, so it selects another alias of the table
- it finds the buffered record there.
Buffering, I'm not sure (for both aliases), should be 3 or 5.