If sql select statement returns no fields, then we get field info from these tables
Default:
Some databases do not return any field information if no records are returned (because the tables are empty). As a workaround, we have this property.
When sql select statement returns no fields, then we get field info from the fields of these tables (comma-separated).
Note: Make sure all tables listed have unique field names. Having order.id and product.id will confuse phpLens.Syntax
$lens->sql = 'select * from order, product where order.prod_id = product.id';
$lens->getFieldsFromTables = 'order, product'; Basic:Yes Advanced/Enterprise:Yes DynamicEdit:Yes [Version 3.0.6]
|