Populating SQL clause with node value. - InfoPath Dev
in

InfoPath Dev

Populating SQL clause with node value.

Last post 09-15-2010 12:47 PM by cjordan. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 09-15-2010 12:22 PM

    Populating SQL clause with node value.

    Hello,

     Maybe someone around here can help me out...I've programmatically generated a form template from a database schema, but since it's dynamic I need to be able to dynamically bind the data.

     

    Is there a way to pass the value of the current xml node name in the Edit Sql Section of the Data Wizard? For example, say my field node is <my:node1234>...is there a way to query using the node name?

     i.e.

    SELECT * FROM tableabc

    WHERE general_ID = '<my:node1234>'

    Any help would be much appreciated.

  • 09-15-2010 12:47 PM In reply to

    Re: Populating SQL clause with node value.

    The other alternative to this is passing the node name to a web service via string, which might be easier. I'm just wondering how I would do it...

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.