>Hello,
>
>I try to create primary keys using an INSERT trigger in the table which calls a PRG (or a stored procedure). However, issueing REPLACE MyKeyField WITH lnNewValue generates an error message: "Cannot update the cursor".
>
>How is it possible to use a table Insert trigger to update a primary key?
>
>Thanks for your help in advance!
Look at the Primary Key article on my web site.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer