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 |
|
cidr2
Starting Member
28 Posts |
 Posted - 2008-12-17 : 11:07:05
|
| Hi folks,I've been working on an Audit trail whereby I've created some tables to add the audit info to and I've created triggers on the host tables:CREATE TRIGGER tr_Milestone1_Insert ON Milestones.msdbMilestone1FOR INSERT AS BEGINSET NOCOUNT ONINSERT INTO sysMSDBMilestone( MilestoneID, DeliverDate, MilestoneDetailID, AuditAction)SELECT MilestoneID, DeliverDate, MilestoneDetaiID1, 'I' FROM InsertedENDWhen I add this trigger to my table and then add info via the frontend (InfoPath) form I get this message:InfoPath cannot submit the form.An error occurred while the form was being submitted.[0x80004005][Microsoft Cursor Engine] Empty row cannot be inserted. Row must have at least one column value set.This could be an InfoPath problem because when I add info to the host table directly from the db it adds the audit info to the audit table no problem, however, I just wanted to make sure I'm not doing anything wrong.Can anyone shed light on this?Thanks again for any help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
cidr2
Starting Member
28 Posts |
Posted - 2008-12-18 : 09:47:20
|
| Thanks for your reply visakh16. There isn't any VB in the app, however, it has become apparnet that this is a generic message for quite a few things.There is a message that comes up before the error message******ADO Security WarningThis website is using your identity to access...******I think this is because I haven't set the website as full trust. the info still goes into the database but not into the Audit trail. I'll let you know how I get on when I've sorted this out with the IT dept.Thanks |
 |
|
|
|
|
|
Audit Trail Error