REcord/key deleted

[Luis Castillo]

Amigos.....

Me sale este error RECORD/KEY deleted...

Sale cuando hago table.insert.


que significa...

[vtdeleon]

Saludos

Nunca había visto ese error y no dices que DB usas, pero buscando en google encontre esto:
http://info.borland.com/devsupport/b...interbase.html

Problem:

Given just the right table structure, you can
incorrectly get the error "Record/Key Deleted". The
problem has to do with BLOb fields having or not
having data in them and violating a primary key
constraint. Please read steps for explanation.

Steps:

1) Create a table with this SQL statment:
CREATE TABLE T_TEST (
TN_NUMBER INTEGER NOT NULL PRIMARY
KEY,
TEXT_VERSION BLOB SUB_TYPE TEXT)

NOTE: records were added using the data tab
when the above table was selected (not a SQL
intert statment)
....

http://www.delphi32.com/info_facts/tips/revertrec.asp

Reverting a record
When you want to revert a record in a cached updates table to its original state (state when the table was open) by using the DataSet.RevertRecord method, you must include, at least, rtUnmodified in DataSet.UpdateRecordTypes property set. If not you will get an 'Record/Key deleted' exception. The reason for this is that when you do RevertRecord that record becomes Unmodified