Editable Grid

This example covers the editable grid view form of type .

Creating a Form application.

1. Create a Editable Grid view form application based on the table orders.

2. In the application menu click in Fields Positioning.

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

Editing Form Fields

4. In the application menu access the folder Fields, click on the CustomerID field and change the Data Type attribute to Select.

5. Click in the edit tab Edition Lookup for the CustomerID field and enter the instructions below for the SQL Select Statement:

SELECT CustomerID, CompanyName 
FROM customers 
ORDER BY CustomerID

6. Click in the EmployeeID field and change the Data Type attribute to Number Auto-complete

7. Click in the edit tab Edition Lookup for the EmployeeID field

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

SELECT EmployeeID, LastName 
FROM employees 
ORDER BY EmployeeID

9. Enable Capture Text and enter Search for the Label attribute.

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

Registration Form 1- You must create a new application of the type Control and configure it as s...

Fields Digital Signature, Select2, Switch and Slider

This example demonstrates the form fields added in version 9.2 of Scriptcase: Digital Signature, Ra...

Comment this post