AnsweredAssumed Answered

ExecuteSQL problem

Question asked by JasonO'Berry on May 24, 2013
Latest reply on May 27, 2013 by philmodjunk

Title

ExecuteSQL problem

Post

     Can anyone explain why this calculation wont work:

     ExecuteSQL ( 

      
     "SELECT sum (l.quantity)
     FROM lineitem AS l 
     Where l.fk_InvoiceNumber = ?
     AND l.frame <> ?  
     AND l.frame <> ?  
     AND l.size  =  ? 
      
     "
      

      

     ; ""; "" ;  INVOICE::pk_invoiceNumber  ;  "No Frame" ; "Rolled Canvas" ; "Small" ).
      
     It works until I enter the last and condition and its parameter. I just cant figure it out. Thanks.

Outcomes