Devart Forums

Hi!

I have a trigger on a Table1. In this trigger is a
SET NOCOUNT ON;
raiserror ('Problem with Trigger',16,1)
rows too.

By posting an insert into Table1 with TMSquery, displayed this errormassage, but after this I become "Not in cached update mode" too.

Why?

TMSQuery property CachedUpdates=false; I will not use CachedUpdates mode.

THX
Blg

Platform
Delphi 7
SQL Server 2005
SDAC 4.35

I could not reproduce the problem.
Please send me a complete small sample at sdac*crlab*com to demonstrate it, including script to create the table with the trigger.

Also supply me the following information:
- exact version of SDAC. You can see it in the About sheet of TMSConnection Editor;
- exact version of SQL server and client. You can see it in the Info sheet of TMSConnection Editor.

Sorry. The Application has an exception handling too.
It was my fault.