Reported By: Michael Haralabos Reported On: 4/25/2002 For: Version 3.10 Build 1
# 1111Trying 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
CommentsThis error only occurs if there is only one record in the table before executing the SQL DELETE statement.
ResolutionFixed Problem on 4/28/2002 in version 3.11 build 1