>>>>f.Joseph,
>>>> The 'Send SQL Updates' box is checked. All of the other tables update properly except for this one. Thanks for your reply though.
>>>>
>>>>George
>>>>>George,
>>>>> I have met such problem when i start study c/s,a remote view not
>>>>>update.
>>>>>But i found in remote view designer , "update criteria" tab, i don't select
>>>>>the "send SQL updates" check box.
>>>>> To be sure you are.
>>>>> I am sorry if it is not.
>>>>>
>>>>>f.joseph
>>>>>
>>>>>> I have a data entry screen with 4 remote views in the data environment.
>>>>>> When the user chooses save from the menu I call a method that I created
>>>>>> (fsave) that Inserts into each view from memvar. Then I execute a
>>>>>> tableupdate on each and test to see if the update worked.
>>>>>>
>>>>>> All tableupdates return .T. yet 1 of the views does not update. The
>>>>>others
>>>>>> work fine. I copied all of the form fields from the data entry screen and
>>>>>
>>>>>> placed them on a 'test' form. The updates from this work fine.
>>>>>>
>>>>>> All views are set up for optimistic row buffering (although I have tried
>>>>>> optimistic table buffering also) and all are views are updateable.
>>>>>>
>>>>>> Any ideas? I am at a standstill here.
>>>>>>
>>>>>> TIA,
>>>>>>
>>>>>> George
>>>>>>
>>>
>>>If the view that is not getting updated consists of more than one table, then you have to include the primary key fields of all tables in the field list.
>>>
>>>Another thing I can think of now is that maybe you are updating a field with NULL value that does not accept a NULL value, so I suggest you put a default value on almost all fields.
>>
>>Thanks for everyone's input. I never truly resolved this problem. Just for clarification, I was (am) checking the return value of the =tableupdate() function. It returns .t. every time. Just couldn't figure it out.
>>
>>I finally resolved this somehow by removing all of the tables from the data environment and re-adding them. Go figure, but for some reason this work.
>>
>>Signed,
>>A Confused George
>The problem may have been with the DBC. I occasionally get strange occurences after making changes. That is why I VERY REGULARLY select the "refresh" then "clean up database" and rebuild ( with recompile all options) my project

I'll give this a shot. Much to my chagrin the problem has started occurring again. I put the app into production and it seemed to work for a while. I come in this morning and that very same table is NOT updating even though all error checking says that it updated fine.

If anyone has any ideas I sure would appreciate it.

Thanks,

George