Icon View Incident Report

Serious Serious
Reported By: Lawrence Lustig
Reported On: 3/15/1999
For: Version 1.13 Build 1
# 357 Trying to do a Lookup While a Transaction is Active Causes a Lock Timeout

The following command is locking up my system:

RefAttorneyDisburseID := dmLookUps.tblDisburse.LookUp('PaymentID;AttorneyID',VarArrayOf([tblDisbursementsPaymentID.Value, RefAttorney]),'DisburseID');

tblDisburse in dmLookUps and tblDisbursements on the current form both point to the same physical table. This command is being given from inside a transaction in which a record has already been added to the tblDisbursements (in fact, it's the record that should match the lookup).

Comments Comments and Workarounds
Customer indicated a lockup occurred, but actually a lock timeout will occur after a minute or so.

Resolution Resolution
Fixed Problem on 3/15/1999 in version 0.00 build 1