in reply to Handling returned data from a OLE object.

Win32::OLE objects are strange.. I think they use a combination of properties/methods which are the same, which confuses you if you look at the Data::Dumper output. In other words, even though "Item" looks like a property, it's really a method.

To get data back from the recordset, you do this:

while (! $Obj->{EOF}) { print $Obj->fields("FieldOne")->{Value}, "\n"; print $Obj->fields("FieldTwo")->{Value}, "\n"; print $Obj->fields("FieldThree")->{Value}, "\n"; $Obj->MoveNext(); }

Replies are listed 'Best First'.
Re: Re: Handling returned data from a OLE object.
by Anonymous Monk on Feb 20, 2003 at 18:41 UTC
    Thanks alot you're right Item was a method and :
    print $Obj->Fields->Item(0)->Value, "\n";

    gave me the data. thanks again.