ODBC connection and delete the Notes document

HCL Domino Domino Forum
1

Hello,I was able to create a new document and update it for changes. How I delete the Notes document for the data that is not available in the SQL table anymore.

Do

		dept = result.GetValue("Dept_Name")

              fname = result.GetValue("Dept_Contact_Fname")

			

	update=0			

		Set deptdoc = deptview.getdocumentbykey(dept)		

		

		If deptdoc Is Nothing Then

			Set newdoc = db.createdocument

			newdoc.Form = "Contact Update"

			NewDoc.Dept_Name = dept

			

			Call newdoc.computewithform(False,False)

			Call newdoc.save(True,False)	

		else			

		If dept =  deptdoc.Dept_Name(0) Then

				' check department info	and update		

				

				If fname <>  deptdoc.Dept_Contact_Fname(0) Then 

					deptdoc.Dept_Contact_Fname= fname

					update="1"

				End If

				

		End if

		End if

Thanks!!!