Ask Your Question
0

dynamically set value of a form field not inserted into database [closed]

asked 2013-09-25 01:06:05 +0100

5tefan gravatar image

updated 2013-09-25 01:07:08 +0100

hello,

in a form I have a form-field whose value gets set dynamically via a macro. So far, so good. That works. But then, when I want to store the content of my form in my database I get an error (depending on the settings for the form-field it's either an sql-error like "attempt to insert null in a non-nullable column" or "Error writing to database"). Obviously values inserted into the form with a macro like in the following snippet are not valid:

oDrawPage.getByName("fmtinvoice_num").text = reNum 're_num is an integer value

Why is that? Resp. what can I to do to make the dynamically entered value being recognized?

Thanks very much for help

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-10 00:05:19.037801

1 Answer

Sort by » oldest newest most voted
0

answered 2013-09-25 15:33:12 +0100

5tefan gravatar image

updated 2013-09-25 16:13:48 +0100

[solved] replacing 'text' with 'effectiveValue' and comitting afterwards seems to do the trick:

oDrawPage.getByName("fmtinvoice_num").effectiveValue = reNum
oDrawPage.getByName("fmtinvoice_num").commit(reNum)
edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-09-25 01:06:05 +0100

Seen: 1,285 times

Last updated: Sep 25 '13