Hi,

We are having a session where the table is updated based on the entry & a mail is forwarded to concerned person based on the record.
The problem is in some cases the record is not getting updated but the mail is transferred. No further actions can be done on that record, it can't be deleted.
While trying to delete its giving some eroor like table record is locked.
For this i am restatring the DB, the records will be deleted & the user has to enter again.
Can anyone guide me to find the root cause of the issue?
The mail server we are using is Novell groupwise.

Thanking you in advance.

Hi Preethi,
While sending the mail, ensure that the table is updated properly using the return value for db.update() or db.insert(). Only if the return value is 0, then call the function to send the mail.

Regards,
Amit

r u using for update for updating(Select x.* from x for update ) or cud u plss post your code ..

Yep - sounds more like a coding problem. The code would probably help, but amit's suggestion is probably close to the answer. Just validate that the record is updated before sending the email.

Hi Preethi,
While sending the mail, ensure that the table is updated properly using the return value for db.update() or db.insert(). Only if the return value is 0, then call the function to send the mail.

Regards,
Amit

thank you Amit..i modified the code to send mail after db.update