Re: Programatically set a database attribute

Hilary Stoupa — Sat, 26 Jan 2013 00:22:51 GMT

Hi - what's the error you are getting?

Programatically set a database attribute

DarrylGould — Fri, 18 Jan 2013 16:47:03 GMT

Hello

I am trying to programatically set a SQL database attribute, and I keep getting errors.

I am trying to use this code to set the @ComIPSCode value to 'CaseCode'. I am able to set other fields in the form to the CaseCode value, but for some reason I am unable to set the @ComIPSCode using this. Can anyone see any problems? Do I need a diferent method for setting a database attribute?

Try

Me.Errors.DeleteAll() webservConn.Execute(Nothing, OutputNav, ErrorNav)
Dim CaseCode As String

If CheckReturnStatus(OutputDoc) = False Then

CaseCode = GetCaseCode(OutputDoc)

Dim xNav As XPathNavigator = Me.CreateNavigator() Dim ns As XmlNamespaceManager = Me.NamespaceManager
xNav.SelectSingleNode("//dfs:myFields/dfs:dataFields/d:TrustDeeds/@ComIPSCode", ns).SetValue(CaseCode)

End If

Catch ex As Exception
System.Windows.Forms.MessageBox.Show(ex.InnerException.ToString)

End Try