How to create parameters for adNumeric data type?

Hi, I am trying to connect to sql server by using ADO to insert a record via stored procedure. I keep on encountering this error message (Source: Microsoft OLE DB Provider for SQL Server Description: The precision is invalid.)I had read on several blogs and forums and it said that one of the parameters which is adNumeric type need to define the numeric scale and precision during parameters append. May I know how to define the numeriv scale and precision value for adNumeric during parameters creation?

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!