secondary data source query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tgingrich - 24 May 2006 15:36 GMT

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?

Reply to this Message

S.Y.M. Wong-A-Ton - 25 May 2006 08:56 GMT

Try this link
http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/3e
ac3d1470eb5127/b8c6d0e40e5ab032?q=Secondary+data+source+query&rnum=1#b8c6d0e40e5
ab032

If it doesn't work, go to the Google group for infopath and search on
"Secondary data source query".
---
S.Y.M. Wong-A-Ton

> 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?

Reply to this Message

tgingrich - 26 May 2006 19:26 GMT

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?

> Try this link
> http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/3e
ac3d1470eb5127/b8c6d0e40e5ab032?q=Secondary+data+source+query&rnum=1#b8c6d0e40e5
ab032
[quoted text clipped - 10 lines]
> > can see the posting, since I am having similar problems with a secondary data
> > source?

Reply to this Message

S.Y.M. Wong-A-Ton - 27 May 2006 06:49 GMT

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;
---
S.Y.M. Wong-A-Ton

> 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,
[quoted text clipped - 18 lines]
> > > can see the posting, since I am having similar problems with a secondary data
> > > source?

Reply to this Message

suresh Reddy - 26 May 2006 07:27 GMT

Hi,

Try out this link

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

Hope this will help You.
Thank u,

Signature

suresh Reddy
http://www.autonomysystems.com.

Reply to this Message