Views
Replies
Total Likes
Hi Paul,
Am trying to update database column using below script but it errors
oDC.#command.query.select.nodes.item(0).value = ("update employee set cnt
=",cnt.rawValue," where employee_id =",employee_id.rawValue,"")
Same like the select query. I searched on forum too but didnt find any
Any help is appriciated
Thanks
Views
Replies
Total Likes
In version 8 of Acrobat there was a security concern about changing the values in the SourceSet dom on the fly. You are running into that issue as you getting a permissions violation when doing this.
This post explains the issue and the solution nicely:
http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/
Paul
Views
Replies
Total Likes
Hello Paul,
The Link was very helpful but I still couldnt figure out how to update DB
on click event of button
Views
Replies
Total Likes
Error message: "ado2xfa operation failed. Item cannot be found in the
collection corresponding to the requested name or ordinal."
But when I check the Database record I see it is updated
Views
Replies
Total Likes
Hi Paul,
How do we handle errors I Formcalc script?
If the query do not return any value then need to display some alert or
display all fields as null.
Views
Replies
Total Likes
Strange part is when I do
xfa.host.messageBox
(xfa.sourceSet.DataConnection2.#command.query.commandType)
It alerts (text) but when I assign
xfa.sourceSet.DataConnection2.#command.query.commandType= "text" it
errors.....is it something with permission issue on database object?
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies