SQL Database Integration

Re: Record count in a data connection...

Karsten Brocksieper — Thu, 20 Apr 2006 16:15:19 GMT

Hello,

...for anyone who is interested in...

In the meantime I have found a way to count any nodes regardless if they are in a primary or a secondary data source.
And it´s really easy. You just can take an 'expression box' control.
Within this expression box use the 'count' function of XSD.
For example if you want to count the elements of a repeating table the expression looks like:

count(my:groupname/my:fieldname)

With this you can also count records of a secondary data source even with filter conditions.

Hope this helps anyone

Re: Record count in a data connection...

Matt Faus — Fri, 31 Mar 2006 00:40:01 GMT

I think you should be able to do this:

var recordCount = XDocument.GetDOM( "vReportWebWarenkorb" ).selectNodes( "XPath/To/Nodes" ).length;

If it gives you an error about namespaces, you will need to setup a reference to the DOM before calling selectNodes() and make sure to use the .setProperty() to add the namespace prefixes.

Hope this helps!

Record count in a data connection...

Karsten Brocksieper — Thu, 30 Mar 2006 17:05:18 GMT

Hello,

I have the following code in an "AfterUpdate" event:

function msoxd_my_cboProdukttyp::OnAfterChange(eventObj)
{
	var IDProdukttyp = XDocument.DOM.selectSingleNode("//my:cboProdukttyp");
	
	var adoDataAdapter = XDocument.DataObjects["vReportWebWarenkorb"].QueryAdapter;
	adoDataAdapter.Command = "Select * From vReportWebWarenkorb Where ptID = " + IDProdukttyp.text + " Order by Produkt";
	adoDataAdapter.Query();

	if (eventObj.IsUndoRedo)
		{
			return;
		}

}

Is there an easy way to get the recordcount of the "Select" statement?

Thank you very much for any help.