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

sTable = Table Name

sField = Field Name

sValue = Value

Return value

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