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: Integer iField

ParameterDescription
iFieldTable column to create string for


Return Value

Formatted string representing the SQL table and column.


Syntax
Function SQLStrFileFieldName Integer iField Returns String

Call: 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