Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Making updateable local view, vfp 8
Message
 
À
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:
01178159
Vues:
15
>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

Try making the tableupdate statement look something like this:

llTableUpdate = TableUpdate(.T., .T., 'myViewName', laErrorArray)

This forces the update. if llTableUpdate returns a .F. you can look in laErrorArray and *hopefully* see what the problem is.
ICQ 10556 (ya), 254117
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform