Subject | cannot update erased record |
---|---|
Author | Chris Donges |
Post date | 2006-01-23T03:39:33Z |
I am getting the error cannot update erased record occasionly when
running this query on firebird 1.5 with the 1.0.0 JDBC driver:
"delete from vorder where vosession=? or
((vodatetime+1)<current_timestamp)"
The table vorder has a few thousand recodrs in it at any one time.
Does anybody know what this error means?
-----
CREATE TABLE VORDER (
VOKEY INTEGER NOT NULL,
VOSESSION CHAR(32),
VIKEY INTEGER,
VODATETIME TIMESTAMP default current_timestamp );
running this query on firebird 1.5 with the 1.0.0 JDBC driver:
"delete from vorder where vosession=? or
((vodatetime+1)<current_timestamp)"
The table vorder has a few thousand recodrs in it at any one time.
Does anybody know what this error means?
-----
CREATE TABLE VORDER (
VOKEY INTEGER NOT NULL,
VOSESSION CHAR(32),
VIKEY INTEGER,
VODATETIME TIMESTAMP default current_timestamp );