0 Replies Latest reply on Nov 30, 2010 8:37 AM by eugzl

    save and update entered data in database

    eugzl Level 1

      Hi All.

       

      I created simple form in LiveCycle Designer and link that form to Access database. Now I would like to SAVE entered data in database and UPDATE existing record. I wrote JavaScript code for SAVE button in click event:

       

      var query = 'INSERT INTO Table1 (Ticket_No, Date, Model) values ("Ticket_No", "Date", "Model")';


      statement.execute(query);


      Ticket_No.rawValue = ""; // clear after inserting

      Date.rawValue = "";

      Model.rawValue = "";

       

      But when I click button nothing saved in database. When I manually enter data in database table and then run form I can see data in the according form fields. So I'm thinking connection is fine. How to fix problem and save entered? And how to create code for UPDATE button to update existing record?

       

      Thanks.