🚀 go-pugleaf

Thanks a lot V.V.

It worked perfectly!

Heinz


"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:40c98277$1@newsgroups.borland.com...
> 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
> >
> >
>
>