secondary data source query

[tgingrich]

I see many questions on this discussion board about doing queries on a
secondary data source, and many of the answers refer to a previous posting
titled "Secondary data source query". I cannot find this posting. Am I doing
something wrong, or has it been removed from the board? Is there any way I
can see the posting, since I am having similar problems with a secondary data
source?

 

[S.Y.M. Wong-A-Ton]

Try this link
http://groups.google.com/group/micr...ary+data+source+query&rnum=1#b8c6d0e40e5ab032

If it doesn't work, go to the Google group for infopath and search on
"Secondary data source query".

 

[suresh Reddy]

Hi,

Try out this link

http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=306

Hope this will help You.
Thank u,

 

[tgingrich]

Thanks, I was able to use the examples in that thread to add a where clause
to my secondary data source SQL. I'm still having one problem with it,
though. The first time the form is used, the where clause is generated
correctly. If the form is used again without exiting InfoPath, a second where
clause is appended to the first one resulting in a syntax error. Can you give
me an example of how to revert bacak to the original SQL statement prior to
adding the where?

 

[S.Y.M. Wong-A-Ton]

Save the original Command in a variable. Then after you run Query(), set the
Command back to the original SQL statement you saved in the variable.

So put something like the following at the beginning of the code but after
var strSQL = XDocument.DataObjects["PICCT_APPL"].QueryAdapter.Command; :

var strOrigSQL = strSQL;

Put the following after XDocument.DataObjects["PICCT_APPL"].Query(); :

XDocument.DataObjects["PICCT_APPL"].QueryAdapter.Command = strOrigSQL;