Member Avatar for veledrom

Hi,
Code below retrieves some of the enum values, not all.
Why?
Thanks

Dim RST As New ADODB.RecordSet
Combo1.Clear
RST.Open "Select Distinct Title From MyTable",Conn
If Not RST.EOF  Then    
RST.MoveFirst   
Do While Not RST.EOF
       Combo1.AddItem RST(0) & ""
       RST.MoveNext
   Loop
End If
  • 2 Contributors
  • 2 Replies
  • 94 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by veledrom
Member Avatar for QVeen72

Hi,

It should Retrieve all Distinct Column from the table.. Can you post some Sample data as of what kind of string is left out....?

Regards
Veena

Member Avatar for veledrom

Hi,

If any of enum value is not recorded ina column then, it doesn't return the enum value. This is what i have find out. Therefore, if table has no record then i can not populate enums into combo.

Thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.