VFP9: Trouble updating view

Hello,

I have two views, both utilizing the same table. The views are simple and
based on a single common table. The only difference between the two views
are the filter parameters. All the proper PK and update fields have been
checked in the view builder. Both these views reside in the same form data
environment. Both views use default table buffering. The trouble starts
when I save changes to an exsisting record, it requires that I save the
changes twice before the base table recieves the update.

I'm stumped!

John

Anders
Sun Sep 23 15:14:05 PDT 2007

you haven't buffered the base table too, have you?
-Anders

"John Dandy" <jdandy@hotmail.com> wrote in message
news:mpCdnaHFdr6XVWvbnZ2dnUVZ_tqtnZ2d@giganews.com...
> Hello,
>
> I have two views, both utilizing the same table. The views are simple and
> based on a single common table. The only difference between the two views
> are the filter parameters. All the proper PK and update fields have been
> checked in the view builder. Both these views reside in the same form
> data environment. Both views use default table buffering. The trouble
> starts when I save changes to an exsisting record, it requires that I save
> the changes twice before the base table recieves the update.
>
> I'm stumped!
>
> John
>

John
Mon Sep 24 18:30:24 PDT 2007

Anders,

You're a genius!

That was it; the base table was buffered when it does not need to be. Now
that it's turned off, the update works perfect!



John

"Anders Altberg" <anders.altberg> wrote in message
news:uB6e6dj$HHA.4584@TK2MSFTNGP03.phx.gbl...
> you haven't buffered the base table too, have you?
> -Anders
>
> "John Dandy" <jdandy@hotmail.com> wrote in message
> news:mpCdnaHFdr6XVWvbnZ2dnUVZ_tqtnZ2d@giganews.com...
>> Hello,
>>
>> I have two views, both utilizing the same table. The views are simple
>> and based on a single common table. The only difference between the two
>> views are the filter parameters. All the proper PK and update fields
>> have been checked in the view builder. Both these views reside in the
>> same form data environment. Both views use default table buffering. The
>> trouble starts when I save changes to an exsisting record, it requires
>> that I save the changes twice before the base table recieves the update.
>>
>> I'm stumped!
>>
>> John
>>
>
>