Infopath Wildcard Query with Multiple data connections

[Gary]

Hello,

I am aware of using the following article to implement wildcard
functionality for North Wind (http://support.microsoft.com/?id=826992).
However I have discovered the code syntax only operates correctly if you are
using a single data connection. If you attempt to implement this with
multiple data connections you will receive an error stating issues with the
data shape (below is again using North Wind but with an additional data
connection to replicate the issue):

The query method on the Document object failed.
InfoPath cannot run the specified query.
[0x80040E14][MSDataShape] Data shape command text contains a syntax error at
or near position 350 in the command. The text near the error is: " [Products]
WHERE ([Suppliers].[ContactName]".

File:script.js
Line:80

As an observation, not criticism of the article, I am a bit perplexed
because the point of using Access as your backend is to maintain some sort of
relational objective with your data, so I have to believe multiple data
connections to be expected in this scenario. Nevertheless my question is
this, can someone post the syntax for addressing multiple data connections by
modifying the referenced code within http://support.microsoft.com/?id=826992
? Thanks in advance, I'm sure others are experiencing this same issue.

 

[Shiva (GGK Tech)]

Hello,

If you want to submit multiple row data at a time then you have to change
your schema and based on that you have to change your code. After getting
multiple rows data you have to change your code. According to number of nodes
return we have to get one node from sample data and add the data from
database and add this new node to parent node. Like this operation we have to
do node list length is exceeds.

 

[Gary]

Shiva,

Thank you for your reply, I understand that I need to alter the code but I'm
not a code slinger so I am asking for guidance on how to accomplish this.
Ideally I would like an example of this...
--
Gary

Hello,

If you want to submit multiple row data at a time then you have to change
your schema and based on that you have to change your code. After getting
multiple rows data you have to change your code. According to number of nodes
return we have to get one node from sample data and add the data from
database and add this new node to parent node. Like this operation we have to
do node list length is exceeds.

--
Shiva
http://www.ggktech.com

Hello,

I am aware of using the following article to implement wildcard
functionality for North Wind (http://support.microsoft.com/?id=826992).
However I have discovered the code syntax only operates correctly if you are
using a single data connection. If you attempt to implement this with
multiple data connections you will receive an error stating issues with the
data shape (below is again using North Wind but with an additional data
connection to replicate the issue):

The query method on the Document object failed.
InfoPath cannot run the specified query.
[0x80040E14][MSDataShape] Data shape command text contains a syntax error at
or near position 350 in the command. The text near the error is: " [Products]
WHERE ([Suppliers].[ContactName]".

File:script.js
Line:80

As an observation, not criticism of the article, I am a bit perplexed
because the point of using Access as your backend is to maintain some sort of
relational objective with your data, so I have to believe multiple data
connections to be expected in this scenario. Nevertheless my question is
this, can someone post the syntax for addressing multiple data connections by
modifying the referenced code within http://support.microsoft.com/?id=826992
? Thanks in advance, I'm sure others are experiencing this same issue.