Icon View Incident Report

Serious Serious
Reported By: Michael Haralabos
Reported On: 4/25/2002
For: Version 3.10 Build 1
# 1111 Trying to Edit a Deleted Record Using Optimistic Locking Results in an #8709 No Current Record Error

- Optimistic Locking Bug -
(Set your DBSys First)

1) Open DBSys
2) Open any Table
3) Write a new record into the table and post it
4) Open a SQL Query
5) Using SQL delete the record you've just inserted
into the table. Like:

delete from mytable
where recordid in (37)

6) Run the Query
7) Go into the open table Window and "Edit" the
record

#8709 error should Occur


Comments Comments
This error only occurs if there is only one record in the table before executing the SQL DELETE statement.


Resolution Resolution
Fixed Problem on 4/28/2002 in version 3.11 build 1
Image