- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
wrt
Are the values that populate the DDlists in different tables or the same one? - Yes different ones
If they are in different tables then I think you will need a different data connection per table. I agree.
If they are the same then you shodul be able to define the SQL statement that you want to run in the current code.
I suggest that you use the exit event of the DDList and not the change event. - Will try
At the moment, using a button to initiate the data source for the #2 dDown with the following code
var myClientID2 = SelectedClientID.rawValue;
var nIndex = 0;
while(xfa.sourceSet.nodes.item(nIndex).name != "Years")
{
nIndex++;
}
var oDB2 = xfa.sourceSet.nodes.item(nIndex).clone(1); // the node pertaining to the data connection specified
oDB2.nodes.item(1).query.setAttribute("text", "commandType");
oDB2.nodes.item(1).query.select.nodes.item(0).value = "Select * from Years where ClientID = '" + myClientID2 + "'";
//now connect to DB and get a record
oDB2.open();
But nothing works (totally lost)
Views
Replies
Total Likes