蛙蛙请教:CreateParameter的type选择问题

onlytiancai 2004-07-22 01:52:46

蛙蛙请教:CreateParameter的type选择问题
在创建参数的时候要指定参数的类型,可是我发现adovbs.inc里定义的数据类型和sqlserver里定义的数据类型并不是一一对应的,请问一下下面

的类型各对应adovbs.inc里的哪个编号呀
bit
char
datetime
int
bigint
smallint
char
varchar
nchar
nvarchar
money
text
ntext
binary
varbinary
有的类型我没有列出来,我只列了几个常用的,大家谁要是知道的话,请在我上面列出的类型的后面写上它的序号,谢谢大家了.
下面是adovbs.inc里定义参数类型的部分,你可以参照一下下面的东西我现在只用过varchar,我用的代码是202,有人说用200,晕,还是大家给偶

个正确答案吧,是不是有varchar既可以用200(adVarChar)也可以用202(adVarWChar)呀,这里有没有什么说法呀?

Const adEmpty = 0
Const adTinyInt = 16
Const adSmallInt = 2
Const adInteger = 3
Const adBigInt = 20
Const adUnsignedTinyInt = 17
Const adUnsignedSmallInt = 18
Const adUnsignedInt = 19
Const adUnsignedBigInt = 21
Const adSingle = 4
Const adDouble = 5
Const adCurrency = 6
Const adDecimal = 14
Const adNumeric = 131
Const adBoolean = 11
Const adError = 10
Const adUserDefined = 132
Const adVariant = 12
Const adIDispatch = 9
Const adIUnknown = 13
Const adGUID = 72
Const adDate = 7
Const adDBDate = 133
Const adDBTime = 134
Const adDBTimeStamp = 135
Const adBSTR = 8
Const adChar = 129
Const adVarChar = 200
Const adLongVarChar = 201
Const adWChar = 130
Const adVarWChar = 202
Const adLongVarWChar = 203
Const adBinary = 128
Const adVarBinary = 204
Const adLongVarBinary = 205
Const adChapter = 136
Const adFileTime = 64
Const adPropVariant = 138
Const adVarNumeric = 139
Const adArray = &H2000

...全文