>HI,
>I have a table that keeps track of my latest primary keys. I made a function in the stored procedure called NewId. In the View Designer, under field properties, I have this in the default value of my primary key field :
>
>NewId('MyField')
>
>Then I Issue :
>INSERT INTO MyView(field1, field2...) VALUES(value1, value2...)
>
>If I BROWSE the view, everything is OK. But when I Issue =TableUpdate(.T.) - I use table buffering - it fails, telling me error 1884. But when I use APPEND BLANK IN MyView and issuing =TABLEUPDATE(.T.), I do not get this error at all.
>
Have you verified that your stored procedure is working? IOW, what are the values of the pk field before you issue a TABLEUPDATE()?
Erik Moore
Clientelligence