mcmprashanthOccasional ContributorJoined 12 years ago6 Posts2 LikesLikes received1 SolutionView All Badges
ContributionsMost RecentMost LikesSolutionsThrowing error on the DB table Hi, Can someone suggest why testcomplete is throwing error on my table name statement (aCmd.CommandText = "account_name") as "Invalid object name". It appears to connect to DB fine as aCon.State is returning as 1. Not sure why it isn't accepting the table name. aCon = ADO.CreateConnection(); // Sets up the connection parameters aCon.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=XXXXXXX;Data Source=XXXX"; // Opens the connection aCon.Open(); Log.Message(aCon.State); // Creates a command and specifies its parameters aCmd = ADO.CreateCommand(); aCmd.ActiveConnection = aCon; // Connection aCmd.CommandType = adCmdTable; // Command type aCmd.CommandText = "account_name"; // Table name // Opens a recordset aRecSet = aCmd.Execute(); aRecSet.MoveFirst(); } SolvedRe: object spy window not showing up on screen Good news Robert. Managed to get it back after your tip. Yes it was hiding off the screen. I could not see even the bit of it on screen. Just hovered the mouse off screen through all the borders while attempting to drag... just few blind actions and then came the window from one of the corner. :manhappy: Silly issue it was. Thanks a lot for your help. Re: object spy window not showing up on screen Hi Robert Thanks a lot for quick reply. Unfortunately that did not work. I am not bothered with the second issue but thought it is worth mentioning here so it might help figuring down the issue by experts. object spy window not showing up on screen Hi Has anyone had this experience before that object spy window doesn't open upon clicking the Object spy button on toolbar? I have updated to version 12.20 this morning and not sure when it stopped opening object spy window, If I click on the object spy window, the test complete minimizes and nothing happens. Also, if I click 'Highlight on screen' menu item from Object Browser panel, the related object is highlighted but it doesn't take me back to Object browser panel as it used to before. I am kind of stuck at the moment with object spy issue. Is there any other way out if there is no quick fix for this so I can carry on my work? Thank you SolvedRe: run time error, 'object variable not set'Thanks Karas, Using nRow = tblCell.EditValue If nRow = ("Local") Then makes no difference. Tried using Evaluate Dialog but by the time script starts executing and accepting pause key to activate Evaluate Dialog, the script throws error leaving no space. However, EditValue is showing up as string in object browser, if that makes any sense. Any other way please? run time error, 'object variable not set' Hi, Can anyone help where my script is going wrong pls. The error is thrown at 'If nRow = ("Local") Then' script line. thanks in advance. Sub selectrow Dim nRow Dim tblCell Dim pnlObj Dim tblObj Set pnlObj = Sys.Browser().Page().Form().Panel() Set tblObj = pnlObj.Object(dir).SlObject("gridfrmobj").SlObjec("Grid").SlObject("dataPresenter") For i = 0 to tblObj.ChildCount - 1 Set tblCell = tblObj.SlObject("TextEdit", "", i) Set nRow = tblCell.EditValue If nRow = ("Local") Then Log.Message("FOUND") tblCell.ClickR 'ElseIf ... ......... Exit For End If Next End Sub