jbart
Oct 3rd, 2000, 09:27 AM
Hi guys,
Would appreciate any suggestions for the following problem.
I am using the recordset.UPDATE command to update several fields in a SQL Server table. One of the fields is used as a trigger on the Server. When that field is NOT commented out, the update does not work but also does not error out. When the field is commented out, the table update works with the other fields being updated correctly.
Also, if I try to update the field with a valid value that kicks off the trigger, the table does not get updated. If I update the field with a value that does not kick off the trigger, the table update works. But of course then the trigger is not activated.
I was originally using a client-side cursor. I changed to a server-side cursor and when the UPDATE command is executed, I get a run-time error with the message "Email Return Trigger Begins", and the program will not run past that point.
I have tried every combination of locks (adLockPessimistic, adLockOptimistic, etc.), but none allow me to update the field that is used as a trigger.
Not really sure what else to look for.
Any ideas ??
Thanks.
[Edited by jbart on 10-04-2000 at 07:37 AM]
Would appreciate any suggestions for the following problem.
I am using the recordset.UPDATE command to update several fields in a SQL Server table. One of the fields is used as a trigger on the Server. When that field is NOT commented out, the update does not work but also does not error out. When the field is commented out, the table update works with the other fields being updated correctly.
Also, if I try to update the field with a valid value that kicks off the trigger, the table does not get updated. If I update the field with a value that does not kick off the trigger, the table update works. But of course then the trigger is not activated.
I was originally using a client-side cursor. I changed to a server-side cursor and when the UPDATE command is executed, I get a run-time error with the message "Email Return Trigger Begins", and the program will not run past that point.
I have tried every combination of locks (adLockPessimistic, adLockOptimistic, etc.), but none allow me to update the field that is used as a trigger.
Not really sure what else to look for.
Any ideas ??
Thanks.
[Edited by jbart on 10-04-2000 at 07:37 AM]