AnsweredAssumed Answered

Using executeSql to search for strings containing periods

Question asked by Malcolm on Mar 23, 2017
Latest reply on Mar 23, 2017 by philmodjunk

I'm having trouble handling a search string that contains a period. This is my code, it returns "The column named "Full.Name" does not exist in any table in the column reference's scope." Can someone put me on the right track please?

 

Let ( [

; searchFld = cf_SQL_FieldName ( GetFieldName (  EMP::Account Name ) )

; TBL = cf_SQL_TableName ( GetFieldName (  EMP::id ) )

; dataFld = cf_SQL_FieldName ( GetFieldName (  EMP::id ) )

 

; sqlQuery = "SELECT " & dataFld & " from " & TBL & " WHERE " & searchFld & "=" & Quote( "Full.Name") // get(accountName) )

 

];

 

"" // AccountID = ExecuteSQL ( sqlQuery ; "" ; ¶  )

 

)

 

 

 

malcolm

Outcomes