Searching a secondary data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craigs714 - 10 Nov 2005 01:34 GMT

I have a large table that is read into memory (a secondary data source).
After a field on a form is entered I want to validate the value against this
source. I do not want to create a dropdown because the performance is slow
and because the data is fairly similar. ie. A001, A021, A299..., B002, B004,
B899 ..., C...

How do I validate or create a rule to see if there is a match.

Thanks

Reply to this Message

Franck Dauché - 10 Nov 2005 06:13 GMT

Hi,

Did you try to do it by code, by looping through the secondary DOM?

IXMLDOMDocument3 oSecondDoc =
(IXMLDOMDocument3)thisXDocument.DataObjects["tblTest"].DOM;
oSecondDoc.setProperty("SelectionNamespaces",
"xmlns:dfs=\"http://schemas.microsoft.com/office/infopath/2003/dataFormSolution\"
xmlns:d=\"http://schemas.microsoft.com/office/infopath/2003/ado/dataFields\"");

foreach (IXMLDOMNode oN in oSecDocNode.childNodes)
{
if (oN.nodeType == DOMNodeType.NODE_ELEMENT)
{
IXMLDOMNode oField1 = oN.selectSingleNode("@fldTest");
}
}
IXMLDOMNode oSecDocNode =
oSecondDoc.selectSingleNode("/dfs:myFields/dfs:dataFields");

Hope that it helps.

Regards,

Franck Dauché

> I have a large table that is read into memory (a secondary data source).
> After a field on a form is entered I want to validate the value against this
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message