mcmprashanth
Occasional Contributor
Joined 12 years ago
User Profile
User Widgets
Contributions
Throwing 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(); }Solved1.1KViews0likes2CommentsRe: 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.2.2KViews2likes0Commentsobject 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 youSolved2.2KViews0likes4CommentsRe: 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?1.1KViews0likes0Commentsrun 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 Sub11KViews0likes4Comments