1 Reply Latest reply on Feb 11, 2013 8:23 AM by philmodjunk

    Execute SQL and field names starting with _  (underscore)

    gcatnine

      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