Using grid applications Scriptcase is possible to work with the SQL option that shows important information regarding the command to run the database for the query to be processed and displayed.

To access the feature is very simple, just access the properties of the application and select the SQL.

sql-grid-1

On the screen that opens you have several options to edit, including:

  • The command that will be used in the database, you can even copy the code and use on your DBMS;
  • Which connection will be used to perform database access;
  • If you want to use a custom message if a record has already been inserted into the database, for example;
  • Other attributes such as color, size and font of the message and the use of variables.

sql-grid-2

With SQL feature you have full autonomy to edit what you need and to create applications that each times more customized and value-added.

Download now Scriptcase and more testing this functionality available to you.

You might also like…

Scriptcase & Web Services

This time I will explain how to work with web services inside the Scriptcase, directly with PHP and...

More updates in 9.4 version

Recently version 9.4 was released bringing a new design concept to the generated applications of Sc...

Taking a look at version 9.4

Scriptcase released its version 9.4, and this one brings many interesting news, specially regarding...

Comment this post

Get new posts, resources, offers and more each week.

We will use the information you provide to update you about our Newsletter and Special Offers. You can unsubscribe any time you want by clinck in a link in the footer of any email you receive from us, or by contacting us at sales@scriptcase.net. Learn more about our Privacy Police.