View Source:   Products (Outlook Interface)

 
This is a Demo. You can not change anything for security reasons.
Back to Grid     phpLens Settings   Choose   Generate PHP Code   Remove All Settings   ?  
 
IndexColumn NameActual TypePHPLens Type
1PRODUCTID int[11]R: Autonumber
2PRODUCTNAME string[120]C: Character
3SUPPLIERID int[11]I: Integer
4CATEGORYID int[11]I: Integer
5QUANTITYPERUNIT string[60]C: Character
6UNITPRICE real[22]N: Numeric
7UNITSINSTOCK int[11]I: Integer
8UNITSONORDER int[11]I: Integer
9REORDERLEVEL int[11]I: Integer
10DISCONTINUED int[1]I: Integer
11NOTES blob[196605]X: Text
12ORDERDATE date[10]D: Date
 

Notes

This demo shows the use of a powerLens to set the anchor tag for PRODUCTNAME to drill down to details.

Note that each PHPLens object is created using a different ID (the first parameter in the constructor): outtop and outbot to ensure that there are no conflicts.