Hi,
I am getting error when i tried to update the table

"Record modified by other user;new values are displayed"

The script is as below

function Approve.PDS()
{
check.PDS.lines()
if lines.present = true then
db.retry.point()
select tipps200.*
from tipps200 for update
where tipps200._index1 = {:tipps200.pdsn}
selectdo
tipps200.appr = tcyesno.yes
db.update(ttipps200,db.retry)
commit.transaction()
endselect
endif
}

function check.PDS.lines()
{
select tipps201.*
from tipps201
where tipps201._index1 = {:tipps200.pdsn}
selectdo
lines.present = true
selectempty
lines.present = false
endselect
}

Though the table gets updated , the above mentioned message box appears every time. How to remove this message box ?

Nilesh

Not shure I understand you correctly. But I think you have following situation:
You are updating records of your maintable in a Type 1, 2 or 3 Form.
Add execute(interrupt) behind your select. This should help.

...
endselect
execute(interrupt)
...

Regards
csecgn

I have a same issue I worte a script to update a table. I get a same error when i try to go back to the maintain session. if i change one one of filed or delete give me same message as "Record modified by othe user; new values are diplayed". however, after mofiying the field, the message disapperas...please, if anyone have idea how to resolve...