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

How do I confirm that a record was successfully inserted into my database

Forum Index > Forms: LiveCycle Designer > How do I confirm that a record was successfully inserted into my database
2011-02-01 17:39:20
Jimmy0306
Registered: Dec 11 2008
Posts: 32
Answered

Using Stefan Cameron's tutorial on Inserting records into a database(Databases:Inserting, Updating and Deleting Records), I was able to create a form that inserts records into an Oracle XE database using the sample form provided on the website. I can confirm that the record has been inserted by going to the Table, but I want the user to have a message displayed if the record has been successfully inserted (or an error message if the record is not inserted correctly). Can someone point me in the right direction?
Thanks in advance.
Jimmy

My Product Information:
LiveCycle Designer, Windows
Top
2011-02-02 05:49:33
#1
gkaiseril
Online
Expert
Registered: Feb 23 2006
Posts: 4307
Accepted Answer
Have you though of clearing the form and retrieving the added data from the database?

George Kaiser

Top
2011-03-04 18:09:03
#2
Jimmy0306
Registered: Dec 11 2008
Posts: 32
I figured this out. I used xfa.host.messageBox("Success")and xfa.host.resetData() after the SQL insert. Thanks for the suggestion. That way if record doesn't submit, the user never sees the popup.
Top