Knowledge Base Article
Article# A01045
Date 3/25/2002
Applies To CAR_PRO Version 2002.002
Status CLOSED
Description Unable to edit various Inventory records. Program just fails to save changes.
Symptoms After recalling an inventory record the end user makes changes to the record and clicks the 'OK' button but the changes to the record are not saved to the database. The problem occurs on random records and the following error were found in the error log... Error Block: 02-07-2002 14:52:03 Category User defined error Source CAR_PRO (local) Module CPBAS.BAS Procedure Sub DB_Save Line Number 140 Error No. 524 Description Couldn't update; currently locked by another session on this machine. Error Block: 02-07-2002 14:52:04 Error Block: 02-07-2002 14:52:04 Category User defined error Source CAR_PRO (local) Module InvEditor.frm Procedure Sub cmdDone_Click Line Number 21 Error No. 524 Description Couldn't update; currently locked by another session on this machine. Error Block: 02-07-2002 14:52:04 Error Block: 02-07-2002 14:52:05 Category ODBC Network error Source DAO.Recordset (remote) Module INFO.FRM Procedure Sub Save_Expenses Line Number 100 Error No. 3188 Description Couldn't update; currently locked by another session on this machine. Error Block: 02-07-2002 14:52:05 Error Block: 02-07-2002 14:52:05 Category Data Access error Source DAO.Field (remote) Module INFO.FRM Procedure Sub Save_Expenses Line Number 110 Error No. 3020 Description Update or CancelUpdate without AddNew or Edit. Error Block: 02-07-2002 14:52:05
Cause This problem was determined to be caused when the user double clicks the "Selected" column of the inventory grid list on the Inventory Records screen. By design the program will bring up a vehicle record by double clicking the grid but the grid was remaining in "Edit" mode before recalling the record. This was putting a lock on the record so any changes were being discarded when the user clicked the "Ok" button.
Solution The problem was fixed in version 2002.003b through code which takes the grid out of "Edit" mode when the end user double clicks on the grid. Download and install version 2002.003 or higher to fix the problem.