GetCustomerAddress function |
This example retrieves address information from a BC Meridian table.
Private Function GetCustomerData(ByVal CustomerName As String) On Error Goto errh Dim x Dim phone Dim address x = m_Designer.VaultDetails.Table("Customers").GetValues("CustomerName", CustomerName, Array("CustomerPhone","CustomerAddress")) 'If the customer was found, retrieve values of the columns If IsArray(x) Then phone = x(0, 0) address = x(1,0) GetCustomerData = Array(phone, address) Else 'If the customer was not found, return nothing GetCustomerData = Nothing End If Exit Function errh: MsgBox "Error in GetCustomerData:" & Err.Description GetCustomerData = Nothing End Function
Private Function GetCustomerData(ByVal CustomerName As String) As String() Try If ExtensionHost IsNot Nothing Then Using table As BCSTable = ExtensionHost.ScriptObjects.Vault.Table("Customers") Dim matchColumns() As String = {"CustomerName"} Dim matchValues() As String = {CustomerName} Dim outColumns As String() = {"CustomerPhone","CustomerAddress"} Dim x = table.GetValues(matchColumns, matchValues, outColumns) 'If the customer was found, retrieve values of the columns If x.Length >= 1 Then Dim phone = x(0,0).ToString Dim address = x(1,0).ToString Return New String() {phone, address} End If End Using End If Catch ex As Exception MsgBox("Error in GetCustomerData:" + ex.ToString()) End Try 'If the customer was not found, return nothing Return Nothing End Function