Allows you control what fields to display when editing or creating new records
Default:
Allows you to fine-tune your SQL to retrieve the minimum number of rows for every situation.Syntax
# by using several sql statements, we speed up grid access below:
$lens = new PHPLens($id,$DB,'select name from table');
$lens->sqlDetail = 'select bigcol1, bigcol2, bigcol3 from table');
# while we reserve the slower SELECT * from editing and record creation
$lens->sqlEditNew = 'select * from table'; Basic:Yes Advanced/Enterprise:Yes DynamicEdit:Yes [Version 2.0]
|