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

parameters and db: I can do?

kikkat
Registered: Jun 13 2008
Posts: 17
Answered

Hi,
is the first time that I use Adobe live cycle designer 8.0.
I need to know if I can develop a project.
I work with a web application that opens a pdf form.
The form contains fields that display selected data from a db(SQL or ORACLE) , the form must also allow the modification of other fields in the db.
I have two questions:
1) I am able to view, insert and update records in a db using a form pdf?
2) a form pdf can accept an input parameter ("ID") to perform a db query to display the corresponding data of the record?

Sorry for my English,
Thank you very much

My Product Information:
LiveCycle Designer, Windows
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
If the DB is on the same system as the form and it is viewed in Acrobat (Not Reader), then the form can have a direct connection to the DB.

But if the DB is remote and/or the form is viewed in Reader, things get a little more difficult. Acrobat cannot communicate directly with a remote database. Instead, the form sends HTTP Requests to a server script, the server script communcates with the DB and sends the data back in an HTTP response.

Send an HTTP Request with a submit operation from the form. Use either the AcroForm Submit function, or a Regular LiveCycle Button, with the submit option set.

Data is sent and recieved by Acrobat in a variety of formats.

You'll have to look all of this information up in the XFA and Adobe XML forms references.

Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]

The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/javascript.php]http://www.adobe.com/devnet/acrobat/javascript.php[/url]

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script