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.
|
|