General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem with view designer (VFP6 SP3)
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only