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…

PROCESAMIENTO AJAX EN SCRIPTCASE

Ajax en los formularios de Scriptcase puede usarse para recargar un campo de tipo de select basado e...

IMPORTAR IMAGENES DE LA BASE DE DATOS Y UTILIZAR CLASES DE BOOSTRAP

Como muchas personas ya saben, Bootstrap es una biblioteca de front-end libre y de código abierto p...

TENDENCIAS DE DESARROLLO WEB PARA 2017

Usted verá en este post tendencias para 2017 en Diseño Web, en el medio digital y en el desarrollo...

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.