This method returns the value of a field from a table record. The record retireved is governed by the passed in filter (Public)

o.getfieldvalue( tcField, tcFilter)

Return Value

The value of the passed in field for the record retrieved by the query

Parameters

tcField
The field name in the table where this value relates to

tcFilter
Any valid SQL filter you want to add to the query

Remarks

This function is very useful for determining the value of a field in a table for a particular filter condition.

BE CAREFUL!! As this carries out a query. If the field you are trying to validate is not indexed the query could take a long time

Example

o.GetFieldValue("Satus","Account = '12333'")

The above would return the value in the "status" field for account number "12333"

See also:

Class rp_data