ADODB Decimal parameter size spec

[ronspree]

How do I specify size (Decimal(18,9)) in the following code:

    Dim cmd As ADODB.Command
    Set cmd = New ADODB.Command
    cmd.ActiveConnection = CurrentProject.Connection
    cmd.CommandText = "strGetQuantity"
    cmd.CommandType = adCmdStoredProc
    cmd.parameters.append cmd.createparameter("@Quantity",adDecimal,adParamOutput, [red][b]???[/b][/red])
    . . .

 

[cmmrfrds]

You will probably need to use adNumeric.

Check this link for valid data mapping.

http://www.w3schools.com/ado/ado_datatypes.asp

 

[ronspree]

Thank you. And thank you for the link.