AnsweredAssumed Answered

Basic error on SELECT SUM??

Question asked by dab222 on Nov 4, 2018
Latest reply on Nov 10, 2018 by dab222

I am expecting the book "SQL for dummies" any day now but suddenly feel there may be a more basic book.  I have set this command


Set Field(Services::Summary;ExecureSQL("SELECT SUM (Price_Lookup) from Services";"";"")


Which returns a ? instead of a number


The Summary field is a number field in Services. The Price_lookup is a number field in Services. I guess this is telling me the format/query is wrong. Is there something obvious I am doing here.  As I said the book is on the way.