Thank you for your request. There are situations where this makes the best sense.
At the same time those asking for view support might be missing a much better alternative.
Stand-alone views are largely divorced from the underlying data structure. This means that dbFront can't automatically generate lookups, use indexes or bring in other related tables.
In addition, it is very difficult to implement the ability to update data through a View, even if the view itself is considered updateable. Part of the issue is the need to identify the appropriate PK for the table and field that is being edited.
For example, if you want your users to look at a specific table:
- possibly filtered,
- with the related data expanded,
- some summary information,
- and allow editing of the primary fields...
... then you would be MUCH MUCH further ahead by creating and joining a small view to the current table to supply any extra or summary information. dbFront can then provide all of the other functionality for free.
ORACLE: Update/Insert through views
SQL Server: Update/Insert through views
NOTE: Please vote on this Feature Request if it interests you.