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…

How to implement A2F using Own Development in NodeJS in a Scriptcase application

A2F using Own Development in NodeJS A2F: In a previous article, we talked about Swivel as an extern...

Specialists or generalists, who gets a better advantage by using Scriptcase?

Hey there! Today  we will figure what are the ideal profiles for those who wish to take advantage o...

Disabling autofill and autocomplete Chrome browser in login screens

Hello, here I want to show an alternative to disable the autofill and autocomplete of the chrome bro...

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.