I don't know you've the code:) What comes to mind is that * was used as a fieldlist and wrong table was referenced.
Cetin

>Hi,
>Thanks for your comments, we do drop & recreate the views, but I am at a loss to why the recreate dropped one field out of three on 2 of the sites.
>
>Any ideas?
>
>>>Hi,
>>>Is there a utility to check the sync of the DBC after doing a structural update. i.e. at a remote site.
>>>The reason being we recently completed Version upgrade of our clients, and 2 out of 500 sites didn't update 1 of 3 changes to an existing view, and no errors were reported during the update.
>>
>>Neil,
>>For views simply drop and recreate them in code. However each drop&add bloats the DBC (deletes old and adds new). A fresh new DBC and tables were our solution.
>>Cetin