Scalar vs Reader Exec Method

Hi

Is there any advantage of using scalar execution method for data adapter if
the result is going to be a single record?

Thanks

Regards

Scalar only gives you back the first field from the first record, so if you
want the whole record, don't use scalar.

Scalar is generally good for when you are calling a user function in the DB
to get back a single result.

-Scott


"John" <info@nospam.infovis.co.uk> wrote in message
news:O6C3tM8rIHA.4376@TK2MSFTNGP06.phx.gbl...
> Hi
>
> Is there any advantage of using scalar execution method for data adapter
> if the result is going to be a single record?
>
> Thanks
>
> Regards
>