RELEASE statement

[Kladkul]

Found a rather odd error today. It seems that putting a RELEASE statement after a DELETE statement keep it from actually deleting the record?

Could anyone maybe elaborate on this?

Thanks!

 

[tamhas]

I can't say that I've ever tried that, since it doesn't make much sense, but if the RELEASE is within the scope of the transaction, you are letting go of the buffer to be deleted before the transaction ends, so it is a little hard to delete it, isn't it. The actual deletion wouldn't finalize until the transaction ends, so you want to make sure the DELETE is in a tightly scoped block.