Hi again,
I have been fidling a little with "things", but I still haven't found what I am looking for.
I found one of your older posts with this essential content:
-----
1. First lets change the connection to accept a sql command instead of connecting and getting all records:
xfa.sourceSet.DataConnection.nodes.item(1).query.setAttribute("text", "commandType");
2. Now lets set the SQL command we want to execute:
xfa.sourceSet.DataConnection.nodes.item(1).query.select.nodes.item(0).value="Select * from Parts Where PART_NO = " + TextField1.rawValue;
3. Now we are ready to open the connection:
xfa.sourceSet.DataConnection.open()
-----
However I can't make it work in Acrobat 9, I get an error telling me the following:
GeneralError: Operation failed.
XFAObject.open:6:XFA:form1[0]:#subform[0]:Button1[1]:click
Connection for Source DataConnection failed because the environment is not trusted.
What can I do to go around this.
Sincerely
Kim