Message
From
20/06/2001 12:18:51
To
20/06/2001 12:08:59
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Primkey method
Miscellaneous
Thread ID:
00521525
Message ID:
00521530
Views:
15
>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.
>
>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
MCSD, Microsoft .Net MVP, Grape City Community Influencer