Returns true if the passed in value is valid for the passed in field name (Public)

o.isvalid( tcValue, tcField, tcFilter)

Return Value

True or False

Parameters

tcValue
The value you need validated

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 if a value occurs in a table where the value is not a
PK field. For instance determining if an account number is valid and active. If it is valid the method
will also place the record into o.oData automatically

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.IsValid("12333","Account","Status = 'A'")

The above would return true if account number "12333" existed and the value of the status field was "A"

See also:

Class rp_data