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
TMSQuery "Not in cached update mode" by useing raiserror in stored proc
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.
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.