>>No, you don't need to REQUERY the view before updating from it. Your problem lies elsewhere. In addition to Jim's advice, check to make sure that the view is set to updatable, a key field is specified, and the proper fields are marked as updatable.
>
>
>All of the fields are set in the view as updatable (even the primary key field), and when creating a new record things now insert kind of OK. However, if I edit a record, VFPODBC complains "uniqueness of primary key violated" when I know it hasn't been. It's like although I am doing a
When do you get this error? Do you mean when you select records from a table, edit them and TABLEUPDATE, or edit a record after you insert from an array?
Sorry to aks so many questions, but I am having trouble visualizing the situation.
Erik Moore
Clientelligence