General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2000
>>By the way as soon as the user selects Save, the Save button is disabled so the problem is not due to users pressing Save multiple times. Does anyone have any suggestions?
>
>
>What happens when you manually change the fields outside of your application? I would think that would be the best way to tell whether this is related to your trigger/SQL Server, or to the application.
>
>Can you consistantly re-create the problem?
If I change the values of the QPR fields by doing an Update using the SQL Query Analyzer or external code, the Trigger does not fire thus the QPRAudit table has no record of the modification to the original record.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only