These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

save entered data to database

2010-11-23 07:37:41

eugz

Registered: Dec 8 2009

Posts: 5

Hi All.

I created simple form and connect it to Access database. Now would like to save entered data to database. How to code Save button to save entered data? I will appreciate for sample.

Thanks.

My Product Information:
LiveCycle Designer, Windows

2010-11-23 08:47:07

radzmar

Registered: Nov 3 2008

Posts: 1202

Hi,

start with this article.

http://forms.stefcameron.com/2006/09/18/connecting-a-form-to-a-database/

radzmar
• LoveCycle Blog
Documents you need:
• LiveCycle Designer ES2 Docs

2010-11-23 09:29:01

eugz

Registered: Dec 8 2009

Posts: 5

Hi radzmar.

Thanks for replay. I insert button to form and add JavaScript with Click event to it. But when I click the record didn't insert to database table. What is problem? My code is:

Database.ExecSQL("INSERT INTO Table1 (Ticket_No, Description) VALUES (Ticket_No.rawValue, Description.rawValue);");
Ticket_No.rawValue = ""; // clear after inserting

where Table1 database table
Ticket_No and Description fields of the table

Thanks.