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.
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.