RE: Freeze on UPDATE, but only from DBI

[Wilson, Doug]

> my $sth = DBH()->prepare( "UPDATE ldb_ad_t SET 
> most_recent_print_date =
> '30-SEP-01' WHERE lid = 2" );
> $sth->execute();

How big is the table? Is it just not using an index?
Are you sure you're accessing the database/table you think you are and
is there an index on 'lid'?

Are you connecting using RaiseError? If not, then you're not
currently checking the status of the DBI statements.

Try putting the entire SQL statement on one line just for kicks??

Cheers,
Douglas Wilson