Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-17 : 19:10:27
|
Steve writes "I have a table with insert, update and delete triggers on it. These triggers work fine when rows are added etc from the Query Analyzer and SQL Server Enterprise Manager, my problems arise whenever I try to insert rows using Visual Basic.
I have used an ADODB.connection object, using the execute method with an insert statement, and also an ADODB.recordset object and the addnew method, but I can get neither of these to work.
Both work fine if I comment out the code of the triggers, but fail to insert when the triggers are functional.
I have carried out several tests using the QA, performing exactly the same inserts that the VB code is attempting, but I cannot find any problems in the triggers themselves - has anyone else had similar problems?
The general purpose of the trigger is to check if an ID in the inserted/updated/deleted row(s) appears in another table, and if so insert or update a record with an ID taken from this second table in addition to the added record." |
|
|
|
|
|
Trigger problems using VB