INSTEAD OF TRIGGER to DELETE error


A

AlwaysOnTime

Need some help for my first SQL database.

I have an MDB front end linked to SQL EXPRESS tables. It has an INSTEAD OF
TRIGGER tied to a view to delete a specific row in a table when that row is
selected in a view. The view is based on 2 joined tables, the one with the
primary key is the table contains the row I want to delete.

My trigger is very basic : Delete from table1 where @var= deleted.var

When I delete the row, I get the message :
No rows were deleted....
The transaction ended in the trigger. The batch has been aborted.
Record deleted.

The row is actually deleted properly, but the error message always shows up.
How can I fix this?

Second question: After I delete a row, how can I refresh the query so that
the deleted records do not show up in the form.

Thank you.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top