From: Masaki Suketa <masaki.suketa@...>
Date: 2005-04-10T10:40:55+09:00
Subject: Re: win32ole VARIANT limitations?

In message "win32ole VARIANT limitations?"
    on 05/04/06, "imap" <jfc@segonet.com> writes:

> @con = WIN32OLE.new('ADODB.Connection')
> @con.open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=#{ruta};") May be
> like with perl:
> 	@rs =@con.OpenSchema(4, [nil,nil,"tab00200"])---> error I try too:
> 	@rs =@con._invoke(@con.ole_method('OpenSchema').dispid,
> 		[4, [nil,nil,"tab00200"]],
> 		[VT_UI2, VT_ARRAY|VT_VARIANT]
> 		)
> Error too...
> I don't know if it's posible to do this!!

The current Win32OLE converts nil to VT_ERROR of OLE.
But OpenSchema expects VT_EMPTY and the current version does not support 
the way to converting nil to VT_EMPTY.

The next version of Win32OLE retry with converting nil
to VT_EMPTY if failed to invoke with converting nil to VT_ERROR.

So, the following script will work fine in the next release.
  @rs = @con.OpenSchema(4, [nil, nil, "tab00200"])

  Regards,
  Masaki Suketa