hi Jay

but then i have to switch between set deleted on/off. that looked to me like too much hassle. plus a seek alone woun't work, because you might come back with the record just added, so you need to do a check aginst the record which was added. in the app i am working on currently records are beeing deleted by the users all the time. for this specific situation mostly out of stupidity from the user. because later they remember "duh, i needed that entry after all..."

>This is easily resolved by SEEKing on the index expression of the candidate key and doing an UPDATE/REPLACE rather than an INSERT.
>
>Jay