I keep all sorts of EDB errors when running the following query and I'm at my wits end. Can anyone see or suggest what might be wrong. All I want to do is get the total of the Value field in the orders table. Thanks.
with Query1 do begin
with SQL do begin
Add ('SELECT Sum (Value) FROM Orders');