Hii,
I need to set a VB variable so that it contains the value of a column in the mysql.
For instance :
my table name is storageinfo which consists of fields part_num, part_name, quantity etc. I want to put in to a variable (declared in VB) the quantity of a selected part_number.
I tried the below coding but a does not take the value of quantity.
THE CODE :
Code:
dim a as integer 

cmd.CommandText = "select tablename "& a &" = quantity where part_num = 6058;"
PLEASE HELP!

CS