0 Replies Latest reply on Jul 11, 2011 7:09 AM by Ty Spearman

    Insert/Update

    Ty Spearman

      Hello and thank you for your interest in my question...

       

      I am inside of workbench and cannot get a grasp on how I would insert or update an SQL database.  With that said let me give a little background on this project:

       

      All of my forms are tied to my xml in a data connection inside of Designer.  I have successfully queried my database and pre-filled my forms with the proper data based on a standard number a user enters in to launch the application (this all works wonderfully).  However, I have a few drop-down lists on some of these forms where the user would select a value and based on their selection we would pass that to the database (update).  These drop downs are bound to my xml.

       

       

      So, back to workbench....in theory I can voice how the update would happen in workbench.  But I just cannot grasp how to go about it.  I know somehow I have to "hold" the values the user selected on the form in a variable. I believe to be using the correct event in live cycle:  Parameterized Query.  However, I fail to understand how to hold onto the values a user selected in the form and pass that along in an update from within workbench.  Would this be accomplished with a regular process variable or do I create a new XML schema to hold onto that data and based on the "new" data go ahead with the update?

       

       

      My workflow is as follows:  I display the form and once the user has finished the form they submit it.  Next, inside of workbench i have an export data event (I am unsure if I really need this) and I select the PDF to export data from.  My data format can be "auto, XDP or XML Data; if I am to use the export Data event which one of these do I need to select??  My output is either a variable or X-path expression??  Now I move to the next step where I execute my "insert or update".  I would assume the "test" values should be the variables I created to hold my user's selection from the form??  Hopefully I have explained this enough to where it is not confusing.  I apologize if it is as I am basically learning LiveCycle on the "fly".