Eduardo, > I add some information to my previous mail. When I try to delete the record > of MON$ATTACHMENTS, the complete message I got is the following: > > SQL ERROR CODE:-817 > > SQL ERROR MESSAGE: > The insert, update, delete, ddl or authorization statement cannot > be executed because the transaction is inquiry only
It seems that monitoring table functions do not allow for "read-only" attachments to be deleted/killed. Very interesting. 1- The fact that the "WITH LOCK" option was used makes what otherwise should be a simple SELECT statement much more significant, but the message suggest that read-only statements should be ignored (although supported WITH LOCK is very uncommon usage, so may not have been considered) 2- IMO, the functionality should allow for all/any attachment to be deleted. The purpose of the feature is to all such attachments to be managed in such a fashion -- there should be no restrictions. > Any other idea to unlock a record? Close have your application commit transaction or close your application. Sean
