Search found 8 matches

by Zee357
Fri Aug 19, 2016 4:17 pm
Forum: How To …
Topic: Run sqlcmd and query database from script
Replies: 1
Views: 3582

Run sqlcmd and query database from script

Has anyone executed sqlcmd (command-line) utility from a Ranorex automation script and fired a T-SQL script to query the database?

I need to do this in a web application testing scenario that needs to both run SELECTs as well as INSERTs and DELETEs against the back-end SQL Server database.

Thanks.
by Zee357
Thu Mar 10, 2016 9:12 pm
Forum: Automation API
Topic: Stuck accessing SQL Server in code
Replies: 7
Views: 3569

Stuck accessing SQL Server in code

I'm trying to get a SQLClient database connector initialized and open then to run embedded SQL queries in my Ranorex user code. it is Failing on initialization of the connection string. Any code that is working for anyone out there, I'd love to take a look at it and how you are structuring the code ...
by Zee357
Thu Feb 18, 2016 5:55 pm
Forum: Automation API
Topic: SQL Delete Query - How to ?
Replies: 1
Views: 2768

SQL Delete Query - How to ?

How do I fire a SQL delete query to clear out records created by my web app? Is this a simple API call, or does it involve a SQL Data Connector to be setup?

All the steps / actions needed here.

Thanks.

Zee
by Zee357
Tue Feb 09, 2016 1:26 pm
Forum: Automation Tools
Topic: Scheduling Ranorex script execution - Tools ?
Replies: 2
Views: 2324

Scheduling Ranorex script execution - Tools ?

I am running my Ranorex .EXE automation scripts on a VM in an automated/scheduled way daily. Or trying to plan for that. What tool (Task Scheduler ?) is best on Windows Server 2008. I've heard of Jenkins, but we're not using that for anything else such as builds. It is only to schedule and execute t...
by Zee357
Wed Jan 27, 2016 8:47 pm
Forum: Automation Tools
Topic: Detect that a PDF document displayed in page
Replies: 1
Views: 1885

Detect that a PDF document displayed in page

I have a link that navigates to a PDF file within the browser. How do I validate the page as PDF document [displayed]? It does show the .PDF in the browser address toolbar: http://Orgname.org/education/partners/2013participationguidelines.pdf The script code is what I'm looking for. Not sure what re...
by Zee357
Wed Jan 20, 2016 4:55 pm
Forum: Automation API
Topic: How to find child TAGs in DOM tree?
Replies: 1
Views: 2551

How to find child TAGs in DOM tree?

I have Repo items in Web application that represent HTML tags that may or may not have children. I'll show examples below. I want to determine through script what the DOM tree is and manipulate it accordingly. Here I want to see what sits beneath <>TD. <>TBody <>TR <>TD <>TBody <>TR <>TD <>Big '20' ...
by Zee357
Thu Jan 07, 2016 5:18 pm
Forum: Automation Tools
Topic: No error info - The user code class has compile error
Replies: 2
Views: 2491

No error info - The user code class has compile error

I cannot find meaningful explanation of the error on Build when UserCode fails with message: Failed to update code for 'C:\QA\KC-Main\Tickets\MainSitePurchaseTickets\MainSitePurchaseTickets\PurchTC3.rxrec'. The user code class has compile errors - C:\QA\KC-Main\Tickets\MainSitePurchaseTickets\MainSi...
by Zee357
Wed Jan 06, 2016 1:12 pm
Forum: How To …
Topic: Saving offline and viewing log files?
Replies: 1
Views: 2060

Saving offline and viewing log files?

I saved the .rxlog and .rxlog.data files to a separate file folder and tried to load and view them in Ranorex studio unsuccessfully. I got the following message: Data file (<SolutionName>_20160104_144439.rxlog.data) or transformation file is missing. How do I save these files off and view them via R...