Contributions
Pop up window ignored while executing test
Hey everyone! I've got a problem!.. it seems TC8 is ignoring the Pop-Up window when executing the test. Explanation: I recorded a test where there should be certain interaction with a Pop Up window in Windows XP. So when the window comes up TC is supposed to interact with that window as well. After recording the test as a Script TC8 generates the following lines : var xre2; var wndVirtualMonitor; var ct; var dictationToolbar; xre2 = Aliases["XRE2"]; xre2["dlgMeasurements"]["AfxWnd803"]["Click"](14, 14); wndVirtualMonitor = xre2["wndVirtualMonitor10"]; ct = wndVirtualMonitor["CT"]; ct["Drag"](91, 97, 57, 0); ct["Drag"](282, 97, 197, 0); ct["Drag"](406, 160, -270, 174); ct["Drag"](178, 162, 258, 241); ct = wndVirtualMonitor["CT1"]; ct["Drag"](129, 61, 218, 270); ct["Drag"](534, 72, -404, 172); ct = wndVirtualMonitor["CT2"]; ct["Drag"](460, 154, -12, 256); ct["Drag"](82, 198, 400, 19); ct["Drag"](547, 101, -456, 201); dictationToolbar = xre2["FrmDictation"]["pnlTopDictation"]["dictationToolbar1"]; dictationToolbar["Click"](186, 4); dictationToolbar["Click"](187, 21); xre2["FrmDraftPS"]["btnOk"]["ClickButton"](); Everything seems to be fine at this point but when running the it get stuck at the CT line. THe "Play/Pause" form says ..."Waiting for Ct to load" and remains like that until it logs the "The object does not exists" error and skip that step. As i can see TC8 has no interactivity with Windows XP Pop Up windows whatsoever unless i'm doing something wrong. Any hint? Best Regards, Jmc15KViews0likes1CommentRe: Oracle connection
Hey Guys, We finally made it! After hours and almost days of working on this stuff!! (just kidding) Is there any test developer position on Automated Qa?? kidding again! Alright, First we needed to download the driver. For some crazy reason we could not made this with Oracle nor Miscrosoft drivers. We had to download Progress DataDirect ODBC driver. Really cool! After reading loads of websites (I was actually wondering why Test Complete does not come with a nice Oracle connection example) we finally came up with the simpliest and most useful connection query... here's the example and once again thank you so much guys for your help. Cheers ! Jmc Example : function connect(){ var connectstring = "Data Source=dsnOracle;User ID=user;Password=password"; //3 params only!!! var patientlist = ADO["CreateADOQuery"](); patientlist["ConnectionString"] = connectstring; patientlist["SQL"] = "Select pat_lastname FROM pat_data"; patientlist["Open"](); patientlist["First"](); res = patientlist["FieldByName"]("pat_lastname")["Value"]; BuiltIn["ShowMessage"](res); }7KViews0likes1CommentRe: Oracle connection
No luck... The first one throws an exception that says : DataSource name not found and no Default driver specified Any hint?.. How comes there is no example available to test this.... TestComplete examples only show demos with CSV driver :S!! Well i'll keep trying! Thanks again!7KViews0likes0CommentsRe: Oracle connection
Yes indeed! Thank you so much i'll try these methods out. Hopefully everything is going to be fine. One of the main reasons was the fact that i could not successfully set up a ODBC with either Oracle or Windows Drivers. I do not know why. Fortunately i found a driver made by "Progress" which allowed me to connect with "DataDirect Oracle Wire protocol". Connection successfully Tested made me realize that the only further step would be to find the Right connection String. Gonna try this and let you guys know. Thank you so much for this it really helps...seriously guys both of you! Best Regards, Cmc7KViews0likes0Comments- 7KViews0likes0Comments
Oracle connection
Hey everyone! I've been surfing either the internet and some TC7 books but somehow nobody has ever written something about this feature. How can i connect to an Oracle database in order to retrieve data to be compared in my TC script? I'm currently working on a Script that tests functionality inside my app but i really need to get some data from the DB and compare it. Everything is cool except for the oracle connection. Is there any way to do this without having to set a dsn? Windows gets really buggy when comes to work with Oracle ODBC anyway... if there's any hint it certainly would be appreciated. Here's an example of what i'm trying to achieve : DDT.ADODriver("Driver={Microsoft ODBC for Oracle};Server=161.83.80.6;Uid=jmc;Pwd=secure;"); Notice the extreme complexity of my password.! Best regards and thx in advance. Jmc27KViews0likes11Comments