AnsweredAssumed Answered

ExecuteSQL in Script

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

Title

ExecuteSQL in Script

Post

     Hi,

      

     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 ?

     Thanks

     Hans

      

Outcomes