Win32ole - AffectedRows example?

Ruby
1

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

2

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 [[email protected]]
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

3

On Wed, 10 Nov 2010 00:26:13 -0500, Lutz Mueller
[email protected] wrote in
[email protected]:

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?

4

Charles C. 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:

http://www.ruby-forum.com/topic/218052