Custom code best option for stored procedure? - InfoPath Dev
in

InfoPath Dev

Custom code best option for stored procedure?

Last post 04-02-2010 11:16 AM by imstac. 18 replies.
Page 2 of 2 (19 items) < Previous 1 2
Sort Posts: Previous Next
  • 04-02-2010 08:12 AM In reply to

    Re: Custom code best option for stored procedure?

    You'll need to modify the first action in the rule (from the screenshot you included above). Right now you have:

    Next_Estimate = concat("<query...

    But you need

    queryxml = concat("<query...

    Where queryxml is a node in the secondary data source you created to query the database (NextEstimateNumber).

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 04-02-2010 10:23 AM In reply to

    • imstac
    • Top 200 Contributor
      Female
    • Joined on 01-13-2010
    • Austin, TX
    • Posts 59

    Re: Custom code best option for stored procedure?

    Rock On!  Got it working.  Thanks so much Jimmy, Hillary and Ernesto!

     I just have one other question.  The value of my field 'estno' depends on two filters w/n the querydb, 'year' and 'branchoffice'.  I have put all of my actions for assigning my 'estno' value in my 'year' rules.  If I change the year field my 'estno' value will update; however if I change just the 'branchoffice' value and leave the year value as is my 'estno' value does not update.  How/Where do I put my rule actions to where if either the branch office or year field changes the value of my 'estno' field will requery?

    Stacie
  • 04-02-2010 10:34 AM In reply to

    Re: Custom code best option for stored procedure?

     If the rule logic isn't too complicated, it may be simplest to just put the exact same set of rules on both fields.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 04-02-2010 11:16 AM In reply to

    • imstac
    • Top 200 Contributor
      Female
    • Joined on 01-13-2010
    • Austin, TX
    • Posts 59

    Re: Custom code best option for stored procedure?

    Thanks Jimmy, that worked!

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