How to Make A Graylite Grid

[YosuaA]

Hi, welcome back, after the previous meeting we discussed about what the grid is and the introduction of the grid’s contents itself, now we will discuss about how to make the grid.

Slide1.JPG (32.22 KiB) Viewed 16078 times

First step to make your detail, is get it in Detail Header Code in module configuration, then click add (no.1).
Second, fill the detail name / Code Form (no.2). Last, click OK button (no.3).

Slide2.JPG (55.65 KiB) Viewed 16077 times

Then, the name code have been printed in the code (no.4) line. For the Grid, the caption line does not need to be filled, actually(no.5).
Query to get the table and the results can be written in expression line (no.6).
Table’s name, which is the basis for this detail form can be written in Base Table (no.7).

Slide3.JPG (54.36 KiB) Viewed 16075 times

Your query will be set automatically tot he table after you click “auto generate”.If you need to change the table’s name, change it in the caption column in every line.
On the grid, there is an additional 1 column, the key column, each row has 4 options, primary, parent, index up, and, index down. for be able to inserted into detail, set key id becomes parent. Primary key can be set in another column.
If you need to change the type of table’s name, change it in the UI type column in every line. If you want to read-only or hide or update data at some or a column, check it. After all set, click save (no.8).
And if you want to see the result, click View Grid button (no.9).
And the Grid result is in bellow.

[YosuaA]

The result :

Slide4.JPG (13.59 KiB) Viewed 16075 times