Qdabra Database Accelerator

Re: QueryDB Problems

ErnestoM — Fri, 02 Apr 2010 13:16:35 GMT

Also, comparing your query strings I notice:

you're using #CORLOG# in one and CORLOG in the other (for the database parameter).
You have a maxrows of 1 in the concat statement. If you are filtering, and you expect to only find one matching value, then the maxrows parameter won' t be necessary.

concat("<query database='CORLOG' table='vendor-tbl' maxrows='1'><columns><column name='VENCONTR'/><column name='VENNO'/></columns><filter><eq><column name='VENCONTR'/><value>", xdXDocument:get-DOM()/my:myFields/my:ContractAgreementNumber ,"</value></eq></filter></query>")

I would suggest addressing both to make sure you don't run into other issues later.

Re: QueryDB Problems

Jimmy — Tue, 23 Mar 2010 01:46:59 GMT

That error typically means that the queryXml parameter is not valid (well-formed) XML.

Can you try displaying the queryXml value in a TextBox on your form (just drag the field into your form and display it as a text box) so you can see what value it has when the query is being run, then copy and paste it into this forum?

QueryDB Problems

brandon.gill — Mon, 22 Mar 2010 18:07:41 GMT

Hello -

I followed these instructions to the letter http://www.infopathdev.com/files/folders/web_methods/entry32474.aspx

yet I am getting an error. I am trying a dynamic query

here is the sample query:
<query database='#CORLOG#' table='vendor-tbl' maxrows='2'><columns><column name='VENCONTR'/><column name='VENNO'/></columns></query>

I put this in the the sample value when I am setting up the data connection for GetColumnsXMLStrQuery.

When I setup the field In the rules I use the set a field value and use this query:

I am referencing a field in the form as my "where" clause. I add the rule to query database after the set field value.

The error that I get is Some rules were not applied.

here is the detailed error:

The query cannot be run for the following DataObject: GetColumnsXMLStrQuery
InfoPath cannot run the specified query.
The SOAP response indicates that an error occurred on the server:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.ArgumentException: Invalid parameter
Parameter name: queryXml ---> System.ArgumentException: Invalid parameter
Parameter name: queryXml
   at Qdabra.DataBaseService.QueryDBService.GetColumnsXMLStrQuery(String queryXml)
   --- End of inner exception stack trace ---
   at Qdabra.DataBaseService.QueryDBService.GetColumnsXMLStrQuery(String queryXml)
   --- End of inner exception stack trace ---

I am not sure how to trouble shoot the invalid parameter.