AnsweredAssumed Answered

ExecuteSQL in Script

Question asked by HansHantson on Dec 28, 2013
Latest reply on Dec 29, 2013 by davidanders


ExecuteSQL in Script




     I'm trying to calculate some results on a few tables and display this info on the main screen. As this is all new to me, i create a script and added the following info into it

     Set Variable[$$TotalRecords; Value:Get (FoundCount)]

     Set Variable{$$TotalValue; Value:ExecuteSQL ( "SELECT SUM(IncomingInvoices::AmountExVAT) FROM IncomingInvoices" ; ":" ; ":" ))


     The first one is going fine, but the second is responding in ?

     Any idea what i'm doing wrong ?