Jeff,
Are you using table buffering on the local table or on a view of the local table?
>Colin,
>
>This works for me using Table Buffering and Local tables. I have not tried
>this on Remote tables. I would think it would work the same way for remote
>tables.
>
>>Hi Jeff,
>>
>>I tried something similar to this already and always got back all 1's when issuing GETFLDSTATE(-1) against the base table even when it was modified. Also, AFAIK, I can't detect line items APPENDed with this.
>>Are you sure this works? Maybe I was doing something wrong.
>>
>>Thanx
>>
>>>Colin,
>>>
>>>Try the following.
>>>
>>>IF GETFLDSTATE(-1,"curtable") <> REPLICATE("1",LEN(GETFLDSTATE(-1,"parentview")))
>>> ll_updated=TABLEUPDATE(0,.T.,"parentview")
>>> if ll_updated
>>> =tableupdate(1,.t.,"clildview")
>>> else
>>> **** the record has change do not allow user to save
>>> endif
>>>ENDIF
>>>
>>>The getfldstate checks to see if the base table has changed since
>>>you started using the record.
>>>
>>>I think this will work for remote views also.
>>>
>>>Hope this helps
>>>
>>>Jeff Whitaker
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.