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.

I deleted the Database and the tables. I created them back and I still have the problem. I validated the database and also compiled it again with no results. In VFP 5.0, I did not had this problem.

Anybody has an idea ?

Thank you,
Christian Cote