ContributionsMost RecentMost LikesSolutionsDetecting batcher end on DOS command windowHi, I execute a batch file on a server via command window. Is there a way to detect when the batch file has completed it's run? I mean only thing that happens is that input comes available in the command window again. Currently I am only adding so long delay that it for sure has run the batch but it would be naturally better if I could somehow verify the completition - any hints for that how to manage? Cheers Re: Unable to get selectNode to work =/I added following and now it returns a node: Doc.setProperty("SelectionNamespaces","xmlns:rs='urn:schemas-microsoft-com:rowset'") But do I always have to do this manually? Add selectionnamespaces from actual xml before I can use selectNodes?Re: Unable to get selectNode to work =/<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882' xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882' xmlns:rs='urn:schemas-microsoft-com:rowset' xmlns:z='#RowsetSchema'> forgot to add this from beginning of xmlUnable to get selectNode to work =/Hi, I have rather large xml file with schema included. I would like to use selectNode to reduce the amount of choises instead of going through each node in the xml file. in my XML file I have a node group as follows: <rs:data> <this and that> </rs:data> but when I try to use selectNode as follows... nodes = Doc.SelectNode("//rs:data") I get an object calling error always. I tried to follow example from: http://support.smartbear.com/viewarticle/32705/ Error is "msxml6.dll reference to undecleared namespace prefix: 'rs' any ideas how to fix that? Cheers Re: Unable to store database tablet values to excelThanks a million :) - I'll be sure to try it and will post here how it goes. Cheers, TeemuRe: Unable to store database tablet values to excelAs a workaround I create file from each SQL query but if someone has hints how to get them stored for one file that would be great :)Unable to store database tablet values to excelHi, I have (again) a problem :) - sorry for flooding the forums. I have a scenario where I have a large set of SQL queries stored in an excel. I would like to run through them and store the values to a new excel but I feel quite dump since I seemingly cannot get a working solution how to get all those tables from DB stored up for saving. Code follows... code runs but I don't get anything when I try to log the results - any hints, should i resturcture completely or anything really is appriachiated a lot :). function checkout() { var Excel = Sys.OleObject("Excel.Application") var searchSQL var result ="" Excel.Workbooks.Open("c:\\MyExcel.xlsx") var RowsCount = Excel.ActiveSheet.UsedRange.Rows.Count; Log.Message(RowsCount) for(i=1;i<RowsCount;i++) { searchSQL = Excel.Cells(i,1); result = result + RunQuery(searchSQL); } RecSet = result; RecSet.Save("c:\\MyAnother.xml",1) Excel.Quit() } function RunQuery(aSQL) { var Conn; Conn= ADO.CreateConnection() Conn.ConnectionString="my connection string"; Conn.Open(); Cmd = ADO.CreateCommand(); Cmd.ActiveConnection = Conn; Cmd.CommandType = adCmdText; Cmd.CommandText = VarToStr(aSQL) RecSet = Cmd.Execute(); var Result = RecSet Log.Message(RecSet) Conn.Close(); return(Result); } Re: Error - ORA-00911: invalid characterAh - this was the matter of ';' in the end of SQL query in my excel - as such it was correct but when added through script it caused an issue :).Re: Error - ORA-00911: invalid characterI tried now to separate excel and query parts to own functions and now it gives another error :) Identifier is too long on same Cmd.Execute() part :(Error - ORA-00911: invalid characterHi, I have a list of queries in SQL in an excel to be executed in order to test our database. I try to read them out and do the queries with following code but keep getting this error on subject on bolded part, any ideas why? function checkout() { var Conn var Excel = Sys.OleObject("Excel.Application") Conn= ADO.CreateConnection() Conn.ConnectionString="My connection String"; Conn.Open(); Cmd = ADO.CreateCommand(); Cmd.ActiveConnection = Conn; Cmd.CommandType = adCmdText; Excel.Workbooks.Open("c:\\querys.xlsx") var RowsCount = Excel.ActiveSheet.UsedRange.Rows.Count; for(i=1;i<RowsCount;i++) { Cmd.CommandText = Excel.Cells(i,1) Log.Message(Cmd.CommandText = Excel.Cells(i,1)) // Line below gives the error RecSet = Cmd.Execute(); } RecSet.Save("c:\\tietokanta.xml",1) Conn.Close(); Excel.Quit() }