>I am going to be using remote views against sql server data and desire to utilize the AS clause, ie Select "Field1" AS "FieldOne".
>
>Subsequently I will be updating the backend server data from this view. I am wondering if this will be problematic? That is to say, will the remote view negotiate the update to the original fieldname or attempt to update data on the backend using the fieldname desgnated by the AS clause?
>
You just need to make sure that the update name property of the view reflects the name of the field in the remote database. You can set this property using DBSETPROP, or more easily with eView. (you can get eView here in the files section).
Erik Moore
Clientelligence