>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