Form does not show "new" records from SQL Database

i have pdf form pulls data sql server.  fields in
the pdf populated database after selecting specific
record drop down , clicking on button labeled "fill".
the problem dropdown not display new records
have been added database.  have open form
in designer save it, (*note - change nothing @ point.)
then when form opened in adobe dropdown show
the records including new ones.  put manual refresh on
form try , fix did not help. stumped.

 

any appreciated.

here code dropdown.

++++++++++++++++++++++++++++

topmostsubform.page1.jobselect::initialize - (javascript, client)
var sdataconnectionname = "bbcc"; // example - var sdataconnectionname
= "test";
var scolhiddenvalue = "contractadmin_key"; // example - var
scolhiddenvalue = "dept_id";
var scoldisplaytext = "jobdescription"; // example - var
scoldisplaytext = "dept_id"

// 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
var sbofbackup =
odb.nodes.item(ndbindex).query.recordset.getattribute("bofaction");
var seofbackup =
odb.nodes.item(ndbindex).query.recordset.getattribute("eofaction");

odb.nodes.item(ndbindex).query.recordset.setattribute("staybof",
"bofaction");
odb.nodes.item(ndbindex).query.recordset.setattribute("stayeof",
"eofaction");

// clear list
this.clearitems();

// 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); } else
if(orecord.nodes.item(ncolindex).name == scoldisplaytext) { otextnode
= orecord.nodes.item(ncolindex); } }

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

 

}

 

// restore original settings
odb.nodes.item(ndbindex).query.recordset.setattribute(sbofbackup,
"bofaction");
odb.nodes.item(ndbindex).query.recordset.setattribute(seofbackup,
"eofaction");

// close connection
odb.close();

++++++++++++++++++++++

here code refresh button

+++++++++++++++++++++

topmostsubform.page1.button27::click - (javascript, client)
sourceset.bbcc.requery();

+++++++++++++++++++++

it sounds sort of caching issue query result getting cached locally. there settings on odbc connection tell connection fresh result each time called?

 

paul

More discussions in LiveCycle Forms

adobe