I create updatable SQL view. It's nessesary to all data be actual for other users so after all data update in view I execute tableupdate(). All works fine but when I insert row in view I have update confilct. I read in manual that at least 1 updatable field must be fillled - so I do this and it works - I fill this field, next tableupdate() - all works, but if I fill next (updatable) field and execute tableupdate() it returns .F. and when I close view I can se "update confict" 
I solve this problem by close and again open this view (after insert row and fill one field) - and next I can fill any fields I want (after update field I can execute tableupdate() etc)
But it's works very slowly... And I often see "attempting to lock..." when databases is shared...
Does anybody know how solve this problem ?
I solve this problem by close and again open this view (after insert row and fill one field) - and next I can fill any fields I want (after update field I can execute tableupdate() etc)
But it's works very slowly... And I often see "attempting to lock..." when databases is shared...
Does anybody know how solve this problem ?
