Back

Editing, Updating and Creating Records
getFieldsFromTables
If sql select statement returns no fields, then we get field info from these tables 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:No Advanced/Enterprise:Yes DynamicEdit:No [Version 3.0.6]