In Delphi we have what is known as Data-Aware controls. A Delphi control is like a B4X view.
This makes working with databases soooo much easier. The data-aware controls (DAC) are almost identical to their non-data-aware control except they have a few data related properties like Datasource, FieldName.
All of the retrieving of the table data and filling in the field values to the DAC's are done automatically whenever the table is opened or moved to a different record, or a new record is added or deleted. In other words, any CRUD operation done to the Table will automatically update the DAC's that is connected to that table (via its Datasource property). A Datasource is an intermediary non-visual control that points to a Table. This allows the Datasource.Table property to be changed and switched to a different table (or database) without modifying the DAC properties. (Example: If we have 2 dozen DAV's on the screen and we need to change that table from Cust to Cust2, we don't need to update 2 dozen Viewsx.Table properties from "Cust" to "Cust2". We only update the Datasource.Table property from "Cust" to "Cust2". This makes the screen easy to maintain when we swap out similar tables, even those tables from different databases (with similar table fields).)
Why can't this be done in B4x? Or has it been done? Or is there a reason why it can't or shouldn't be done?
TIA
This makes working with databases soooo much easier. The data-aware controls (DAC) are almost identical to their non-data-aware control except they have a few data related properties like Datasource, FieldName.
All of the retrieving of the table data and filling in the field values to the DAC's are done automatically whenever the table is opened or moved to a different record, or a new record is added or deleted. In other words, any CRUD operation done to the Table will automatically update the DAC's that is connected to that table (via its Datasource property). A Datasource is an intermediary non-visual control that points to a Table. This allows the Datasource.Table property to be changed and switched to a different table (or database) without modifying the DAC properties. (Example: If we have 2 dozen DAV's on the screen and we need to change that table from Cust to Cust2, we don't need to update 2 dozen Viewsx.Table properties from "Cust" to "Cust2". We only update the Datasource.Table property from "Cust" to "Cust2". This makes the screen easy to maintain when we swap out similar tables, even those tables from different databases (with similar table fields).)
Why can't this be done in B4x? Or has it been done? Or is there a reason why it can't or shouldn't be done?
TIA