Using the previous version of Win32::OLE and the following query I get the
listed results:
C:\DevStudio\MyProjects\perl\dBD-ado-0.19>perl -MWin32::OLE -e "print
$Win32::OL
E::VERSION"
0.1101

use Win32::OLE; 
use Win32::OLE::Const( "Microsoft ActiveX Data Objects 2\\.0 Library" );
use Data::Dumper;

$Conn = Win32::OLE->new( "ADODB.Connection" ) or 
        die Win32::OLE->LastError();

$Conn->Open("File Name=mssql.udl");
print "Test connection $c\n";
$oRec = $Conn->OpenSchema(adSchemaTables);
while(! $oRec->{EOF}) {
            my $c = $oRec->Fields->{Count};
            for (my $i = 0; $i < $c; $i++) {
                print "Field ", $oRec->Fields($i)->{Name},
                        "=", ($oRec->Fields($i)->{Value} || "undef"), "\n";
            }
        $oRec->MoveNext;
}
$Conn->Close;
exit;

Field TABLE_CATALOG=pubs
...
Field DATE_CREATED=11/13/98 3:11:04 AM
Field DATE_MODIFIED=undef

However, after upgrading Win32::OLE to version 0.12 this script now
presents:

Field TABLE_CATALOG=pubs
...
Field DATE_CREATED=Win32::OLE::Variant=SCALAR(0x9302920)
Field DATE_MODIFIED=undef

When I modify the script to include:
use Win32::OLE::Variant;
The results return the date correctly formatted.
Field DATE_CREATED=11/13/98 3:11:04 AM Type 7

Is this the desired affects or a bug?

Tom

---
You are currently subscribed to perl-win32-users as: [archive@jab.org]
To unsubscribe, forward this message to
         [EMAIL PROTECTED]
For non-automated Mailing List support, send email to  
         [EMAIL PROTECTED]

Reply via email to