I have received the solution for db.update, but now I want to hard code a supplier number in the script. When I do this, the session does not find the supplier?
functions:
function read.main.table()
{
long count
db.retry.point()

select tdpsc001.*, tiitm001.prip
from tdpsc001 for update, tiitm001
where tdpsc001.suno ="250"
and tdpsc001.item refers to tiitm001
selectdo
|update set
tdpsc001.pric = tiitm001.prip
db.update(ttdpsc001, db.retry)
count = count + 1
if count > 50 then
count = 0
commit.transaction()
endif
endselect
commit.transaction
}

check the domain for tdpscoo1.suno or use GTM, your hardcoded value must be in the same format as the record
e.g. tdpcs001.suno = " 250"
(right justifed 6 ch. string so add 3 spaces before the value)

Try to use function http://www.baanboard.com/programmers_manual_baanerp_help_functions_string_operations_tt_align_according_domain