[ADO] Command vs RecordSet

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

[ADO] Command vs RecordSet

Logged in as: Guest

arrSession:exec spGetSession 2,2,62027

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> [ADO] Command vs RecordSet
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

[ADO] Command vs RecordSet - 6/30/2008 6:53:51 PM

djredmar

Posts: 61
Score: 0
Joined: 12/11/2006
From: Europe, The Netherlands
Status: offline

Hi,

I Can't find an real answer on www.w3schools.com/ado , but what is the difference between these objects?

Recordset does allow updates, but is command not?

Is recordset maybe faster because there are no updates possible?

Does command object allow to use insert / delete / update query's?

Post #: 1

RE: [ADO] Command vs RecordSet - 6/30/2008 10:28:23 PM

ehvbs

Posts: 2201
Score: 50
Joined: 6/22/2005
From: Germany
Status: offline

Hi djredmar,

a recordset is (a wrapper around) a collection of data (rows/records); a command is
(a wrapper around) a SQL statement. So they are completely different kind of
things. It makes no sense to compare them with regard to speed. A command
object may wrap/be a SQL Upadte/Delete/Insert statement (but you can use
a command object for Select statements too).

Regards

ehvbs

(in reply to djredmar)

Post #: 2

RE: [ADO] Command vs RecordSet - 6/30/2008 11:32:37 PM

djredmar

Posts: 61
Score: 0
Joined: 12/11/2006
From: Europe, The Netherlands
Status: offline

thanx!

So it's the most usefull to use an recordset.. wil do! thanks!

(in reply to ehvbs)

Post #: 3

RE: [ADO] Command vs RecordSet - 7/1/2008 12:14:45 AM

ehvbs

Posts: 2201
Score: 50
Joined: 6/22/2005
From: Germany
Status: offline

"So it's the most usefull to use an recordset" - that's like saying: comparing a car and
a driver, the car is more useful. You use a command to fill/create a recordset; they are
completely different things.

< Message edited by ehvbs -- 7/1/2008 12:15:48 AM >

(in reply to djredmar)

Post #: 4

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.

All Forums >> [Scripting] >> WSH & Client Side VBScript >> [ADO] Command vs RecordSet

Page: [1]

Jump to:

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts