UtilColumnExists - cDbUpdateFunctionLibrary

To check if a field/column exists in a table definition.


Type: Function


Parameters: Handle hTable String sColumnName

Parameter

Description

hTable

The filelist number

sColumnName

The name of the field/column


Syntax


Function UtilColumnExists Handle hTable String sFieldName Returns Boolean

Call:

Get UtilColumnExists MyTable.File_Number "MyColumnName" to bOK



Description

Checks if a field/column name exists in a table definition. Returns True if it does.



Example


Procedure OnClick

    Boolean bOK 

   

    Get UtilColumnExists OrderHea.File_Number "Shipping_Date" to bOK

End_Procedure