Win32ole - AffectedRows example?

Hi,

can anyone help me out with a working example on how to return
AffectedRows in an insert or update query using Win23ole and ADODB?

I can't seem to go anywhere with this.

Thank you very much!

Lutz

···

--
Posted via http://www.ruby-forum.com/.

I've just been doing some stuff with win32ole. First thing I'd recommend is upgrading to 1.9.1-p430, or 1.9.2 (although we had some crashes with 1.9.2).

···

________________________________________
From: Lutz Mueller [lmuellerhome@gmail.com]
Sent: 10 November 2010 05:26
To: ruby-talk ML
Subject: Win32ole - AffectedRows example?

Hi,

can anyone help me out with a working example on how to return
AffectedRows in an insert or update query using Win23ole and ADODB?

I can't seem to go anywhere with this.

Thank you very much!

Lutz

--
Posted via http://www.ruby-forum.com/.

On Wed, 10 Nov 2010 00:26:13 -0500, Lutz Mueller
<lmuellerhome@gmail.com> wrote in
<2e7c62314df8055e5b172eb68723ddb2@ruby-forum.com>:

can anyone help me out with a working example on how to return
AffectedRows in an insert or update query using Win23ole and ADODB?

I can't seem to go anywhere with this.

Is the problem that you don't know how to use the ADODB library, or
that you don't know what the syntax should be in Ruby?

···

--
Charles Calvert | Software Design/Development
Celtic Wolf, Inc. | Project Management
http://www.celticwolf.com/ | Technical Writing
(703) 580-0210 | Research

Charles Calvert wrote in post #961014:

Is the problem that you don't know how to use the ADODB library, or
that you don't know what the syntax should be in Ruby?

It appears that, when retrieving the results of an insert or update
query, I am getting 0 back in every case, whereas the same thing done in
Office/VBA yields the expected result(s).

I have an example here:

···

--
Posted via http://www.ruby-forum.com/\.