>the uncommited changes error because of the delete statement:
>
>DELETE FOR pk=findpk in vtemp
>DELETE FOR fk=findpk IN vtempdetail
>thisform.addnew
>
>if I remove the delete code, I won't get error message.
>
>any suggestion?
>
>thanks for the help
>
>regards,
>
>Jerry
It is hard to me to give you proper advise. I don't know what Buffering mode you use (I suppose it is Row Buffering, but I am not sure). What are these tables? Only temporary tables that you use for showing data or they are Views or CAs wich you use for manage DataBase Tables?
If these temp tables (cursors) are Views/CAs what do you want to happens with deleted records? To be deleted in Actual table or you want just to desapear from your Temp Table?
DELETE FOR pk=findpk in vtemp
DELETE FOR fk=findpk IN vtempdetail
TableUpdate(1,.t.,"vtemp")
TableUpdate(1,.t.,"vtempdetail")
thisform.addnew
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.