I am trying to insert a record into a table. The record should not exist, but, I kept getting a 205 error, so, I decided to select first. We just converted from Oracle/Unix to SqlServer2005/Windows2003. I did not have this problem before converting in other programs. This is a new program, but, I copied everything from an existing program. I think it is the utc.num() that is causing the problem now. Any ideas on something else I could use?
function write.after.record()
{
select tccom100.cadr, tccom100.bpid, tccom100.nama
from tccom100
where tccom100.cadr = :tfacp202.cadr
order by tccom100.cadr
as set with 1 rows
selectdo
select.130.record()
selectempty
select.130.record()
selecteos
select.130.record()
endselect
}
function select.130.record()
{
select tccom130.namc, tccom130.hono, tccom130.pobn, tccom130.name,
tccom130.namf, tccom130.pstc, tccom130.cste, tccom130.cadr
from tccom130
where tccom130._index1 = {:tfacp202.cadr}
order by tccom130._index1
as set with 1 rows
selectdo
get.910.record()
selectempty
get.910.record()
selecteos
commit.transaction()
endselect
}
function get.910.record()
{
db.retry.point()
select * from tccom910
where tccom910.activity = "addrchg"
and tccom910.bpid = :tccom100.bpid
and tccom910.cadr = :tccom130.cadr
and tccom910.nama = :tccom100.nama
and tccom910.namc = :tccom130.namc
and tccom910.hono = :tccom130.hono
and tccom910.pobn = :tccom130.pobn
and tccom910.name = :tccom130.name
and tccom910.namf = :tccom130.namf
and tccom910.pstc = :tccom130.pstc
and tccom910.cste = :tccom130.cste
and tccom910.cbad = :tccom125.cbad
and tccom910.bano = :tccom125.bano
selectdo
update.910.record()
selectempty
insert.910.record()
endselect
}
function update.910.record()
{
tccom910.mcs.user = logname$
tccom910.trns.dat = utc.num()
tccom910.activity = "addrchg"
tccom910.bpid = tccom100.bpid
tccom910.nama = tccom100.nama
tccom910.cadr = tccom130.cadr
tccom910.namc = tccom130.namc
tccom910.hono = tccom130.hono
tccom910.pobn = tccom130.pobn
tccom910.name = tccom130.name
tccom910.namf = tccom130.namf
tccom910.pstc = tccom130.pstc
tccom910.cste = tccom130.cste
tccom910.cbad = tccom125.cbad
tccom910.bano = tccom125.bano
db.update(ttccom910, db.retry)
commit.transaction()
}
function insert.910.record()
{
tccom910.mcs.user = logname$
tccom910.trns.dat = utc.num()
tccom910.activity = "addrchg"
tccom910.bpid = tccom100.bpid
tccom910.nama = tccom100.nama
tccom910.cadr = tccom130.cadr
tccom910.namc = tccom130.namc
tccom910.hono = tccom130.hono
tccom910.pobn = tccom130.pobn
tccom910.name = tccom130.name
tccom910.namf = tccom130.namf
tccom910.pstc = tccom130.pstc
tccom910.cste = tccom130.cste
tccom910.cbad = tccom125.cbad
tccom910.bano = tccom125.bano
db.insert(ttccom910, db.retry)
commit.transaction()
}
|mew end

Extracted from the Programers Guide
205 ENOTINRANGE - XXXXXXXX
Description:
This error indicates that the field value is out of range and does not agree with the domain definition.
Solution:
XXXXXXXXXXXXXXX


Suggestion: Check the log errors executing the session ttstperrlog then u'll see what field is not in correct range

In Win2k3 eventvwr will show the error . And as identified , it's mostly the date which must be causing the problem . Normally in copying data from other systems , dates (which may be valid in older system but invalid as per SQL) can give such problem. Dont know if it's possible to use date.num() in ur version of Baan . U can try.

I couldn't find anything in the logs, But, I figured out that it wasn't the date. It was the activity field. It needed to be all caps. I guessed.