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.

Perhaps you missed my question. Where did you take this code from (manual, web page, sample...)? Please be specific so we can follow what it says there. Please answer questions so we can guide you to a solution.

Thank you. A crucial point is that Acrobat forms and LiveCycle forms are completely different - not just different tools for the same job. The JavaScript commands are different too.

You'll see in this discussion the first question is whether it is an Acrobat or LiveCycle form. Unfortunately the answer is that it is an Acrobat form, so none of the rest applies to your LiveCycle form.

Also, even if you had Acrobat forms, the database connection described is switched off by default and needs a registry change (http://kb2.adobe.com/cps/333/333472.html).

Now... I understand LiveCycle forms (also called XFA forms) are much more tightly integrated with databases, based on their XML structure. Here is a web page which discusses this - http://blogs.adobe.com/formbuilder/category/data-binding.

A quick check for you when looking at information: XFA, XML, Designer and LiveCycle forms are all good things. Acroforms, Acrobat forms are bad, and any discussion before 2005. But above all, you need the documentation on LiveCycle form development.