Create Query - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Create Query

Last post 04-12-2007 10:44 AM by Greg Collins. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-12-2007 08:50 AM

    • Wallen
    • Not Ranked
    • Joined on 08-24-2004
    • USA
    • Posts 3

    Create Query

    I have a InfoPath form that I need to create a connection to a SQL database and return some values. I can create with using the Data Connection wizard, but that returns too many records. What I want to do is to pass a parameter. Here is my current code.

    function RetreiveMatters::OnClick(eventObj)
    {
    var objADOAdapter;
    objADOAdapter = XDocument.DataObjects("matters").QueryAdapter ;
    XDocument.objADOAdapter.Command = "exec _get_Lookup_values @table = 'matter', @filter = 'c.client_code = ''012307'";

    //Query the Data Source.
    XDocument.Query();
    }

    What Am I doing Wrong?
    TIA

    O
    ...If God didn't want us to eat animals, why did he make them out of meat???!!!
  • 04-12-2007 10:44 AM In reply to

    XDocument.Query() is used when your main DOM is connected to a datasource like SQL or Access.

    You have a data connection called "matters". You need to query that data connection.
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.