hi, how can i get datatype of certain table?
i use openschema(adschemaprovidertypes) like this;
getGetColumnDataType(j) = ClmnsTypeRecordset("TYPE_NAME")
but, i get only transact SQL here, before this i'm using;
getGetColumnDataType(j) = ClmnsTypeRecordset("Data_type")
but, it show some integer, such as 20, 3, and 21 and i dont know why
the result that i need is to get datatype like;
varChar(), int, Date *just like the one when create table in mysql
can anyone explain me why and how to get like VARCHAR, INT, DATE from vb6?
as i searching why, it seems that vb datatype is differentt with SQL server datatype, so how can i make it same as the one i want?
Thank you,
_nurhan