cusers.cls

SQL Security with Visual Basic 6.0

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "CUsers"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = True
Attribute VB_Ext_KEY = "RVB_UniqueId" ,"3AA822070014"
Option Explicit

Private colUsers As Collection

Public Function Count() As Integer
  Count = colUsers.Count
End Function

Public Function Item(ByVal Index As Variant) As CUser
  Set Item = Nothing
  On Error Resume Next
  Set Item = colUsers.Item(Index)
  On Error GoTo 0
End Function

Public Sub Add(sName As String)
  Dim oNewUser As CUser
  Set oNewUser = New CUser
  oNewUser.Name = sName
  colUsers.Add oNewUser, sName
  Set oNewUser = Nothing
End Sub

Private Sub Class_Initialize()
  Set colUsers = New Collection
End Sub