Finds a record in the current recordset using a filter expression, and perform a selection operation.

[Visual Basic]Public Function SelectRecordByFilter( _
   ByVal filterExpression As String _
) As Boolean

Parameters

filterExpression

Specifies an expression that qualifies the record to find. See the Remarks section for details.

Return Value

This method returns True if the selection succeeds, or False if the method fails to find a record to select.

Remarks

Searching starts with the record following the current record. If the current record is before the first record in the recordset, searching starts with the first record.

Using Filter Expressions

Some of the methods in the .NET connector allow you to use filter expressions when fetching records from a recordset. The syntax you can use to build filter expressions is:

condition_statement=condition_expression

You can use expressions on both the left and right sides of the condition statement. Be sure to enclose data in quotation marks.

Condition Expressions

Value Expressions

A value expression can take any of the following:

• Variable (variables.variablename)
• Attribute (attribute name)
• Field (recordset.recordsetfield)
• String
• Integer
• Floating point number

Filter Expression Examples

This example returns all records in the patients recordset that are not "Smith":

patients.lastname  <> "Smith" 

This example returns the exact same set of records as the preceding example:

NOT (patients.lastname = "Smith")

This example returns all records in the SearchResults recordset with the last name "Smith" and first name "Steven":

(SearchResults.LastName = "Smith") and (SearchResults.FirstName =* "Steven")

This example returns all fields in the AccountNumbers recordset greater than or equal to 10000 and less than or equal to 20000:

(AccountNumbers.Accounts >= 10000) and (AccountNumbers.Accounts <= 20000)

See Also

HostIntegratorSession Class | HostIntegratorSession Members | WRQ.Verastream.HostIntegrator Namespace