Database

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)

Alivemau5 wrote:

My question is, what is the correct way of modeling this?

I are Troll

developerit wrote:

then how to write the querry for this condition please give the example which helps me.

I are Troll

SELECT tableIdentity,
       case when groupstatus = 1 or groupstatus = 0 then 'In Progress' else 'OK' end GroupDesc
from tableOne
where tabid = T1;

delete from table where mycolumn = 0

delete from person where IsActive = 0