Deleting Record from SQL Database

[Colin]

Hello,

I have a form that queries an SQL database. What I am looking for is
JScript code that would allow me delete the current record from the database
at the click of a button. I would really appreciate any assistance anyone
could provide.

Thank you,

Colin

 

[Kalyan Reddy]

Hello Colin,

I dont think we can directly delete a row in the database from InfoPath.
We either use a webservice to delete a row or we need to write a custom
logic in InfoPath form code. But the custom logic will require full trust to
the form.

Take a Look at the Links below.
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=906
http://www.pcreview.co.uk/forums/thread-1209366.ph
http://forums.devshed.com/asp-programming-51/always-deleting-first-record-359234.html

This should help you.

 

[S.Y.M. Wong-A-Ton]

How do you have your form set up? Is it bound to 1 database table? And how do
you select a record? Are you using a repeating table to show records?

Deletion of records at the click of a button is possible through JScript
code; it just depends on the setup of your form.

 

[Colin]

Yes it is bound to 1 database table, and yes I am using a repeating table to
show the records.

At this point I am using the record ID to query the database and populate
the information into the form.

 

[S.Y.M. Wong-A-Ton]

You can add a button to the repeating table. This button will appear for each
record. Add a field to the Main data source to save the ID of the record to
delete. The value of the field must be set through a rule on the button in
the repeating table (don't forget to use current() when doing this). Once you
have the ID of the selected record, you can use code behind the button in the
repeating table to retrieve this ID, use it in an XPath filter on the XML of
the Main DOM to retrieve the node to delete, use the removeChild() function
to delete the selected node, and then submit the form back to the database
using the Submit() function.