Back

Table and Grid formating
sqlDetail
SQL to use to display fields in the details Speed up your database retrieval by having seperate specialized SQL statements for retrieving grid results and detail results. Note that if you use this property, the lookupLens and powerLens properties will not work, because these properties affect the grid SQL, but not sqlDetail. Fortunately, this is a minor problem because you can use joins to simulate the behaviour of lookupLens, and use string expressions in your SELECT statement to generate the string formatting. Syntax `# by using 2 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');` Basic:No Advanced/Enterprise:Yes DynamicEdit:No [Version 2.0]