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

Parameter	Type	Description
iField	Integer	Table column to create string for

Syntax

Function SQLStrSchemaFileFieldName Integer iField Returns String

Call Example

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

Return Value

Formatted string representing the SQL schema, table and column.