To create new records, click on the icon 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 Details Grid.

 X: 0-9 A-Z             x: 0-9 A-Z optional       Z: 0-9 A-Z _            z: 0-9 A-Z _ optional
 #: 0-9                 9: 0-9 optional           +: positive numbers only
 &: any character       ?: any character optional \: escape character
 >: to uppercase        <: to lowercase           =EMAIL: email validation

Notes

See Example 302 and Example 303 which uses the same data.

Table schema

  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,
    AGE integer,
    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.

sameRowLens

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.

sectionLens

We also have section breaks with "Misc" and "Address" using the sectionLens property.