The following is a quote from the Help.CHM ---
==========================================================
Syntax
Numeric Record_Number = <TBL>.FETCH_FIND( Matching_Expression as A )
Argument
Description
Matching_Expression An expression used to select a record. The Matching_Expression and the table�s or set's primary index key must have the same data type. Alpha Five will automatically pad the Matching_Expression with trailing blanks if necessary so that the length of Matching_Expression matches the index key length. If the table�s or set's primary index is record number order, then Matching_Expression is the record number that you want to find.
Description
The <TBL>.FETCH_FIND() method retrieves the first record in the table or set referenced by <TBL> with a primary index key equal to the Matching_Expression parameter.
If <TBL>.FETCH_FIND() is successful, the found record is retrieved and its Record_Number is returned. If no exact match is found, a negative number corresponding to the record number of the closest matching record is returned.
==========================================================
Does anyone know how to handle the 'find' if no match is found?
In my case, the script just goes to the next record in line. How would you error trap this to stop the presentation of the wrong record??
It's quite possible that I already know the answer, but don't know it is the answer.
AHA
D
==========================================================
Syntax
Numeric Record_Number = <TBL>.FETCH_FIND( Matching_Expression as A )
Argument
Description
Matching_Expression An expression used to select a record. The Matching_Expression and the table�s or set's primary index key must have the same data type. Alpha Five will automatically pad the Matching_Expression with trailing blanks if necessary so that the length of Matching_Expression matches the index key length. If the table�s or set's primary index is record number order, then Matching_Expression is the record number that you want to find.
Description
The <TBL>.FETCH_FIND() method retrieves the first record in the table or set referenced by <TBL> with a primary index key equal to the Matching_Expression parameter.
If <TBL>.FETCH_FIND() is successful, the found record is retrieved and its Record_Number is returned. If no exact match is found, a negative number corresponding to the record number of the closest matching record is returned.
==========================================================
Does anyone know how to handle the 'find' if no match is found?
In my case, the script just goes to the next record in line. How would you error trap this to stop the presentation of the wrong record??
It's quite possible that I already know the answer, but don't know it is the answer.
AHA
D
Comment