3 Replies Latest reply on Dec 29, 2013 11:27 AM by davidanders

    ExecuteSQL in Script



      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 ?