Insert or update data to database

[dhavalbakhda]

Hi,

I want to know what is the procedure to insert or update form template data to the database using webForm module???
I have created database table associated with Form template.


Regards,
Dhaval

 

[ggriffit]

Dhaval,
When you submit the form, Livelink deals with the Saving of data from the form into the database and when you open the form Livelink deals with the loading of data from the database to the form.

Does that answer your question ?

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[dhavalbakhda]

Thanks Greg Griffiths for replying

Agreed, that while submitting the form template, form data will be stored into database.

In my case there are some check boxes in the form template and i want to insert data using onchange event before submitting the form template...

Is it possible ???


Regards,
Dhaval

 

[ggriffit]

I assume that you mean the Javascript OnChange event ? If so then as long as that script happens prior to the form submission the final state of the form will be submitted to Livelink - you can see this by looking at the HTTP Request - and so your updates should be there.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[dhavalbakhda]

Yes all the Form template values will be inseted to the database while submitting the form. But in addidtion to the i want to insert some additional field (some random unique number) inside the database which is not created in the Form template. Is it possible???

 

[ggriffit]

There are a few ways to do this, you could use a database trigger or a sequence to add the additional value to the table, be aware that if you change the underlying schema tables for a Form Template then the Template will report a difference between what it expects and what it has, so you will need to know what "differences" are due to changes to the template that have not been synchronised and what is due to your additions to the DB

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/