View and Index Windows

One window shows SQL for views and lists

• This window is shown automatically
• Displays SQL for selected view or index
• SQL can be edited and saved (Update) or used for new view or index (Create)
• The SQL needs to be in the format stored by SQLite
  
• The name of the View or Index should not include the table name--that comes from combobox at top right
• "if not exists" must not be present.
  
• The attached file name can be used in the SELECT statement but shouldn't be--view becomes invalid if file is attached with another name
• SQL for all views (including TEMP views) is saved in cmd_history table with creation date/time
• TEMP views have some support
• Can be created and/or updated here (not visible until created or loaded in this session)
  
• Can be loaded from cmd_history table with ::GEB::loadtempview tempview1 ...
  

• Can Show spreadsheet-like display of selected view(s)

Individual view windows

Similar to Table windows

• Rows can be ordered by up to two columns
• Rows can be filtered with WHERE clause
• Count in title adjusted if WHERE results in a change