updating fields in MS Access

[katharnakh]

hi,

I am having problem in updating tables in MS Access. The field which I
want to update is of DATE type.

here is the code..

#! C:\Perl\bin\perl.exe

use Win32::ODBC;

my $db = new Win32::ODBC('ServerStatistics');

$q="select distinct(build_date) from wdf_history";
$db->Sql($q);
while($db->FetchRow)
{
        $s = $db->Data();
        print $s;

}

$q = "select * from wdf_history where build_date='$s'";

while($db->FetchRow)
{
        $s = $db->Data();
        print $s;

}

$q="update wdf_history set build_date='2007-02-27' where
build_date='$s'";
$db->Sql($q);

$q = "select * from wdf_history where build_date='$s'";

while($db->FetchRow)
{
        $s = $db->Data();
        print $s;

}

This does not get updated. Why? what I should do??

Thank you,
Regards,
kath.