A
Andreas Wöckl
hi group!
i have the following problem using an insert trigger on a table with an
identity column as a primary key -> every time i add a value using my form i
get a message that the data can not get displayed -> I know there is the
problem that access is using the @@IDENTITY variable to get the value of the
primary key and with using a trigger this variable gets changed. My Question
is now which workaround can i take? - Is there a possibitity without
changing the pk column?
best regards
andreas wöckl
i have the following problem using an insert trigger on a table with an
identity column as a primary key -> every time i add a value using my form i
get a message that the data can not get displayed -> I know there is the
problem that access is using the @@IDENTITY variable to get the value of the
primary key and with using a trigger this variable gets changed. My Question
is now which workaround can i take? - Is there a possibitity without
changing the pk column?
best regards
andreas wöckl