SQLStrSchemaFileFieldName - DataDictionary

Helper function that will create a string that that represents the SQL schema, 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 schema, table and column.


Syntax
Function SQLStrSchemaFileFieldName Integer iField Returns String

Call: Get SQLStrSchemaFileFieldName iField to StringVariable


Description

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

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

Sample

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