Ask Your Question

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

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

5tefan gravatar image

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


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

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

5tefan gravatar image

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

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

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

Question Tools

1 follower


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

Seen: 1,315 times

Last updated: Sep 25 '13