To create new records, click on the
in the menu on the top-right of the grid. To edit, click on
See also Example 320 for an alternative editing interface with a Child Editor in the
See Example 302 and Example 303 which uses the same data.
create table lensusers (
USERID char(16) not null,
PASSWORD char(16) not null,
FIRSTNAME char(24) ,
LASTNAME char(24) not null,
EMAIL char(48) not null,
ADDRESS1 char(48) not null,
ADDRESS2 char(48) ,
POSTCODE char(12) ,
CITY char(24) ,
STATE char(24) ,
COUNTRY char(24) not null,
CREATED datetime not null,
LASTMOD datetime not null,
primary key (userid)
This demo also shows you Google style scrolling. In this case, this is enabled by setting
$lens->scrollLinks = 9
which sets the number of scrolling links to 9.
Also notice that the fields FirstName/LastName and PostCode/City are on the same line in the Details Grid, and New/Edit
record forms. This is configured by checking "2 Fields in 1 Row" in the column settings for PostCode.
We also have section breaks with "Misc" and "Address" using the sectionLens property.