>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.)