Re^4: Extracting data from an Ms ACCESS query

in reply to Re^3: Extracting data from an Ms ACCESS query
in thread Extracting data from an Ms ACCESS query

have you read the documents Win32::ODBC?

As has already been said, it's $dbh->Sql($statement) not $dbh->sql() and it does not return an arrayref... it returns undef upon success!

$sql="select * from foo";
if($db->Sql($sql)) {
    warn "i failed: " . $db->Error();
}else{
    print "read the documentation on FetchRow(), Data() and DataHash()
+\n"; 
}
[download]

HTH - Mark

In Section Seekers of Perl Wisdom