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.