Database

Swelborn wrote:

This worked and it was the concatenation of the FirstName and LastName's

WHERE `cl_client_common`.`UniqueNumber-900` IN (select NUMBER from TEMPTABLE)

programmervb.netc++ wrote:

backing up production data restore

Alivemau5 wrote:

With (2) you wouldn't know which one is each..

public enum MatchStatus
{
  NotStarted = 1,
  FirstHalf = 2,
  HalfTimeBreak = 3
  //.. etc
}

Alivemau5 wrote:

With (2) you wouldn't know which one is each..

While myReader.Read
            cmbControl.Items.Add(myReader.GetString(1))
            lKeyIndex(lIndex) = myReader.GetValue(0)
            '
            lIndex += 1
            ' see if we need to redimension the array...
            If lIndex Mod iCurrentDim = 0 Then
                iCurrentDim = iCurrentDim + iDefaultDim
                ReDim Preserve lKeyIndex(iCurrentDim)
            End If
End While

SELECT `UniqueNumber`, `Description` FROM `ct_contsources_master` WHERE `Inactive` = 0 ORDER BY `Description`

Public Function fiSetComboIndex(ByVal lKey As Long, ByRef cboControl As ComboBox, ByRef lKeyIndex() As Long) As Integer
       ' this routine sets the current "SelectedIndex" to the lKey passed in...
       Dim iII As Integer
       Dim iKeyIndexLength As Integer = lKeyIndex.Length - 1
       '
       fiSetComboIndex = 0
       For iII = 0 To iKeyIndexLength
           If lKeyIndex(iII) = 0 And iII > 0 Then
               Exit For
           End If
           If lKeyIndex(iII) = lKey Then
               fiSetComboIndex = iII
               Exit For
           End If
       Next
   End Function

blah(comboBoxName.SelectedIndex)