Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with view designer (VFP6 SP3)
Message
From
11/07/1999 22:13:01
 
 
To
11/07/1999 13:23:09
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00239960
Message ID:
00240026
Views:
25
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform