This operation violates your permissions configuration

hello.

 

i have been spending time attempting create livecycle form connected excel spreadsheet.  idea of form can select record database , view current information populated within table  due fact there 500+ records, looking method in can select 1 of these records view drop down list.  have made data connection, created drop down list , names of individuals showing correctly.  however, link stops there , whoever select drop down not update record attached , first database entry remains.

 

this code have attached drop down list:

 

form1.#subform[0].datadropdownlist::initialize - (javascript, client)
/* dropdown list object populate 2 columns data data connection.

sdataconnectionname - name of data connection data from.  note data connection appear in data view.
scolhiddenvalue  - hidden value column of dropdown.  specify table column name used populating.
scoldisplaytext  - display text column of dropdown.  specify table column name used populating.

these variables must assigned script run correctly.  replace <value> correct value.
*/

var sdataconnectionname = "dataconnection";  // example - var sdataconnectionname = "mydataconnection";
var scolhiddenvalue = "employee id";   // example - var scolhiddenvalue = "myindexvalue";
var scoldisplaytext = "name";   // example - var scoldisplaytext = "mydescription"

// search sourceset node matchs dataconnection name
var nindex = 0;
while(xfa.sourceset.nodes.item(nindex).name != sdataconnectionname)
{
nindex++;
}

var odb = xfa.sourceset.nodes.item(nindex);

odb.open();

odb.first();

// search node class name "command"
var ndbindex = 0;
while(odb.nodes.item(ndbindex).classname != "command")
{
ndbindex++;
}

// backup original settings before assigning bof , eof stay
odb.nodes.item(ndbindex).query.recordset.setattribute("staybof", "bofaction");
odb.nodes.item(ndbindex).query.recordset.setattribute("stayeof", "eofaction");

// search record node matching data connection name
nindex = 0;
while(xfa.record.nodes.item(nindex).name != sdataconnectionname)
{
nindex++;
}
var orecord = xfa.record.nodes.item(nindex);

// find value node
var ovaluenode = null;
var otextnode = null;
for(var ncolindex = 0; ncolindex < orecord.nodes.length; ncolindex++)
{
if(orecord.nodes.item(ncolindex).name == scolhiddenvalue)
{
  ovaluenode = orecord.nodes.item(ncolindex);
}
if(orecord.nodes.item(ncolindex).name == scoldisplaytext)
{
  otextnode = orecord.nodes.item(ncolindex);
}
}

while(!odb.iseof())
{
  this.additem(otextnode.value, ovaluenode.value);
   odb.next();
}

// close connection
odb.close();

 

i checked code , after ironing couple of problems out, appears getting there.  however, cannot error:

 

this operation violates permissions configuration

 

after checking forum , many others established clone option, when add clone(1) end of following line of code above:

 

var odb = xfa.sourceset.nodes.item(nindex).clone(1);

 

but when drop down list no longer has names connected database.  lost , desperately need sorted, appreciated

 

thanks

More discussions in LiveCycle pre-ES (6.x and 7.x) discussions

adobe