TAHbKA
Occasional Contributor
Joined 13 years ago
User Profile
User Widgets
Contributions
Re: Qry.First() remains undefined
Tanya, I removed here all the data that was specific for my querries. I specified the password, user id, data source and table name. It's really var Qry; Qry = ADO.CreateADOQuery(); Qry.ConnectionString = "MSDAORA.1;User ID=<my user id>;Data Source=<my data source>;Password=<my password>;Persist Security Info=False" Qry.SQL = "select count(*) from <my table name>"; Qry.Open(); Qry.First(); var result = (Qry.FieldByName("count(*)".Value));544Views0likes0CommentsQry.First() remains undefined
Am trying to run a code which is pretty much similar to your example here http://support.smartbear.com/viewarticle/30926/ My connection seems to be fine, when am looking in a debugger on the QRY object after QRY.Open() it shows recordcount 2, fieldcount 7, which is correct. I was also able to create a DBTables object, so assume my connection and the query are fine. However, the QRY.First() remains undefined for some reason. It worked fine in the previous Testcomplete version. This is my code function QeryTry() { var Qry; Qry = ADO.CreateADOQuery(); Qry.ConnectionString = "Provider=MSDASQL.1;Password=;Persist Security Info=True;User ID=;Data Source=" Qry.SQL = "select * from "; // Execute the query Qry.Open(); Qry.First(); var result = (Qry.FieldByName("".Value)); Log.Message("Found " + result); return result; } this is the result Field '' not found Error location: Unit: " " Line: 687 Column: 5. What am I missing? Thanks!4.1KViews0likes2CommentsExport a list of planned tests from `Organize tests' into a text/excel?
Am organizing the tests to run with `Organize Tests'. I want to see the list of tests which are to run in a text/excel/whatever (not a picture) file. Is it possible? Realize I'll be able to export the results after the tests were completed, but I want it BEFORE running the said tests. Is it possible? Thanks!6.1KViews0likes1CommentRe: Test log question
Saurabh, think I was clear enough with what I want. I want all the messages that appear in the log now and some additional ones. I.e. I do want all the `Errors'/`Warnings'/`Checkpoints' etc to appear as they do now, and in ADDITION I want some fields of my own. Yes, I can write Log.Message("Success"), but I want to be able to use filtering that is provided with `error'/`warning' etc. I.e. I will want to see the whole log, my boss will only want to see the `fail'/`success' part.1.9KViews0likes0Comments