Reported By: Pedro Silva Reported On: 8/1/2002 For: Version 3.12 Build 1
# 1167Executing an SQL UPDATE Statement Can Cause a #10249 DBISAM_LOCKTIMEOUT Error This SQL worked fine in V3.07. I've upgraded to 3.12 and now it keeps on freezing for some minutes and then returning a lock failure.
with myquery do
sql.add('update process2 a1 set a1.codigo=603');
add('from process2 a1 left join pessoal a2 on
sql.add('where a1.codigo=604 and a2.vinculo in (1,2)');
Comments and WorkaroundsWorkaround is to start a manual transaction prior to executing the UPDATE statement and commiting it afterwards.
ResolutionFixed Problem on 8/2/2002 in version 3.13 build 1