Qdabra Database Accelerator

Re: Dynamically changing DBEnum parameters

ErnestoM — Wed, 28 Nov 2007 19:39:01 GMT

Oh, that was simple! Thanks Matt.

Because the problem was elsewhere, it turns out that it doesn't matter which quotes (single or double) are used. I was succesful using Clay's reccommendation for inserting single quotes, as well as a reccommendation from this topic (http://www.infopathdev.com/forums/p/5083/24578.aspx#24578), where the double quotes are stored in a separate xml node and inserted in the concat statement. Note, however, that double quotes cannot be inserted within double quotes (i.e. """).

Re: Dynamically changing DBEnum parameters

Matt Faus — Wed, 28 Nov 2007 07:13:37 GMT

Also, be sure that you are not URL encoding in your concat()... Let InfoPath do that itself.

Re: Dynamically changing DBEnum parameters

Clay Fox — Wed, 28 Nov 2007 03:45:35 GMT

In one that I have working, I have to concat the single quotes seperately. Not sure if this helps or not but thought that I would add this.

so concat(....<eq><column name=", "'", "Name", "'", "/><value...)

Re: Dynamically changing DBEnum parameters

ErnestoM — Wed, 28 Nov 2007 00:10:24 GMT

Hi Patrick, single quotes return the same error.

Re: Dynamically changing DBEnum parameters

Patrick Halstead — Tue, 27 Nov 2007 04:20:30 GMT

Hi Ernesto,

I'm wondering if it has something to do with the double quotes getting escaped. Can you try changing the double quotes to single quotes and see if that makes a difference?

Re: Dynamically changing DBEnum parameters

ErnestoM — Mon, 26 Nov 2007 23:10:56 GMT

I've been able to create my query and include the double quotes, thanks to a reply in the topic linked in my previous response. I'm currently using a rule that concatenates the values provided by the user to create the following query:

It looks ok and it has been tested: I created a simple Infopath form that calls DBEnum using this filtering query and it works perfectly.

However, in the solution where I allow the user to dynamically change the values, the query fails, with the following error:

The SOAP response indicates that an error occurred on the server:

System.Web.Services.Protocols.SoapException: El servidor no puede procesar la solicitud. ---> System.ArgumentException: Invalid parameter
Nombre del parámetro: queryXml ---> System.Xml.XmlException: Los datos del nivel de raíz no son válidos. Línea 1, posición 1.
   en System.Xml.XmlTextReaderImpl.Throw(Exception e)
   en System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
   en System.Xml.XmlTextReaderImpl.Throw(Int32 pos, String res)
   en System.Xml.XmlTextReaderImpl.ParseDocumentContent()
   en System.Xml.XmlTextReaderImpl.Read()
   en System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
   en System.Xml.XmlDocument.Load(XmlReader reader)
   en System.Xml.XmlDocument.LoadXml(String xml)
   en Qdabra.DataBaseService.DatabaseEnumerationService.GetColumnsForRows2b(String database, String table, String queryXml)
   --- Fin del seguimiento de la pila de la excepción interna ---
   en Qdabra.DataBaseService.DatabaseEnumerationService.GetColumnsForRows2b(String database, String table, String queryXml)
   --- Fin del seguimiento de la pila de la excepción interna ---

If the queryxml works when I insert it manually, why would it fail when the form injects it automatically?

Re: Dynamically changing DBEnum parameters

ErnestoM — Wed, 21 Nov 2007 21:10:21 GMT

Great! Thanks.

Now I'm looking at a separate problem. Basically, after receiving the user input and using concat this is the query I have (user input in bold):

And this is the query I need:

I'm using concat and it won't allow me to use a double quote (") around the column name. I've posted that question here: http://www.infopathdev.com/forums/p/5083/19570.aspx

Re: Dynamically changing DBEnum parameters

Matt Faus — Wed, 21 Nov 2007 02:16:54 GMT

Hi Ernesto,

This scenario is why there are two versions of this method: 2 and 2b. If you use the 2b method, the queryXml node will show up as a regular textbox node in the schema, just like database and table. With this node you can fill it with the result of a concat() operation that takes values from other nodes and generates an XML fragment from them.

So, you would create another secondary data connection, called QueryBuilder, and it will have the schema of the actual queryXml node. After that is filled out, you can use a concat() (probably combined with some complicated eval() operations) to generate the XML fragment. Then assign this fragment to the queryXml node, and you should be set!

Hope this helps!

Dynamically changing DBEnum parameters

ErnestoM — Tue, 20 Nov 2007 22:28:00 GMT

I have succesfully created a form based on a Web Service that allows the user to dynamically change the parameters used to query the Database Enumeration Service. The user enters a database and a table and clicks a button to launch the query.

However, now I'd like to allow the user to create the filtering query on the fly. I can use concat to "gather" and arrange various input fields into the filtering query, but I don't know how to insert the contents of this fields into the .

I notice that when I save the source files I do not get a GetColumnsForRows2.xml that I can edit (as indicated in the help documents). I notice that the filter queryXML is created as a section, but I'm unable to edit it (see Data Source attached).

So, to summarize my goal: query using DBEnum, by allowing the user to feed each piece of information (database, table, column, queryxml filter) into a form and click a button, instead of "hard-coding" all that information using the Data Connection Wizard.

Thanks!