Editable Grid

We can create an editable grid in order to add, remove, update or remove rows and records within the cells in just a few steps. The editable grid application into scriptcase is considered one type of form.

Creating a form application.

1. Create an editable grid view form application based on table orders.

2. In the application menu, select Fields Positioning.

3. Delete all fields except OrderID, CustomerID, EmployeeID, OrderDate and RequiredDate

Edit form fields

4. In the application menu, access the folder “Fields”, select CustomerID and change the Data Type attribute to Select.

5. Click on the edit tab Search Edit for the CustomerID field and enter the instructions below for the SQL selection statement:

SELECT CustomerID, CompanyName
FROM customers
ORDER BY CustomerID

6. Click in the EmployeeID field and change the Data Type attribute to AutoComplete Number

7. Click the Edit Search tab for the EmployeeID field

8. Enter the instructions below for the SQL Select Statement:

SELECT EmployeeID, LastName
FROM employees
ORDER BY EmployeeID

9. In the EmployeeID field go to the Edition Lookup option and paste the SQL statement.

10. Click the Run button on the toolbar.

Tutorials in the same category

Login Form

1- You must create a new application of Control type and configure it as shown in the image below. ...

Contact Form

In this tutorial we will be preparing an application of the Control Form type in which the format w...

Registration Form

Lets' create a registration form. we can follow the steps below: 1- A new control type applicati...

Fields Digital Signature, Select2, Switch and Slider

This example shows the form fields added in Scriptcase version 9.2: Digital Signature, Classificati...

Comment this post