Skip to content

SQLStrFileFieldName - DataDictionary

Helper function that returns a string representing the SQL table and column in a format that can be used by an SQL WHERE clause

Type: Function
Return Data Type: String

Parameters

Parameter Type Description
iField Integer Table column to create string for

Syntax

Function SQLStrFileFieldName Integer iField Returns String

Call Example

Get SQLStrFileFieldName iField to StringVariable

Description

This is a helper function that returns a string representing the SQL table and column in a format that can be used by an SQL WHERE clause.

It bases the table name on the SQL table name, which may be different than the DataFlex logical name.

Sample

Get SQLStrFileFieldName (RefTable(Customer.Name)) to sFilter

Return Value

Formatted string representing the SQL table and column.