Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Making updateable local view, vfp 8
Message
De
15/12/2006 14:22:16
 
 
À
15/12/2006 13:56:30
Tim Muller
Innovative Solutions, Inc.
West New York, New Jersey, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01178095
Message ID:
01178099
Vues:
22
>I created a local, updateable View using the Query wizard/designer. No joining, just 1 table as the source. Ran GenDBC and grabbed the code. Deleted the View. Modified the SELECT from GenDBC so that the View had some "computed fields" (e.g., SPACE (10) AS FooBar). Made no other changes to the GenDBC code. Ran the modified GenDBC code to create the View I really wanted. Seemed to work (the grid using the View looked pretty, worked with my code in the Form and the Grid). Unfortunately, the original table is not getting the new values from the View.
>
>The View has optimistic buffering. I did a TABLEUPDATE on the View. Both the View and the original table are in the DataEnvironment.
>
>Any thoughts?
>
>Tim

Did you modify view and checked 'Send SQL Updates'? It's equivivalent to
DBSetProp('MyView', 'View', 'SendUpdates', .T.)
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform