Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updatable view with many fields
Message
From
30/07/2002 11:01:13
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00682531
Message ID:
00683943
Views:
30
That seems to have been the problem....

There is a limit to 128 updatable fields in an updatable view. I am using Visual Fox Express and one of the BizObj methods was causing the Getfldstate problem.

Thanks to everyone for their help.

Randy

>In a view there is a limit of 128 updatable fields (yes this has been a request for the new version) the only thing that you can do is possibly split the view by functionality or even by page if you have them.
>I have run into this problem a few times, even when correctly normilised it sometimes happens. The sys(3055) and update key fields only will only help if the size of the view is large (ie long records and lots of them).
>with the getfldstate() = 2 this means the field has been edited or deleted.
>If you are just moving records i cant see why this would change unless you are forcing a tableupdate?
>
>Hope this helps
Randy Warfel MCP, CCNA, CNA
Previous
Reply
Map
View

Click here to load this message in the networking platform