phpLens
 home • products examples manual • faq support forum • contact news • login store

More Examples:   View Source:   Subtotaling

Free Download
This is a Demo. You can not change anything for security reasons.
Back to Grid     phpLens Settings  Column Settings   Choose   Generate PHP Code   Remove All Settings   ?  
 
Cancel
FieldDISCONTINUED   Type: int   Change Type
Default Title
Grid Title
Edit Title 2 Fields in Row
New Title 2 Fields in Row
Edit Notes
Detail Title 2 Fields in Row
Filter Title
Input Dimensions
(suggested size: 16)		Columns:

Power Lens
Lookup Values
Input Type       Enter a lookup to allow check boxes and radio buttons
# check/radio columns
Overlib Text
Search Lookup when editing
Matching above sql with fields
Minimum character length   Search mode   Hide key code
Validation
 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
Validation Error Msg
Default New Value
Prefix value with = to execute PHP code and % for SQL function
Power Edit Lens
TD Attributes   (nowrap, width=30%, align=center etc.)
Cell Color  
Color Reference opens in a new window

Section Break Title
Back color   CSS class

WYSIWYG Editor for fields that accept HTML
Must FillNo   * Must Fill Columns
Read OnlyNo   - Read Only Columns
Visible in GridNo   Grid Columns
Visible in DetailsYes   Detail Columns
Visible in New RecordYes   * New Record Columns
Visible in Edit RecordYes   * Edit Columns

Charting
Chart ImagesGIF/JPEG file:
Image for negative values (only for bar chart):
Chart DimensionsWidth:   Height:
Chart Min/Max (SQL)SQL to get Min/Max field values:
Example SQL: select min(DISCONTINUED),max(DISCONTINUED) from products
Chart Min/Max (manual)Minimum field value:   Maximum field value:
Use manual entry if Chart Min/Max (SQL) left empty
Icon Chart ScaleOne icon/character represents unit(s)
  Cancel
PHPLens: 4.9.0   Data: 0.02   DB: mysql   adodb: 4.62   Compat: 2   PHP: 4.3.10   OS: Linux
License Type: Enterprise   ID: (Natsoft;John Lim;jlim@natsoft.com)   Valid Till: Never Expires

Notes

We set the sumLens property to get the totals and subtotals.
email: info#phplens.com (change # to @)     telephone (malaysia): 60-3 7806 1216     fax (malaysia): 60-3 7806 1210