I am creating a submit button (using InfoPath 2007) on a form that will be executed in SharePoint 2010. I have several fields that I want to send the data to a Quality Center (QC) database using a COM reference. I would also like to send some fields (some the same and some different) to a particular SharePoint 2010 list. Can someone provide some example syntax for the following:
Public Sub btnSubmit_Clicked(ByVal sender As Object, ByVal e As ClickedEventArgs)
Dim qcconn As New TDAPIOLELib.TDConnection
qcconn.InitConnectionEx("http://QualityCenter/qcbin/")
qcconn.Login("username", "password")
qcconn.Connect("Domain", "Project")
update(databasename)
set
FormTextObject1.text = database.table.field1
FormTextObject2.text = database.table.field1
DropDownObject1.text = database.table.field1
DateObject1.date = database.table.field1
End Sub