artur0409
Occasional Contributor
Joined 13 years ago
User Profile
User Widgets
Contributions
Re: CreateADOStoredProc and a adVarChar Parameter
I got answer from SmartBear on my previous case to use such syntax - so DataType seems to be correct - quote: Hello, Here is code that should work for you [C#Script] // ... Cmd["CommandText"] ="dbo.Bin_DeleteItems"; Cmd["CommandType"] = DB["adCmdStoredProc"]; var param = Cmd["Parameters"]["AddParameter"](); param["Name"] = "XMLListOfIds"; param["DataType"] = DB["adPersistXML"]; param["Direction"] = DB["adParamInput"]; param["Value"] = XmlString; RecSet = Cmd["Execute"](); // ... Best regards, Jay3.2KViews0likes0CommentsRe: CreateADOStoredProc and a adVarChar Parameter
I have similar problem with SQL Server 2005 I'm trying to execute following command exec ZipStoreConversions @ProductId=N'GMVE 000057',@ParameterCollectionID=N'FH',@ConvertToProduct=N'VIT 000100',@ConvertFromProduct=N'' parameters definiod from stored procedure @ProductID varchar(11), @ParameterCollectionID varchar(50), @ConvertToProduct varchar(11), @ConvertFromProduct varchar(11) I use following code - it always give me error in line param1["DataType"] = DB["adVarChar"]; "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another" Do I do something wrong? Cmd["CommandText"]= "dbo.ZipStoreConversions" Cmd["CommandType"] = DB["adCmdStoredProc"]; var param1 = Cmd["Parameters"]["AddParameter"](); param1["Name"] = "ProductId"; param1["DataType"] = DB["adVarChar"]; param1["Direction"] = DB["adParamInput"]; param1["Value"] = "GMVE 000057"; var param2 = Cmd["Parameters"]["AddParameter"](); param2["Name"] = "ParameterCollectionID"; param2["DataType"] = DB["adVarChar"]; param2["Direction"] = DB["adParamInput"]; param2["Value"] = "FH"; var param3 = Cmd["Parameters"]["AddParameter"](); param3["Name"] = "ConvertToProduct"; param3["DataType"] = DB["adVarChar"]; param3["Direction"] = DB["adParamInput"]; param3["Value"] = "VIT 000100"; var param4 = Cmd["Parameters"]["AddParameter"](); param4["Name"] = "ConvertFromProduct"; param4["DataType"] = DB["adVarChar"]; param4["Direction"] = DB["adParamInput"]; param4["Value"] = ""; RecSet = Cmd["Execute"]();3.2KViews0likes0CommentsRe: Updating XML Checkpoints from scripts
Here is some background The same test is executed against six environments - one by one. There is a part in the XML Checkpoint which is dependant on environment (few elements from pretty complex XML) and in current situation we cannot override this value in some nice and easy way. Since there is also not possible to set update mode in the runtime - full verification cannot done and we have to resign from some our automation goals I guess we can access directly xml file from XML Checkpoint folder - but that's dirty way727Views0likes0CommentsUpdating XML Checkpoints from scripts
At address http://support.smartbear.com/viewarticle/29981/ there is arcticle about this problem There is also chapter inside "Updating Checkpoints at Runtime" saying that you can update XML checkpoint by loading content of file stored on disk , but first you have to Enable the Update XML data option in the Stores settings. Two questions: 1) Can I set this option directly from scripts and go back when XML checkpoint is updated ( runtime) ? 2) Is it possible to modify only part of XML checkpoint in runtime - e.g. specific element's value - can you give any example of such code in C# script? Best Regards Artur21KViews0likes3Comments