Archives

Apex Update Case Priority when Bad Words in Incoming Email

Updating a case priority of a case when you receive a email with some words in the body that will make it more important. By looking at the words you can update the priority to high so Support reps can faster attend to those cases

Rate this:

Read More

Update Fact tables for Data Warehouse in VB.Net

Private Sub btnUpdateFact_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdateFact.Click try Dim sqlupdatetable As String Dim counter As Integer counter = 0 If (btnUpdateFact.Text = “Update Facts”) Then btnAddFact.Enabled = False If (cbFTableName.SelectedIndex = -1) Then MessageBox.Show(“Please select a Table Name to update”, “Information”, MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If cmd.Connection = New […]

Rate this:

Read More

Update Dimensions Table for Data Warehouse in VB.Net

Private Sub btnUpdateDim_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdateDim.Click Try Dim sqlupdatetable As String Dim counter As Integer counter = 0 If (btnUpdateDim.Text = “Update Dimensions”) Then btnAdd.Enabled = False txtUnique.Enabled = False cbTypeUnique.Enabled = False txtPK.Enabled = False txtValUnique.Enabled = False If (cbTableName.SelectedIndex = -1) Then MessageBox.Show(“Please select a Table Name […]

Rate this:

Read More