🚀 go-pugleaf

Return data into ADODataSet and get result as

ADODataSet1->Fields[0]->Value (or AsInteger).

Do not connect this ADODataSet to DBGrid.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Heinz Ketchup" <heinz_like_the_ketchup@n0spam.h0tmail.c0m> �������/��������
� �������� ���������: news:40c90d84$1@newsgroups.borland.com...
> 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
>
>