Hi,
When I'm in debug mode,fails to load the data from my tables and insert them into the table.

function insert_field_table(){
db.retry.point()
select tdsls900.*
from tdsls900 for update
where tdsls900.bpid = :tdsls400.ofbp
selectdo

selectempty
tdsls900.bpid = ""
tdsls900.nama = ""
tdsls900.item = ""
tdsls900.cuni = ""
tdsls900.odat = 0
tdsls900.orno = ""
tdsls900.qoor = 0
db.set.to.default(ttdsls900)



tdsls900.bpid = tdsls400.ofbp
tdsls900.nama = tccom100.nama
tdsls900.item = tdsls401.item
tdsls900.cuni = tdsls401.cups
tdsls900.odat = tdsls400.odat
tdsls900.orno = tdsls401.orno
tdsls900.qoor = tdsls401.qoor

db.insert(ttdsls900, db.retry)
commit.transaction()
endselect


I tried to comment the select empty part, but gave me a error that I have duplicate records.
Can you help me?
Regards,
RavCoder

Hi,
I changed my code and now show me all fields, but I have the same values ​​repeated.
How do I enter different values? Do I have to make a loop? How do you do?

function insert_field_table(){
db.retry.point()
select tdsls900.* , tdsls400.ofbp , tdsls400.odat, tdsls401.item, tdsls401.cups, tdsls401.orno, tdsls401.qoor
from tdsls900 for update, tdsls400 , tdsls401
where tdsls900.bpid = :tdsls400.ofbp
and tdsls900.nama = :tccom100.nama

as set with 1 rows
selectdo

selectempty


tdsls900.bpid = ""
tdsls900.nama = ""
tdsls900.item = ""
tdsls900.cuni = ""
tdsls900.odat = 0
tdsls900.orno = ""
tdsls900.qoor = 0
db.set.to.default(ttdsls900)


db.insert(ttdsls900, db.retry)
tdsls900.bpid = tdsls400.ofbp
tdsls900.nama = tccom100.nama
tdsls900.item = tdsls401.item
tdsls900.cuni = tdsls401.cups
tdsls900.odat = tdsls400.odat
tdsls900.orno = tdsls401.orno
tdsls900.qoor = tdsls401.qoor

|| Insert loop !?
commit.transaction()
endselect


}



Thanks and regards,
RavCoder

Your db.insert goes after you assign the fields.