April 14, 2003 at 4:48 am
Need a clarification on how insert trigger works in SQL Server.
When i insert a record from VB, the insert trigger fires. But does the VB connection wait till the trigger completes.
Paras Shah
Paras Shah
Evision Technologies
Mumbai, India
Paras Shah
Evision Technologies
Mumbai, India
April 14, 2003 at 4:55 am
Hi,
I don't think the VB app "knows" anything about the trigger.
This is SQL Server internal. So the connection will likely not wait till the trigger is finished. If you are running on errors, try to place a DoEvent statement in VB.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
April 14, 2003 at 5:45 am
Easy to test - just put a raiserror in the trigger, if VB receives the error message... Remember that the trigger is part of the transaction.
Andy
April 14, 2003 at 5:48 am
Hi Andy,
this assumes you're doing this within a transaction in vb, doesn't it?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply