Hi Peter,
>>Is your view updateable ?
>>Have u clicked on
Send SQL updates in the view designer ?
>>I did not understand what u are trying to do exactly.
>>
>>Reply me so I can help u.
>
>Yes to all of the above- in fact it's all SQL pass-through.
>
>The problem seems to be that most of the records are updated, but one or more are not. This in turn generates an error.
>
>Now this could be because of a primary key violation or some such thing, but I check for that or any error for that matter, and the error routine does not fire.
Using TableUpdate(
2) is supposed to update all possible and ignore errors. After the TableUpdate() if not all records were committed, you cannot change buffering because you still have uncommitted changes in the buffer. You can check for this with GetNetModified(). If you have uncommitted changes, you can TableRevert() them. Or try to fix the error that prevented the change. I had trouble with the
cErrorArray parameter in VFP5 and never tried it again in VFP6, so I loop through using GetNextModified() and a single record TableUpdate().
HTH,
Bill Armbrecht
VFP MCP