How to add an IN PARAMETER Type TimeStamps in Stored Procedures calls?
I'm having problems calling a stored procedures from script, the error ocurred exactly when I try to add an in parameter type DBtimestamp.
this is the code:
var SProc;
SProc = ADO.CreateADOStoredProc();
CnnString = ProjectSuite.Variables.connectionString;
SProc.ConnectionString = CnnString;
SProc.ProcedureName = "SPRCOBJ.ASOLINGTER";
// Adding an in parameter:
SProc.Parameters.AddParameter();
SProc.Parameters.Items(0).name = "AUVI";
SProc.Parameters.Items(0).DataType = ftFixedChar;
SProc.Parameters.Items(0).Size = 5;
SProc.Parameters.Items(0).Value = "19709";
.
.
.
.
/* This is the problem */
// Adding an in parameter:
SProc.Parameters.AddParameter();
SProc.Parameters.Items(55).name = "TFHVGM";
SProc.Parameters.Items(55).DataType = adDBTime; //The error occurred exactly in this line of code.
//SProc.Parameters.Items(2).Size = 26;
SProc.Parameters.Items(55).Value = "2017-01-05-08.36.44.311000";
.
.
.
.
// Running the procedure
SProc.ExecProc();
Please I need help!!