AnsweredAssumed Answered

Execute SQL and field names starting with _  (underscore)

Question asked by gcatnine on Feb 11, 2013
Latest reply on Feb 11, 2013 by philmodjunk

Title

Execute SQL and field names starting with _  (underscore)

Post

     I spent a lot of time understanding why a simple ExecuteSQL did not work.

     At the end the reason was quite simple: it does not like field that start with _ (underscore)

     Solving this issue is quite simple: just escape with “ (quote):

     ExecuteSQL (“

     SELECT filed_to_be_selected

     FROM table

     WHERE \”_kp_keyfield\” = ? "; “” ; “”; filed_or_value_to_compare)

      

     Hope you do not spend time like me

Outcomes