Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updatable view with many fields
Message
De
30/07/2002 11:01:13
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00682531
Message ID:
00683943
Vues:
31
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform