Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Key differs between view & table
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00332312
Message ID:
00334369
Views:
28
>>I hope this helps,
>>Bill
>
>yes it does help thanks so much... sorry to be anal, but MMF is my bread & butter right now so I tend to pay closer attention when it comes to bugs in the framework :)

I ran into this a long time ago.

I removed Kevins Setfldstate from the framework, and put the newid function as default in all my updateable views as well as tables (explicitly adding parameter so newid does not have to guess which key to generate).

I use (as the framework reccomends and almost requires) buffering in all my views.

Since VFP does not call default values on an SQL insert -- you get an unchanged key from that called in the newid function. It does not try to generate it again.

I don't think stonefield affects this -- but since I am not currently using it I may I have missed this.
Thanks

Gar W. Lipow
Previous
Reply
Map
View

Click here to load this message in the networking platform