why can stored proc update multiple rows but trigger can't?

J

Joss

In a ADP (MSSQL7). I have been trying to create a trigger that would update
multiple rows on table 2 when table has a row updated. It doesn't wok - I
get the 'Key column information is insufficient or incorrect. Too many rows
affected by update' error. I tried for hours to get around it but no joy.
Then, I created a stored procedure to do the job and it works fine. The code
is the same, but no error and everything gets updated.

What's going on????

From this, I gues I can maybe call the stored proc from the trigger, but is
that the correct way?

Jo
 
L

Larry Linson

Regardless of the user interface you are using (ADP), questions about
Microsoft SQL Server stand a far better chance of getting useful responses
if asked in a newsgroup devoted to Microsoft SQL Server. Triggers and Stored
Procedures are SQL Server features.

Larry Linson
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.adp update query using 2 tables 7
returned row count when a trigger is invoked 6
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Using a stored proc in Access? 1
Update trigger works in SQL Server but NOT in Access adp datasheet 5
Referncing stored proc from a form 2
Using a stored proc as a forms recordsource 1
ADP Update Query does NOT update ! 3

Top