DB Sharp Studio
[Data Sources] - Data Provider
The DB Sharp Studio interface lets you write SQL scripts that can be used in Bizview for different purposes. This interface should be seen as an alternative to SQL Server Management Studio. It enables the solutions designer to access existing Data Sources and write necessary scripts for fetching data from these sources.
Access DB Sharp Studio by selecting System Administration > Data Services > DB Sharp Studio.
To write a new script, select the New button in the ribbon. An empty script opens, and you are free to start writing the script.
Below is a list of available buttons in the DBStudio ribbon:
Button | Description | Note |
---|---|---|
Connect | Connects to selected Connection. | The Connections that are available are the ones defined in Data Sources. |
New | Opens a new empty script template. | |
Execute | Executes current script. | |
Cancel | Cancels execution of current script. | |
Copy Result | Copies results to clip board. | |
Open | Opens an existing script. | |
Save | Saves the script. | |
Delete | Deletes the current script. | |
Import | Imports SQL script. | |
Export | Exports SQL script. |
Additional Information
Usage
One common use of these scripts is to use them in Selection Pane list to fill these and/or set default values. They can also be used as a Break procedure. The usage can basically be anything, depending on the actual script purpose and design.