>>Hi,
>>
>>I found a trigger in the SQL Server (the application is VFP 9 and using SQL Server database) in one of the tables. The trigger is TABLE_NAME_DELETE. I use CursorAdapter for inserting/updating/deleting records in the SQL Server.
>>My questions:
>>1. When I issue DELETE to the row in the CursorAdapter cursor and then TableUpdate(), does SQL Server fire this Trigger?
>
>
Yes, SQL Server fires the trigger.>
>>2. If the question to 1 is NO, I will delete the trigger. But if it is Yes, how do I check this? That is, how do I run the VFP 9 and see that the trigger in SQL Server was fired?
>
>
Just change the trigger to return error and see what is happeningThank you!
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham