Advanced grid options

In this section, we will discuss the more advanced features of the database grid.

As of version 2.2, there are quite some changes in behavior, and as the underlying JavaScript has changed, you have to perform a few tasks to get your Grids compatible.

For regular use: The field list has properties of the fields in the grid. The primary key option was already there but has become more important now. If you need to use the onClickRow (because of a master-detail, or you want to show the selected record), it is necessary to set the correct key(s). For new grids, this is done automatically. For existing grids, you need to specify. The record selection is now made on primary key instead of record number.

The uniqueid property is required to identify a specific row in the grid. The Unique id should always be safe for html e.g. alphanumeric. It should not contain chars which can break HTML e.g. ". 

If you have a master-detail relationship, the master would reset to its first page if you select a detail record. It required a small JavaScript change to suppress that, but this has now become a property (mastergrids). The grids that are added in this property will not refresh when you select another record.