AnsweredAssumed Answered

ExecuteSQL

Question asked by disabled_xaviervb on May 12, 2014
Latest reply on May 12, 2014 by beverly

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 )

Outcomes