Back

Editing, Updating and Creating Records
sqlEditNew
Allows you control what fields to display when editing or creating new records 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:No Advanced/Enterprise:Yes DynamicEdit:No [Version 2.0]