Hi all,I have question regarding one of my insert SPs. One of the parameters is of Decimal datatype and I'm using ADO to append and create these parameters in a command object.CmdObj.Parameters.Append CmdObj.CreateParameter _("SequenceNum", adDecimal, adParamInput, ???, strSeqNum)Would anyone know what I would need to place in the '???' area so that VB knows that it needs to take that parameter and insert it as a decimal datatype with a PRECISION of 7 and a SCALE of 4??? I assumed that I'd place a 7 there, but I think that's what's causing my error. Any tips would be appreciated, thanks!!!Jay
Input parameters & Insert SP???
Posted - 2001-11-01 : 16:32:08