How to display a corresponding value in Combobox?

[aburayan]

Having a SQL table contains many columns. One of them contains integers of corresponding descriptions;i.e
1 for ready, 2 for done .... And i read the values and display the corresponding item list. How to do that? Thanks indeed.

[Cor]

Hi Aburyan,

You just can make an array something as this

\\\
dim AbArray() as string = {"", "ready", "done"}

dim descript as string = ABArray(mySqlvalue)
///

I hope this helps?

Cor

1 for ready, 2 for done .... And i read the values and display the

corresponding item list. How to do that? Thanks indeed.

[Armin Zingler]

"aburayan" <an*******@discussions.microsoft.com> schrieb

Having a SQL table contains many columns. One of them contains
integers of corresponding descriptions;i.e. 1 for ready, 2 for done
.... And i read the values and display the corresponding item list.
How to do that? Thanks indeed.

enum status
Ready = 1
Done = 2
end enum
'...
dim s as status
s = ctype(<IntegerValue>, status)
msgbox(s.tostring)
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Cor]

Hi Armin,

Thanks for that one was I looking, I will probably never use it because I do
not like Enum but I was curious how to do this.

Cor

enum status
Ready = 1
Done = 2
end enum
'...
dim s as status
s = ctype(<IntegerValue>, status)
msgbox(s.tostring)