Using the SQLQuery Component

This example solution uses the SQLQuery component to retrieve data from the Chinook database Orders table. The SQLQuery Execute and GetTable methods are used.

 

Windows form

 

Automation

SQLQuery properties

 

To test the query, you must define the following parameters. Browse the Parameter property to display the SQLParameter Collection Editor dialog.

Runtime solution

 


Privacy | Trademarks | Terms of Use | Feedback

Updated: 18 June 2020

© 2016 - 2020 Pegasystems Inc.  Cambridge, MA All rights reserved.

 

OpenSpan data classification label