sql.getField ( fullyQualifiedFieldObject )

Returns the plain text FIELD NAME in a format suitable for an SQL query

Average rating: 1.0 (1 vote) Log in to vote

Cristos Lianides-Chin - Show more from this author
Codence
https://www.codence.com

Sample input:

sql.getField ( Customers::name )

Sample output:

"name"

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
    sql.getField ( fullyQualifiedFieldObject )
        - returns the plain text FIELD NAME in a format suitable for an SQL query
*/

Let ([
    ~field = fullyQualifiedFieldObject
;   ~fqFieldName = Case 
    (   GetFieldName ( ~field ) = "?" 
    ;       ~field
    ;   /* ELSE */ GetFieldName ( ~field )
    )
;   ~fieldNamePos0 = Position ( ~fqFieldName ; "::" ; 0 ; 1 ) + Length ( "::" )
;   ~fieldNamePos1 = Length ( ~fqFieldName )
;   ~fieldNameLength = ~fieldNamePos1 - ~fieldNamePos0 + Length ( "::" )
;   ~fieldName = Middle ( ~fqFieldName ; ~fieldNamePos0 ; ~fieldNameLength )
];
    "\"" & ~fieldName & "\""
)

Returns the plain text FIELD NAME in a format suitable for an SQL query.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

sql.getField ( fullyQualifiedFieldObject )

Comments

Support this website.

Support this website.