FieldLengthCheck

Structure

FieldLengthCheck(sTable, sField, sValue: String): String

Type

Function

Description

This function checks the length of a value (sValue, parameter 3) against a particular table/field combination in the database. If the length of the value exceeds the number of characters allowed in the table/field then function fails.

Parameters: 3

sTable = Table Name

sField = Field Name

sValue = Value

Return

Returns '1' if the value will fit in the table/field, '0' if not.

Example:

if not FieldLengthCheck("GAGES", "USER1", LookupEventFieldText("EVENT_COMMENT")) then

ShowMessage("Value too long")

End If |