DB_RS_FIND

Syntax

int_val = DB_RS_FIND ( rec_set, condition );

Input arguments

handle	rec_set	Handle of the record set.
string	condition	Condition that is used to find a record from the record set.

Return Values

Success:

int

0

Record found from record set.

Failure:

int

-1

Script interface error.

Description

This function finds a record in a record set by given condition.

Condition must an SQL expression and of form:
[Column] [Operator] [Value]

Notes:
1) Only one column can be used in the condition.
2) Find operation is started from the current record. Use db_rs_move( ,"FIRST") in order to find from beginning of the records.
3) If the current record matches the condition, it will remain as current record.

If the record is not found, the cursor will be EOF of the record set. In the other words a call to function rs_is_eof will return 1.

Example

Name = 'Smith'
Number = 1
Description LIKE "This%"