http://qs1969.pair.com?node_id=363396


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

Hi, blackadder

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"; }

HTH - Mark