marwest98
10th April 2008, 18:36
I am currently using BAAN and in my script, I am trying to update a Oracle table field to a literal value. Such as:
tccom910.activity = "Before"
the tccom910.activity is a string with a length of 10
I am new to BAAN programming. I have tried setting another domain to Before, and then set the table field to it (tccom910 = com.activity).

It does not like anything. Help!!! :confused:

mig28mx
10th April 2008, 18:47
Hello,
You shoud check the valid characters to use on your domain.
Another option is create a new domain to store your label. Also not forget to convert to DD an CDD for this domain before you use on your program.

Good luck.

marwest98
10th April 2008, 18:50
tccom910.mcs.user = logname$
tccom910.trns.dat = dte$()
tccom910.activity = "Before"
tccom910.bpid = tccom100.bpid
tccom910.nama = tccom100.nama
tccom910.prst = tccom100.prst
tccom910.cadr = tccom100.cadr
tccom910.namc = tccom130.namc
tccom910.namd = tccom130.namd
db.insert(ttccom910, db.retry)
commit.transaction()

marwest98
10th April 2008, 19:45
I got it!!!!
I changed dte$() to date.num() and that fixed the compile error that was pointing to activity (I thought).

Thanks.