>Remote views are driving me to drink!
>
>I have established a couple of remote views in a new application. They connect OK and fill up with the appropriate data when procedures run. Occasionally, I get update errors related to 'attempted to insert a primary key field' at silly times like at a GATHER MEMVAR or LOCATE command (this being before a TABLEUPDATE() is issued).
If your view is Row buffered (as opposed to table buffered) the contents are written to the source when the record pointer is moved. If you have specified your primary key field as updatable in the view definition, then moving the record pointer (as with a LOCATE) would cause this error.
Erik Moore
Clientelligence