Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

DB Sharp Studio

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.

systemadministrationdbsharp

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.

Published:

DB Sharp Studio

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.

systemadministrationdbsharp

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.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk