PC Review


Reply
Thread Tools Rate Thread

Scalar vs Reader Exec Method

 
 
John
Guest
Posts: n/a
 
      6th May 2008
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


 
Reply With Quote
 
 
 
 
Scott M.
Guest
Posts: n/a
 
      7th May 2008
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
calling a scalar function in sql from vb Rayne Microsoft VB .NET 0 17th Sep 2007 11:44 PM
SCALAR LENGTH VALUE =?Utf-8?B?bWps?= Microsoft Access Queries 1 14th Dec 2003 07:21 AM
Execute Scalar Mike P Microsoft C# .NET 3 20th Oct 2003 08:56 PM
ReturnValue of Scalar UDF JT Microsoft ADO .NET 0 22nd Sep 2003 07:53 PM
Re: Scalar value from datatable Tim Marsden Microsoft ADO .NET 1 30th Jul 2003 06:09 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:15 AM.