Broken transaction

Hi! Platform: Digital UNIX 3.0b OnLine : 5.05.UC1 4GL : 4.13.UD1 Pcode Version 8 Is there any condition, aside from an error in programming, which would cause half (or piece) of a transaction to occur and not the other, even when both (or all) commands are within the begin work/commit work block? Around the time this happens, I get the following messages in the error log for the user: SQL statement error number -271. Could not insert new row into the table. SYSTEM error number -154. ISAM error: Lock Timeout Expired According to the documentation, if the deadlock condition has exceeded the time specified by the tbconfig parameter DEADLOCK_TIMEOUT, then it is supposed to rollback the transaction and try again after a delay. What I'm experiencing is that the error is registered, and pieces of my transaction are not rolled back. Any ideas? Best regards, Nigel +-------------------------------------------------------------+ |Name : Edmund Nigel Gall Tel: (868) 636 3153 | |Title : Information Systems Specialist Fax: (868) 679 3770 | |Company: Process Plant Services Limited | |Address: Atlantic Avenue, Point Lisas Industrial Estate | | Point Lisas, Couva, Trinidad & Tobago, W.I. | +----- mailto:nigelg@ppsl.com ------ http://www.ppsl.com -----+