🚀 go-pugleaf

Thanks everyone for your help!
I have definitely learned quite a bit.

Is it possible to make use of SQL Functions?
Min / Max / Sum / Count / Average?

Whenever you make a call (ExecSQL / Open)
It returns Data usually to a DBGrid / Table
What if we just want to message box the results?
or
Store it in a variable for something else?

Should I even consider trying to use a TDecisionCube?
It appears to make use of some of the SQL Functions
I need.
Min / Max / Sum / Count / Average.

<example of some of the things I've tried / didn't work>
SELECT COUNT(*)
FROM TableName
INTO :COUNTERVARIABLE

SomeVariant = ....->ParamByName("COUNTERVARIABLE")->Value;

Anything to assign a value to a variable would be really nice.
I can always do it the hardway, which is to code in functions, but that
defeats the purpose of SQL Functions.

PS: The only one that currently works in respect to COUNT is ->RecordCount
(But that is only after a Dataset has been opened on a query)

Hopefully, these are all the questions I'll need to ask.
***Hopefully***


Thanks for the help everyone.
It really has been great.

Heinz