>>>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.
>
>No problem. I need all the help I can get, sometimes explaining things just gets me going...
>
>I have a form with txtboxes based on a remote view of VFP data (no data on load). I click a "find" button and a modal form comes up for querying for a specific record. I go back to the main form, populating the remote view with the results of the find. Now I click in a txtbox and modify a field.
>When I click my 'save' button, the error is "index of CCUSTNO is violated".
>The code behind the 'save' button is:
> select CustUpdate
> tableupdate(2,.t.,'CustUpdate')
> use
> ThisForm.Refresh
>
have you chekced the value of the primary keyfield in the view just beforethe TABELUPDATE()?
Erik Moore
Clientelligence