i am facing very strange scenario,
When i am fetching records from mysql database i am getting Nil value for the all columns whose datatype is 'int' and length is 1.
i am using mysql as database. and wrote following code to retrieve data.
sql = "select StoreCode from tblstorefile"
dim data as RecordSet
if data <> Nil then
txtStoreCode.Text = data.Field("StoreCode").StringValue
Where i am doing wrong.