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

    ExecuteSQL in Script

    HansHantson

      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