Re: Change the Secondary Query

davidair — Thu, 14 Jun 2007 14:57:37 GMT

This happens because there is no QueryAdapters property...

To access the main query adapter's command, use this:

XDocument.QueryAdapter.Command

To access a secondary adapter's command, use this:

XDocument.DataObjects["Detail"].QueryAdapter.Command

Hope this helps. Also using F1 while editing the code is very helpful, just hit F1 on XDocument to get more info about it.

Change the Secondary Query

TogasPoon — Thu, 14 Jun 2007 14:37:14 GMT

Whenever I run this code:

function CTRL2_7::OnClick(eventObj)
{
    //Retrieve the value of the field that you want to use as a parameter
    //to the stored procedure.
    var planIdValue = XDocument.DOM.selectSingleNode("/dfs:myFields/my:myPlanId").text;
    //Set the Command for the Query Adapter of the Data Source. Incorporate the
    //parameter values that you want to use.
    XDocument.QueryAdapter.Command = 'SELECT * FROM Ma_Plans WHERE PlanId = ' + planIdValue;
    //Query the Data Source.
    XDocument.Query();

    XDocument.QueryAdapters["Detail"].Command = 'SELECT * FROM vwMaPlanEquipmentDetail WHERE PlanId = ' + planIdValue;
    XDocument.QueryAdapters["Detail"].Query();
}

I get the following error on this line:

XDocument.QueryAdapters["Detail"].Command = 'SELECT * FROM vwMaPlanEquipmentDetail WHERE PlanId = ' + planIdValue;

XDocument.QueryAdapters.Detail is null or not an object

Any ideas?

Thanks

Data Connections

Re: Change the Secondary Query

Change the Secondary Query