Buffermode of view is 5

The view is not readonly

My Tableupdate command is TABLEUPDATE(1,.T.,'vwparcelas'). But I have tried your suggestion llTableUpdate = TableUpdate(.T., .T., 'myViewName', laErrorArray)

In both cases TABLEUPDATE return .T. and laerrorarray returns -1. AERROR(bb) does not create the array bb


>Could it be a buffering problem (maybe in the form or the form's data enriornment??)
>
>Make sure the view isnt marked 'read only' there too...???
>
>What does the tableupdate command look like? Maybe try something like this...
>
>llTableUpdate = TableUpdate(.T., .T., 'myViewName', laErrorArray)
>SET STEP ON
>
>...then see if llTableUpdate returned a True or False, and perhaps look at the laErrorArray ...
>
>
>
>>>What does the code for the view look like?
>>>
>>>Do you get any error?
>>>
>>>>I am using one to many form. The grid recordsource is defined with view. I can insert record on the child table, but when I try to update one child record nothing happen. The send SQL updates on view is checked.
>>>>
>>>>Please help me!
>>
>>No error occurs
>>
>>The sql view code is
>>
>>SELECT Parcelas.nrdocto, Parcelas.nrparcela, Parcelas.dtrecebimento,;
>> Parcelas.dtvencto, Parcelas.vlparcela, Parcelas.vlcheque,;
>> Parcelas.vlcartao, Parcelas.vldinheiro, Parcelas.nrbanco,;
>> Parcelas.nragencia, Parcelas.nrcheque, Parcelas.nmcartao,;
>> Parcelas.nrcartao;
>> FROM ;
>> cefalox!parcelas;
>> WHERE Parcelas.nrdocto = ( ?parm_nrdocto );
>> ORDER BY Parcelas.nrparcela
>>
>>DBSetProp(ThisView,"View","SendUpdates",.T.)
>>DBSetProp(ThisView,"View","BatchUpdateCount",1)
>>DBSetProp(ThisView,"View","CompareMemo",.T.)
>>DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
>>DBSetProp(ThisView,"View","FetchMemo",.T.)
>>DBSetProp(ThisView,"View","FetchSize",100)
>>DBSetProp(ThisView,"View","MaxRecords",-1)
>>DBSetProp(ThisView,"View","Prepared",.F.)
>>DBSetProp(ThisView,"View","UpdateType",1)
>>DBSetProp(ThisView,"View","UseMemoSize",255)
>>DBSetProp(ThisView,"View","Tables","cefalox!parcelas")
>>DBSetProp(ThisView,"View","WhereType",1)
>>
>>DBSetProp(ThisView+".nrdocto","Field","DataType","N(6)")
>>DBSetProp(ThisView+".nrdocto","Field","UpdateName","cefalox!parcelas.nrdocto")
>>DBSetProp(ThisView+".nrdocto","Field","KeyField",.T.)
>>DBSetProp(ThisView+".nrdocto","Field","Updatable",.T.)
>>
>>DBSetProp(ThisView+".nrparcela","Field","DataType","N(2)")
>>DBSetProp(ThisView+".nrparcela","Field","UpdateName","cefalox!parcelas.nrparcela")
>>DBSetProp(ThisView+".nrparcela","Field","KeyField",.T.)
>>DBSetProp(ThisView+".nrparcela","Field","Updatable",.T.)
>>
>>DBSetProp(ThisView+".dtrecebimento","Field","DataType","D")
>>DBSetProp(ThisView+".dtrecebimento","Field","UpdateName","cefalox!parcelas.dtrecebimento")
>>DBSetProp(ThisView+".dtrecebimento","Field","KeyField",.F.)
>>DBSetProp(ThisView+".dtrecebimento","Field","Updatable",.T.)
>>
>>DBSetProp(ThisView+".dtvencto","Field","DataType","D")
>>DBSetProp(ThisView+".dtvencto","Field","UpdateName","cefalox!parcelas.dtvencto")
>>DBSetProp(ThisView+".dtvencto","Field","KeyField",.F.)
>>DBSetProp(ThisView+".dtvencto","Field","Updatable",.T.)
>>
>>DBSetProp(ThisView+".vlparcela","Field","DataType","N(8,2)")
>>DBSetProp(ThisView+".vlparcela","Field","UpdateName","cefalox!parcelas.vlparcela")
>>DBSetProp(ThisView+".vlparcela","Field","KeyField",.F.)
>>DBSetProp(ThisView+".vlparcela","Field","Updatable",.T.)
>>
>>DBSetProp(ThisView+".vlcheque","Field","DataType","N(8,2)")
>>DBSetProp(ThisView+".vlcheque","Field","UpdateName","cefalox!parcelas.vlcheque")
>>DBSetProp(ThisView+".vlcheque","Field","KeyField",.F.)
>>DBSetProp(ThisView+".vlcheque","Field","Updatable",.T.)
>>
>>DBSetProp(ThisView+".vlcartao","Field","DataType","N(8,2)")
>>DBSetProp(ThisView+".vlcartao","Field","UpdateName","cefalox!parcelas.vlcartao")
>>DBSetProp(ThisView+".vlcartao","Field","KeyField",.F.)
>>DBSetProp(ThisView+".vlcartao","Field","Updatable",.T.)
>>
>>DBSetProp(ThisView+".vldinheiro","Field","DataType","N(8,2)")
>>DBSetProp(ThisView+".vldinheiro","Field","UpdateName","cefalox!parcelas.vldinheiro")
>>DBSetProp(ThisView+".vldinheiro","Field","KeyField",.F.)
>>DBSetProp(ThisView+".vldinheiro","Field","Updatable",.T.)
>>
>>DBSetProp(ThisView+".nrbanco","Field","DataType","N(3)")
>>DBSetProp(ThisView+".nrbanco","Field","UpdateName","cefalox!parcelas.nrbanco")
>>DBSetProp(ThisView+".nrbanco","Field","KeyField",.F.)
>>DBSetProp(ThisView+".nrbanco","Field","Updatable",.T.)
>>
>>DBSetProp(ThisView+".nragencia","Field","DataType","C(6)")
>>DBSetProp(ThisView+".nragencia","Field","UpdateName","cefalox!parcelas.nragencia")
>>DBSetProp(ThisView+".nragencia","Field","KeyField",.F.)
>>DBSetProp(ThisView+".nragencia","Field","Updatable",.T.)
>>
>>DBSetProp(ThisView+".nrcheque","Field","DataType","N(8)")
>>DBSetProp(ThisView+".nrcheque","Field","UpdateName","cefalox!parcelas.nrcheque")
>>DBSetProp(ThisView+".nrcheque","Field","KeyField",.F.)
>>DBSetProp(ThisView+".nrcheque","Field","Updatable",.T.)
>>
>>DBSetProp(ThisView+".nmcartao","Field","DataType","C(16)")
>>DBSetProp(ThisView+".nmcartao","Field","UpdateName","cefalox!parcelas.nmcartao")
>>DBSetProp(ThisView+".nmcartao","Field","KeyField",.F.)
>>DBSetProp(ThisView+".nmcartao","Field","Updatable",.T.)
>>
>>DBSetProp(ThisView+".nrcartao","Field","DataType","C(19)")
>>DBSetProp(ThisView+".nrcartao","Field","UpdateName","cefalox!parcelas.nrcartao")
>>DBSetProp(ThisView+".nrcartao","Field","KeyField",.F.)
>>DBSetProp(ThisView+".nrcartao","Field","Updatable",.T.)