Subject | cannot update erased record |
---|---|
Author | Chris Donges |
Post date | 2006-01-23T02:34:14Z |
I am getting the error cannot update erased record occasionly when
running this query on firebird 1.5:
"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:
"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
);