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…

AJAX: What it is and how to use it in Scriptcase

Hello, in this post we will conceptually understand the AJAX event and how use  inside the Scriptca...

What advantages for a company in adopting a low-code tool?

Let's understand how low-code tools have become a facilitator in the web development process as they...

How to implement A2F using Swivel in a Scriptcase application

I want to start talking about Swivel, Swivel is a provider of authentication solutions who have been...

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.