We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More
This site is now read-only. You can still browse and search as usual. Learn More
Try to run it with this peace of code:
var sql =
`
// sql or procedure
`;
var conn = ADO.CreateCommand();
conn.ActiveConnection = connectionString;
conn.CommandType = adCmdText;
conn.CommandText = sql;
conn.CommandTimeout = 6000;
try {
var exe = conn.Execute();
} catch(exception) {
Log.Message("FAIL");
}Sure Wamboo .
// Adding a return parameter
SProc.Parameters.AddParameter()
SProc.Parameters.Items(0).name = "RETURN_VALUE"
SProc.Parameters.Items(0).DataType = adInteger
SProc.Parameters.Items(0).Direction = adParamReturnValue
SProc.Parameters.Items(0).Value = null
//Adding an in parameter
SProc.Parameters.AddParameter()
SProc.Parameters.Items(1).name = "@timeOfBuild"
SProc.Parameters.Items(1).DataType = adDate
SProc.Parameters.Items(1).Value = aqConvert.strtoDate("2020-05-19")
SProc.CommandTimeout = 75;
SProc.ExecProc();
Hi,
Try to check this article
https://support.smartbear.com/viewarticle/65800/
maybe this will help You.
Hi Thanks for that link. I have tried two TestComplete ADO constants for Date/DateTime mentioned but i am running into below issues
Tried adDate as Datatype but got into "application uses a value of the wrong type for the current operation" issue.
Tried adDBTimeStamp but got into "arguments are of the wrong type, are out of acceptable range, or are in conflict with one another"
Can you confirm if it's because I am passing date in String format? If so, how can we pass the same?
If I understand you correctly. You're trying to run a procedure that already exists in the database, right?
If so... You must pass a parameter with the correct dataType.
Connect to the database and check the type of value in the column you're looking for.
Wamboo , Thanks for your reply. Yes, I am trying to execute a Stored proc which is available in DB.
I checked the parameter DataType in DB and is "datetime"
As mentioned in below screenshot I tried those two TestComplete constants but I was getting the errors mentioned in my previous comment.
Am I missing anything here?