2 Replies Latest reply on May 12, 2014 7:29 AM by beverly

    ExecuteSQL

      Hello,

       

      My primary keys and foreign keys are always named with a _ to have them sorted on top. _id , _idSIT

      Now I noticed that in the function ExecuteSQL this underscore gives me an ?

      Do I have to change my naming convention or is there another solution?

       

      Works :

      ExecuteSQL ( "SELECT SUM(TTC) FROM FAC WHERE idSIT = ? " ; "" ; ""; FAC::idSIT )

       

      Doesn't work :

      ExecuteSQL ( "SELECT SUM(TTC) FROM FAC WHERE _idSIT = ? " ; "" ; ""; FAC::_idSIT )