September 24, 2005 at 8:48 am
Hello,
at first - excuse my bad english, but nevertheless i have a problem. 😉 I hope you can help me...
I have a trigger on one table for the insert command. this trigger inserts a record into another table. it works fine for the second table...
CREATE TRIGGER NeuBugtracking ON [dbo].[ProjekteBugtrackingT]
FOR INSERT
AS
INSERT INTO ProjekteBugtrackingTexteT (BugZahl)
SELECT (bugid) FROM Inserted
the problem is that the identity for the first table will not be generated immeadetly...through this specific conduct im getting error messages in the front end app (access 2003). the same happens if i try this in em. the record is updated correct but i can not edit it again till i load the entire recordset again -> wrong identity information.
do you have any idea?
best regards
andreas
September 24, 2005 at 9:05 am
andreas - I'm not sure I understand the question - when you insert a new row into your "ProjekteBugtrackingT" table, are you saying that a new "bugID" is not created ?!
What is the DDL of your "ProjekteBugtrackingT" table ?! Is your "bugID" a primary key - is it an identity column ?! If you provide the DDL & some more details, it would help!
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply