Deleting a record from recordset
I am trying to delete a record from the recordset. I am using a transaction. After deleting a record & commiting I am getting the error - <A given HROW referred to a hard- or soft-deleted row.> - The record gets deleted from the database also. The delete works perfectly for some forms and is not working for some other forms.
Re: Deleting a record from recordset
maybe this is not the point, but try refreshing recordset after the delete
Special thanks to Lothar "the Great" Haensler, Tom Archer, Bruno Paris and all the other wonderful people who made and make Codeguru a great place. Come back soon, you Gurus.
Re: Deleting a record from recordset
Thanks for the reply.
As soon as I write recordset.delete, the AbsolutePosition and Bookmark of the recordset shows me the said error. I am using Requery method of the recordset but the control is not reaching there.
Thanks
Hitesh
Re: Deleting a record from recordset
after delete, before invoke absloute position, try
yourrecordest.refresh
Special thanks to Lothar "the Great" Haensler, Tom Archer, Bruno Paris and all the other wonderful people who made and make Codeguru a great place. Come back soon, you Gurus.