object FormMain: TFormMain
  Left = 57
  Height = 873
  Top = 0
  Width = 1791
  HorzScrollBar.Increment = 84
  HorzScrollBar.Page = 849
  HorzScrollBar.Smooth = True
  HorzScrollBar.Tracking = True
  VertScrollBar.Increment = 30
  VertScrollBar.Page = 300
  VertScrollBar.Smooth = True
  VertScrollBar.Tracking = True
  ActiveControl = PageControl1
  AutoScroll = True
  AutoSize = True
  Caption = 'MightyQuery 1.2.4'
  ClientHeight = 873
  ClientWidth = 1791
  OnClose = FormClose
  OnCreate = FormCreate
  OnDestroy = FormDestroy
  ShowHint = True
  LCLVersion = '8.0'
  Visible = True
  WindowState = wsMaximized
  object PageControl1: TPageControl
    Left = 0
    Height = 873
    Top = 0
    Width = 1791
    ActivePage = TabSheetProjects
    Align = alClient
    TabIndex = 0
    TabOrder = 0
    object TabSheetProjects: TTabSheet
      Caption = 'Projects'
      ClientHeight = 869
      ClientWidth = 1781
      object Panel1: TPanel
        Left = 0
        Height = 40
        Top = 80
        Width = 1781
        Align = alTop
        ClientHeight = 36
        ClientWidth = 1777
        TabOrder = 0
        object DBNavigatorProjects: TDBNavigator
          Left = 626
          Height = 26
          Top = 5
          Width = 1146
          Align = alClient
          BevelOuter = bvNone
          BorderSpacing.Around = 4
          ChildSizing.EnlargeHorizontal = crsScaleChilds
          ChildSizing.EnlargeVertical = crsScaleChilds
          ChildSizing.ShrinkHorizontal = crsScaleChilds
          ChildSizing.ShrinkVertical = crsScaleChilds
          ChildSizing.Layout = cclLeftToRightThenTopToBottom
          ChildSizing.ControlsPerLine = 100
          ClientHeight = 22
          ClientWidth = 1142
          DataSource = DataModule1.DatasourceProjects
          Options = []
          TabOrder = 0
        end
        object ButtonDeleteAllProjects: TButton
          Left = 5
          Height = 26
          Hint = 'Delete all registered projects.'
          Top = 5
          Width = 104
          Align = alLeft
          AutoSize = True
          BorderSpacing.Around = 4
          Caption = 'Delete Projects'
          OnClick = ButtonDeleteAllProjectsClick
          ParentFont = False
          TabOrder = 1
        end
        object ButtonEmptyPackAllTables: TButton
          Left = 113
          Height = 26
          Hint = 'Delete all registered projects and contract the database'
          Top = 5
          Width = 130
          Align = alLeft
          AutoSize = True
          BorderSpacing.Around = 4
          Caption = 'Empty and Pack All'
          OnClick = ButtonEmptyPackAllTablesClick
          TabOrder = 2
        end
        object ButtonInitiateFreshTables: TButton
          Left = 313
          Height = 26
          Hint = 'Delete all projects, contract the database and then enter the first record automatically in all tables.'
          Top = 5
          Width = 159
          Align = alLeft
          AutoSize = True
          BorderSpacing.Around = 4
          Caption = 'Initialize Fresh Database'
          OnClick = ButtonInitiateFreshTablesClick
          TabOrder = 3
        end
        object ButtonRegisterFolderPath: TButton
          Left = 476
          Height = 26
          Hint = 'Register browsed folder (chosen and entered above), as the project path of the currently selected project record.'#10'Note that each project represents a folder containing CSV files, which are considered to be tables of the project.'
          Top = 5
          Width = 146
          Align = alLeft
          AutoSize = True
          BorderSpacing.Around = 4
          Caption = 'Register Folder Path'
          Font.Style = [fsBold]
          OnClick = ButtonRegisterFolderPathClick
          ParentFont = False
          TabOrder = 4
        end
        object ButtonPackAll: TButton
          Left = 247
          Height = 26
          Hint = 'Contract the database'
          Top = 5
          Width = 62
          Align = alLeft
          AutoSize = True
          BorderSpacing.Around = 4
          Caption = 'Pack All'
          OnClick = ButtonPackAllClick
          TabOrder = 5
        end
      end
      object Panel2: TPanel
        Left = 0
        Height = 629
        Top = 120
        Width = 1781
        Align = alClient
        ClientHeight = 625
        ClientWidth = 1777
        TabOrder = 1
        object DBGridProjects: TRxDBGrid
          Left = 1
          Height = 623
          Top = 1
          Width = 1775
          ColumnDefValues.BlobText = '(blob)'
          TitleButtons = True
          AutoSort = True
          Columns = <          
            item
              Title.Alignment = taCenter
              Title.Orientation = toHorizontal
              Title.Caption = 'PROJECT_ID'
              Width = 100
              FieldName = 'PROJECT_ID'
              EditButtons = <>
              Filter.DropDownRows = 0
              Filter.EmptyValue = '(Empty)'
              Filter.NotEmptyValue = '(Not empty)'
              Filter.AllValue = '(All values)'
              Filter.EmptyFont.Style = [fsItalic]
              Filter.ItemIndex = -1
              Footers = <>
            end          
            item
              Title.Alignment = taCenter
              Title.Orientation = toHorizontal
              Title.Caption = 'Project Name'
              Width = 300
              FieldName = 'PROJECTNAME'
              EditButtons = <>
              Filter.DropDownRows = 0
              Filter.EmptyValue = '(Empty)'
              Filter.NotEmptyValue = '(Not empty)'
              Filter.AllValue = '(All values)'
              Filter.EmptyFont.Style = [fsItalic]
              Filter.ItemIndex = -1
              Footers = <>
            end          
            item
              Title.Alignment = taCenter
              Title.Orientation = toHorizontal
              Title.Caption = 'Project Folder Path'
              Width = 1000
              FieldName = 'PROJECTPATH'
              EditButtons = <>
              Filter.DropDownRows = 0
              Filter.EmptyValue = '(Empty)'
              Filter.NotEmptyValue = '(Not empty)'
              Filter.AllValue = '(All values)'
              Filter.EmptyFont.Style = [fsItalic]
              Filter.ItemIndex = -1
              Footers = <>
            end          
            item
              Title.Alignment = taCenter
              Title.Orientation = toHorizontal
              Title.Caption = 'Comment'
              Width = 438
              FieldName = 'PROJECTCOMMENT'
              EditButtons = <>
              Filter.DropDownRows = 0
              Filter.EmptyValue = '(Empty)'
              Filter.NotEmptyValue = '(Not empty)'
              Filter.AllValue = '(All values)'
              Filter.EmptyFont.Style = [fsItalic]
              Filter.ItemIndex = -1
              Footers = <>
            end>
          KeyStrokes = <          
            item
              Command = rxgcShowFindDlg
              ShortCut = 16454
              Enabled = True
            end          
            item
              Command = rxgcShowColumnsDlg
              ShortCut = 16471
              Enabled = True
            end          
            item
              Command = rxgcShowFilterDlg
              ShortCut = 16468
              Enabled = True
            end          
            item
              Command = rxgcShowSortDlg
              ShortCut = 16467
              Enabled = True
            end          
            item
              Command = rxgcShowQuickFilter
              ShortCut = 16465
              Enabled = True
            end          
            item
              Command = rxgcHideQuickFilter
              ShortCut = 16456
              Enabled = True
            end          
            item
              Command = rxgcSelectAll
              ShortCut = 16449
              Enabled = True
            end          
            item
              Command = rxgcDeSelectAll
              ShortCut = 16429
              Enabled = True
            end          
            item
              Command = rxgcInvertSelection
              ShortCut = 16426
              Enabled = True
            end          
            item
              Command = rxgcOptimizeColumnsWidth
              ShortCut = 16427
              Enabled = True
            end          
            item
              Command = rxgcCopyCellValue
              ShortCut = 16451
              Enabled = True
            end>
          FooterOptions.RowCount = 1
          FooterOptions.DrawFullLine = False
          SearchOptions.QuickSearchOptions = [loCaseInsensitive, loPartialKey]
          SearchOptions.FromStart = False
          OptionsRx = [rdgAllowColumnsForm, rdgAllowDialogFind, rdgDblClickOptimizeColWidth, rdgAllowQuickSearch, rdgAllowQuickFilter, rdgAllowFilterForm, rdgAllowSortForm, rdgAllowToolMenu, rdgCaseInsensitiveSort]
          FooterRowCount = 1
          Align = alClient
          Color = clWindow
          DrawFullLine = False
          FocusColor = clRed
          SelectedColor = clHighlight
          DataSource = DataModule1.DatasourceProjects
          DoubleBuffered = True
          Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgHeaderHotTracking, dgHeaderPushedLook, dgDblClickAutoSize, dgDisplayMemoText]
          ParentDoubleBuffered = False
          TabOrder = 0
        end
      end
      object Panel10: TPanel
        Left = 0
        Height = 40
        Top = 20
        Width = 1781
        Align = alTop
        ClientHeight = 40
        ClientWidth = 1781
        TabOrder = 2
        object DirectoryEditProjectFolder: TDirectoryEdit
          Left = 236
          Height = 30
          Hint = 'Browse and register project folder containng csv files.'#10'MightyQuery is considering a project folder to be a "database".'
          Top = 5
          Width = 1540
          OnAcceptDirectory = DirectoryEditProjectFolderAcceptDirectory
          DialogTitle = 'Browse new project folder'
          ShowHidden = False
          ButtonWidth = 23
          NumGlyphs = 1
          Align = alClient
          BorderSpacing.Around = 4
          MaxLength = 0
          TabOrder = 0
        end
        object Label1: TLabel
          Left = 5
          Height = 30
          Top = 5
          Width = 219
          Align = alLeft
          BorderSpacing.Right = 8
          BorderSpacing.Around = 4
          Caption = 'Browse new project database folder:'
          ParentColor = False
        end
      end
      object Panel51: TPanel
        Left = 0
        Height = 20
        Top = 60
        Width = 1781
        Align = alTop
        ClientHeight = 20
        ClientWidth = 1781
        TabOrder = 3
        object Label17: TLabel
          Left = 1
          Height = 18
          Top = 1
          Width = 1779
          Align = alClient
          Alignment = taCenter
          Caption = 'Registered Projects'
          ParentColor = False
        end
      end
      object Panel53: TPanel
        Left = 0
        Height = 20
        Top = 0
        Width = 1781
        Align = alTop
        ClientHeight = 20
        ClientWidth = 1781
        TabOrder = 4
        object Label18: TLabel
          Left = 1
          Height = 18
          Top = 1
          Width = 1779
          Align = alClient
          Alignment = taCenter
          Caption = 'Register New Project'
          ParentColor = False
        end
      end
      object Panel43: TPanel
        Left = 0
        Height = 120
        Top = 749
        Width = 1781
        Align = alBottom
        ClientHeight = 120
        ClientWidth = 1781
        TabOrder = 5
        object Panel40: TPanel
          Left = 1
          Height = 40
          Top = 21
          Width = 1779
          Align = alTop
          ClientHeight = 36
          ClientWidth = 1775
          TabOrder = 0
          object DBNavigatorAutoincs: TDBNavigator
            Left = 5
            Height = 26
            Top = 5
            Width = 1765
            Align = alClient
            BevelOuter = bvNone
            BorderSpacing.Around = 4
            ChildSizing.EnlargeHorizontal = crsScaleChilds
            ChildSizing.EnlargeVertical = crsScaleChilds
            ChildSizing.ShrinkHorizontal = crsScaleChilds
            ChildSizing.ShrinkVertical = crsScaleChilds
            ChildSizing.Layout = cclLeftToRightThenTopToBottom
            ChildSizing.ControlsPerLine = 100
            ClientHeight = 22
            ClientWidth = 1761
            DataSource = DataModule1.DataSourceAutoincs
            Options = []
            TabOrder = 0
            Visible = False
          end
        end
        object Panel41: TPanel
          Left = 1
          Height = 58
          Top = 61
          Width = 1779
          Align = alClient
          ClientHeight = 54
          ClientWidth = 1775
          TabOrder = 1
          object DBGridAutoincs: TRxDBGrid
            Left = 1
            Height = 52
            Top = 1
            Width = 1773
            ColumnDefValues.BlobText = '(blob)'
            TitleButtons = True
            AutoSort = True
            Columns = <            
              item
                Title.Alignment = taCenter
                Title.Orientation = toHorizontal
                Title.Caption = 'PROJECTS_AUTOINC'
                Width = 142
                FieldName = 'PROJECTS_AUTOINC'
                EditButtons = <>
                Filter.DropDownRows = 0
                Filter.EmptyValue = '(Empty)'
                Filter.NotEmptyValue = '(Not empty)'
                Filter.AllValue = '(All values)'
                Filter.EmptyFont.Style = [fsItalic]
                Filter.ItemIndex = -1
                Footers = <>
              end            
              item
                Title.Alignment = taCenter
                Title.Orientation = toHorizontal
                Title.Caption = 'TABLES_AUTOINC'
                Width = 126
                FieldName = 'TABLES_AUTOINC'
                EditButtons = <>
                Filter.DropDownRows = 0
                Filter.EmptyValue = '(Empty)'
                Filter.NotEmptyValue = '(Not empty)'
                Filter.AllValue = '(All values)'
                Filter.EmptyFont.Style = [fsItalic]
                Filter.ItemIndex = -1
                Footers = <>
              end            
              item
                Title.Alignment = taCenter
                Title.Orientation = toHorizontal
                Title.Caption = 'FIELDS_AUTOINC'
                Width = 121
                FieldName = 'FIELDS_AUTOINC'
                EditButtons = <>
                Filter.DropDownRows = 0
                Filter.EmptyValue = '(Empty)'
                Filter.NotEmptyValue = '(Not empty)'
                Filter.AllValue = '(All values)'
                Filter.EmptyFont.Style = [fsItalic]
                Filter.ItemIndex = -1
                Footers = <>
              end            
              item
                Title.Alignment = taCenter
                Title.Orientation = toHorizontal
                Title.Caption = 'QUERIES_AUTOINC'
                Width = 133
                FieldName = 'QUERIES_AUTOINC'
                EditButtons = <>
                Filter.DropDownRows = 0
                Filter.EmptyValue = '(Empty)'
                Filter.NotEmptyValue = '(Not empty)'
                Filter.AllValue = '(All values)'
                Filter.EmptyFont.Style = [fsItalic]
                Filter.ItemIndex = -1
                Footers = <>
              end            
              item
                Title.Alignment = taCenter
                Title.Orientation = toHorizontal
                Title.Caption = 'QUERIESPARAMETERS_AUTOINC'
                Width = 218
                FieldName = 'QUERIESPARAMETERS_AUTOINC'
                EditButtons = <>
                Filter.DropDownRows = 0
                Filter.EmptyValue = '(Empty)'
                Filter.NotEmptyValue = '(Not empty)'
                Filter.AllValue = '(All values)'
                Filter.EmptyFont.Style = [fsItalic]
                Filter.ItemIndex = -1
                Footers = <>
              end            
              item
                Title.Alignment = taCenter
                Title.Orientation = toHorizontal
                Title.Caption = 'SQLCONNECTORS_AUTOINC'
                Width = 187
                FieldName = 'SQLCONNECTORS_AUTOINC'
                EditButtons = <>
                Filter.DropDownRows = 0
                Filter.EmptyValue = '(Empty)'
                Filter.NotEmptyValue = '(Not empty)'
                Filter.AllValue = '(All values)'
                Filter.EmptyFont.Style = [fsItalic]
                Filter.ItemIndex = -1
                Footers = <>
              end            
              item
                Title.Alignment = taCenter
                Title.Orientation = toHorizontal
                Title.Caption = 'SQLTABLES_AUTOINC'
                Width = 148
                FieldName = 'SQLTABLES_AUTOINC'
                EditButtons = <>
                Filter.DropDownRows = 0
                Filter.EmptyValue = '(Empty)'
                Filter.NotEmptyValue = '(Not empty)'
                Filter.AllValue = '(All values)'
                Filter.EmptyFont.Style = [fsItalic]
                Filter.ItemIndex = -1
                Footers = <>
              end            
              item
                Title.Alignment = taCenter
                Title.Orientation = toHorizontal
                Title.Caption = 'FILTERS_AUTOINC'
                Width = 126
                FieldName = 'FILTERS_AUTOINC'
                EditButtons = <>
                Filter.DropDownRows = 0
                Filter.EmptyValue = '(Empty)'
                Filter.NotEmptyValue = '(Not empty)'
                Filter.AllValue = '(All values)'
                Filter.EmptyFont.Style = [fsItalic]
                Filter.ItemIndex = -1
                Footers = <>
              end>
            KeyStrokes = <            
              item
                Command = rxgcShowFindDlg
                ShortCut = 16454
                Enabled = True
              end            
              item
                Command = rxgcShowColumnsDlg
                ShortCut = 16471
                Enabled = True
              end            
              item
                Command = rxgcShowFilterDlg
                ShortCut = 16468
                Enabled = True
              end            
              item
                Command = rxgcShowSortDlg
                ShortCut = 16467
                Enabled = True
              end            
              item
                Command = rxgcShowQuickFilter
                ShortCut = 16465
                Enabled = True
              end            
              item
                Command = rxgcHideQuickFilter
                ShortCut = 16456
                Enabled = True
              end            
              item
                Command = rxgcSelectAll
                ShortCut = 16449
                Enabled = True
              end            
              item
                Command = rxgcDeSelectAll
                ShortCut = 16429
                Enabled = True
              end            
              item
                Command = rxgcInvertSelection
                ShortCut = 16426
                Enabled = True
              end            
              item
                Command = rxgcOptimizeColumnsWidth
                ShortCut = 16427
                Enabled = True
              end            
              item
                Command = rxgcCopyCellValue
                ShortCut = 16451
                Enabled = True
              end>
            FooterOptions.RowCount = 1
            FooterOptions.DrawFullLine = False
            SearchOptions.QuickSearchOptions = [loCaseInsensitive, loPartialKey]
            SearchOptions.FromStart = False
            OptionsRx = [rdgAllowColumnsForm, rdgAllowDialogFind, rdgDblClickOptimizeColWidth, rdgAllowQuickSearch, rdgAllowQuickFilter, rdgAllowFilterForm, rdgAllowSortForm, rdgAllowToolMenu, rdgCaseInsensitiveSort]
            FooterRowCount = 1
            Align = alClient
            Color = clWindow
            DrawFullLine = False
            FocusColor = clRed
            SelectedColor = clHighlight
            DataSource = DataModule1.DataSourceAutoincs
            DoubleBuffered = True
            Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgHeaderHotTracking, dgHeaderPushedLook, dgDblClickAutoSize, dgDisplayMemoText]
            ParentDoubleBuffered = False
            ReadOnly = True
            TabOrder = 0
          end
        end
        object Panel56: TPanel
          Left = 1
          Height = 20
          Top = 1
          Width = 1779
          Align = alTop
          ClientHeight = 20
          ClientWidth = 1779
          TabOrder = 2
          object Label21: TLabel
            Left = 1
            Height = 18
            Top = 1
            Width = 1777
            Align = alClient
            Alignment = taCenter
            Caption = 'Autoincrement Values for Database Tables IDs'
            ParentColor = False
          end
        end
      end
    end
    object TabSheetTables: TTabSheet
      Caption = 'Tables'
      ClientHeight = 869
      ClientWidth = 1781
      object PageControlTables: TPageControl
        Left = 0
        Height = 843
        Top = 0
        Width = 1781
        ActivePage = TabSheetTableDesign
        Align = alClient
        TabIndex = 0
        TabOrder = 0
        object TabSheetTableDesign: TTabSheet
          Caption = 'TableDesign'
          ClientHeight = 839
          ClientWidth = 1777
          object PairSplitter1: TPairSplitter
            Cursor = crVSplit
            Left = 0
            Height = 813
            Top = 0
            Width = 1771
            Align = alClient
            Position = 400
            SplitterType = pstVertical
            object PairSplitterSide1: TPairSplitterSide
              Cursor = crArrow
              Left = 0
              Height = 400
              Top = 0
              Width = 1771
              ClientWidth = 1771
              ClientHeight = 400
              object Panel4: TPanel
                Left = 0
                Height = 280
                Top = 120
                Width = 1771
                Align = alClient
                ClientHeight = 276
                ClientWidth = 1767
                TabOrder = 0
                object DBGridTables: TRxDBGrid
                  Left = 1
                  Height = 278
                  Top = 1
                  Width = 1769
                  ColumnDefValues.BlobText = '(blob)'
                  TitleButtons = True
                  AutoSort = True
                  Columns = <                  
                    item
                      ReadOnly = True
                      Title.Alignment = taCenter
                      Title.Orientation = toHorizontal
                      Title.Caption = 'PROJECT_ID'
                      Width = 91
                      FieldName = 'PROJECT_ID'
                      EditButtons = <>
                      Filter.DropDownRows = 0
                      Filter.EmptyValue = '(Empty)'
                      Filter.NotEmptyValue = '(Not empty)'
                      Filter.AllValue = '(All values)'
                      Filter.EmptyFont.Style = [fsItalic]
                      Filter.ItemIndex = -1
                      Footers = <>
                    end                  
                    item
                      ReadOnly = True
                      Title.Alignment = taCenter
                      Title.Orientation = toHorizontal
                      Title.Caption = 'TABLE_ID'
                      Width = 75
                      FieldName = 'TABLE_ID'
                      EditButtons = <>
                      Filter.DropDownRows = 0
                      Filter.EmptyValue = '(Empty)'
                      Filter.NotEmptyValue = '(Not empty)'
                      Filter.AllValue = '(All values)'
                      Filter.EmptyFont.Style = [fsItalic]
                      Filter.ItemIndex = -1
                      Footers = <>
                    end                  
                    item
                      Title.Alignment = taCenter
                      Title.Orientation = toHorizontal
                      Title.Caption = 'Table'
                      Width = 500
                      FieldName = 'TABLENAME'
                      EditButtons = <>
                      Filter.DropDownRows = 0
                      Filter.EmptyValue = '(Empty)'
                      Filter.NotEmptyValue = '(Not empty)'
                      Filter.AllValue = '(All values)'
                      Filter.EmptyFont.Style = [fsItalic]
                      Filter.ItemIndex = -1
                      Footers = <>
                    end                  
                    item
                      Title.Alignment = taCenter
                      Title.Orientation = toHorizontal
                      Title.Caption = 'Comment'
                      Width = 500
                      FieldName = 'TABLECOMMENT'
                      EditButtons = <>
                      Filter.DropDownRows = 0
                      Filter.EmptyValue = '(Empty)'
                      Filter.NotEmptyValue = '(Not empty)'
                      Filter.AllValue = '(All values)'
                      Filter.EmptyFont.Style = [fsItalic]
                      Filter.ItemIndex = -1
                      Footers = <>
                    end>
                  KeyStrokes = <                  
                    item
                      Command = rxgcShowFindDlg
                      ShortCut = 16454
                      Enabled = True
                    end                  
                    item
                      Command = rxgcShowColumnsDlg
                      ShortCut = 16471
                      Enabled = True
                    end                  
                    item
                      Command = rxgcShowFilterDlg
                      ShortCut = 16468
                      Enabled = True
                    end                  
                    item
                      Command = rxgcShowSortDlg
                      ShortCut = 16467
                      Enabled = True
                    end                  
                    item
                      Command = rxgcShowQuickFilter
                      ShortCut = 16465
                      Enabled = True
                    end                  
                    item
                      Command = rxgcHideQuickFilter
                      ShortCut = 16456
                      Enabled = True
                    end                  
                    item
                      Command = rxgcSelectAll
                      ShortCut = 16449
                      Enabled = True
                    end                  
                    item
                      Command = rxgcDeSelectAll
                      ShortCut = 16429
                      Enabled = True
                    end                  
                    item
                      Command = rxgcInvertSelection
                      ShortCut = 16426
                      Enabled = True
                    end                  
                    item
                      Command = rxgcOptimizeColumnsWidth
                      ShortCut = 16427
                      Enabled = True
                    end                  
                    item
                      Command = rxgcCopyCellValue
                      ShortCut = 16451
                      Enabled = True
                    end>
                  FooterOptions.RowCount = 1
                  FooterOptions.DrawFullLine = False
                  SearchOptions.QuickSearchOptions = [loCaseInsensitive, loPartialKey]
                  SearchOptions.FromStart = False
                  OptionsRx = [rdgAllowColumnsForm, rdgAllowDialogFind, rdgDblClickOptimizeColWidth, rdgAllowQuickSearch, rdgAllowQuickFilter, rdgAllowFilterForm, rdgAllowSortForm, rdgAllowToolMenu, rdgCaseInsensitiveSort]
                  FooterRowCount = 1
                  Align = alClient
                  Color = clWindow
                  DrawFullLine = False
                  FocusColor = clRed
                  SelectedColor = clHighlight
                  DataSource = DataModule1.DatasourceTables
                  DoubleBuffered = True
                  Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgHeaderHotTracking, dgHeaderPushedLook, dgDblClickAutoSize, dgDisplayMemoText]
                  ParentDoubleBuffered = False
                  TabOrder = 0
                end
              end
              object Panel5: TPanel
                Left = 0
                Height = 40
                Top = 80
                Width = 1771
                Align = alTop
                ClientHeight = 36
                ClientWidth = 1767
                TabOrder = 1
                object DBNavigatorTables: TDBNavigator
                  Left = 1027
                  Height = 30
                  Top = 5
                  Width = 739
                  Align = alClient
                  BevelOuter = bvNone
                  BorderSpacing.Around = 4
                  ChildSizing.EnlargeHorizontal = crsScaleChilds
                  ChildSizing.EnlargeVertical = crsScaleChilds
                  ChildSizing.ShrinkHorizontal = crsScaleChilds
                  ChildSizing.ShrinkVertical = crsScaleChilds
                  ChildSizing.Layout = cclLeftToRightThenTopToBottom
                  ChildSizing.ControlsPerLine = 100
                  ClientHeight = 26
                  ClientWidth = 735
                  DataSource = DataModule1.DatasourceTables
                  Options = []
                  TabOrder = 0
                end
                object Panel37: TPanel
                  Left = 1
                  Height = 38
                  Top = 1
                  Width = 1022
                  Align = alLeft
                  AutoSize = True
                  ChildSizing.EnlargeHorizontal = crsHomogenousChildResize
                  ChildSizing.EnlargeVertical = crsHomogenousChildResize
                  ChildSizing.ShrinkHorizontal = crsHomogenousChildResize
                  ChildSizing.ShrinkVertical = crsHomogenousChildResize
                  ChildSizing.Layout = cclTopToBottomThenLeftToRight
                  ClientHeight = 34
                  ClientWidth = 1018
                  TabOrder = 1
                  object ButtonDeleteAllTables: TButton
                    Left = 84
                    Height = 28
                    Hint = 'Delete all registered tables for the currently selected project.'#10'Note that it is just deletion of information about tables (CSV files) being present in a project folder,'#10'not deletion of the actual csv files itself!'
                    Top = 5
                    Width = 95
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Delete Tables'
                    OnClick = ButtonDeleteAllTablesClick
                    ParentShowHint = False
                    ShowHint = True
                    TabOrder = 0
                  end
                  object ButtonRegisterAllTablesAndFields: TButton
                    Left = 183
                    Height = 28
                    Hint = 'Automatically register all CSV files present in the project folder,'#10'as tables of the currently selected project.'#10'This procedure will register both tables (CSV files) and their fields (columns).'
                    Top = 5
                    Width = 179
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Register Tables and Fields'
                    Font.Style = [fsBold]
                    OnClick = ButtonRegisterAllTablesAndFieldsClick
                    ParentFont = False
                    TabOrder = 1
                  end
                  object ButtonRegisterAllTables: TButton
                    Left = 366
                    Height = 28
                    Hint = 'Automatically register all CSV files present in the project folder,'#10'as tables of the currently selected project.'#10'This procedure will register only tables (CSV files).'#10'You will need to register their fields (columns) afterwards.'
                    Top = 5
                    Width = 112
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Register Tables'
                    Font.Style = [fsBold]
                    OnClick = ButtonRegisterAllTablesClick
                    ParentFont = False
                    TabOrder = 2
                  end
                  object ButtonReformatAllTablesToZMSQLStandard: TButton
                    Left = 482
                    Height = 28
                    Hint = 'This procedure will inspect all tables (CSV files) being registered for the currently selected project'#10'and if a table does not comply to standard format being used by ZMSQL package,'#10'it will be then reformatted to the ZMSQL standard CSV format.'#10'Note that standard formatting of all CSV files is a prerequisite to be able to perform SQL queries.'#10'If some of the CSV files do not comply to the format, SQL querying will not work.'#10'ZMSQL standard requires CSV files to have semicolon (";") as fields delimiter.'
                    Top = 5
                    Width = 112
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Reformat Tables'
                    OnClick = ButtonReformatAllTablesToZMSQLStandardClick
                    ParentFont = False
                    TabOrder = 3
                  end
                  object ButtonReformatTableToZMSQLStandard: TButton
                    Left = 598
                    Height = 28
                    Hint = 'This procedure will inspect the currently selected table (CSV file)'#10'and if the CSV file does not comply to standard format being used by ZMSQL package,'#10'it will be then reformatted to the ZMSQL standard CSV format.'#10'Note that standard formatting of all CSV files is a prerequisite to be able to perform SQL queries.'#10'If some of the CSV files do not comply to the format, SQL querying will not work.'#10'ZMSQL standard requires CSV files to have semicolon (";") as fields delimiter.'
                    Top = 5
                    Width = 106
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Reformat Table'
                    OnClick = ButtonReformatTableToZMSQLStandardClick
                    ParentFont = False
                    TabOrder = 4
                  end
                  object ButtonActivateCSVTablePreview1: TButton
                    Left = 5
                    Height = 28
                    Hint = 'Load currently selected table (CSV file) into data grid.'
                    Top = 5
                    Width = 75
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Load Data'
                    OnClick = ButtonActivateCSVTablePreviewClick
                    TabOrder = 5
                  end
                  object ButtonCombineTables: TButton
                    Left = 708
                    Height = 28
                    Hint = 'Combine all tables into a new table, having fields (columns) from all tables.'#10'Rows from all tables will be merge/appended into the new combined table.'#10'Columns to be merged must have exactly same name.'
                    Top = 5
                    Width = 109
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Combine Tables'
                    Font.Color = clPurple
                    OnClick = ButtonCombineTablesClick
                    ParentFont = False
                    TabOrder = 6
                  end
                  object ButtonCombineTablesToTemplate: TButton
                    Left = 821
                    Height = 28
                    Hint = 'Combine other tables into the currently selected table, which is considered to be the template.'#10'Rows from all other tables will be merge/appended into the selected template table.'#10'Columns to be merged must have exactly same name.'
                    Top = 5
                    Width = 196
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Combine Tables Into Template'
                    Font.Color = clPurple
                    OnClick = ButtonCombineTablesToTemplateClick
                    ParentFont = False
                    TabOrder = 7
                  end
                end
              end
              object Panel12: TPanel
                Left = 0
                Height = 40
                Top = 20
                Width = 1771
                Align = alTop
                ClientHeight = 36
                ClientWidth = 1767
                TabOrder = 2
                object FileNameEditTableFile: TFileNameEdit
                  Left = 381
                  Height = 30
                  Hint = 'Browse and register csv files inside a project folder,'#10'as MightyQuery database tables.'
                  Top = 5
                  Width = 1385
                  OnAcceptFileName = FileNameEditTableFileAcceptFileName
                  DialogTitle = 'Register a CSV file as MightyQuery database table'
                  DialogOptions = [ofViewDetail]
                  FilterIndex = 0
                  DefaultExt = 'csv'
                  HideDirectories = False
                  ButtonWidth = 23
                  NumGlyphs = 1
                  Align = alClient
                  BorderSpacing.Around = 4
                  MaxLength = 0
                  TabOrder = 0
                  OnClick = FileNameEditTableFileClick
                end
                object Label4: TLabel
                  Left = 5
                  Height = 30
                  Top = 5
                  Width = 364
                  Align = alLeft
                  BorderSpacing.Right = 8
                  BorderSpacing.Around = 4
                  Caption = 'Browse new table (a csv file inside project folder) to register: '
                  ParentColor = False
                end
              end
              object Panel50: TPanel
                Left = 0
                Height = 20
                Top = 60
                Width = 1771
                Align = alTop
                ClientHeight = 16
                ClientWidth = 1767
                TabOrder = 3
                object Label16: TLabel
                  Left = 1
                  Height = 18
                  Top = 1
                  Width = 1769
                  Align = alClient
                  Alignment = taCenter
                  Caption = 'Registered Tables'
                  ParentColor = False
                end
              end
              object Panel54: TPanel
                Left = 0
                Height = 20
                Top = 0
                Width = 1771
                Align = alTop
                ClientHeight = 16
                ClientWidth = 1767
                TabOrder = 4
                object Label19: TLabel
                  Left = 1
                  Height = 18
                  Top = 1
                  Width = 1769
                  Align = alClient
                  Alignment = taCenter
                  Caption = 'Registered New Tables'
                  ParentColor = False
                end
              end
            end
            object PairSplitterSide2: TPairSplitterSide
              Cursor = crArrow
              Left = 0
              Height = 408
              Top = 405
              Width = 1771
              ClientWidth = 1771
              ClientHeight = 408
              object Panel6: TPanel
                Left = 0
                Height = 40
                Top = 20
                Width = 1771
                Align = alTop
                ClientHeight = 36
                ClientWidth = 1767
                TabOrder = 0
                object DBNavigatorFields: TDBNavigator
                  Left = 613
                  Height = 30
                  Top = 5
                  Width = 1153
                  Align = alClient
                  BevelOuter = bvNone
                  BorderSpacing.Around = 4
                  ChildSizing.EnlargeHorizontal = crsScaleChilds
                  ChildSizing.EnlargeVertical = crsScaleChilds
                  ChildSizing.ShrinkHorizontal = crsScaleChilds
                  ChildSizing.ShrinkVertical = crsScaleChilds
                  ChildSizing.Layout = cclLeftToRightThenTopToBottom
                  ChildSizing.ControlsPerLine = 100
                  ClientHeight = 26
                  ClientWidth = 1149
                  DataSource = DataModule1.DatasourceFields
                  Options = []
                  TabOrder = 0
                end
                object Panel11: TPanel
                  Left = 1
                  Height = 38
                  Top = 1
                  Width = 435
                  Align = alLeft
                  AutoSize = True
                  ChildSizing.EnlargeHorizontal = crsHomogenousChildResize
                  ChildSizing.EnlargeVertical = crsHomogenousChildResize
                  ChildSizing.ShrinkHorizontal = crsHomogenousChildResize
                  ChildSizing.ShrinkVertical = crsHomogenousChildResize
                  ChildSizing.Layout = cclTopToBottomThenLeftToRight
                  ClientHeight = 34
                  ClientWidth = 431
                  TabOrder = 1
                  object ButtonGetFieldsSchema: TButton
                    Left = 5
                    Height = 28
                    Hint = 'Get list of existing fields (columns) in the table (CSV file).'
                    Top = 5
                    Width = 130
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Get Fields Schema'
                    Font.Style = [fsBold]
                    OnClick = ButtonGetFieldsSchemaClick
                    ParentFont = False
                    ParentShowHint = False
                    ShowHint = True
                    TabOrder = 0
                  end
                  object ButtonSetFieldsSchema: TButton
                    Left = 139
                    Height = 28
                    Hint = 'Recreate fields (columns) in the table (insert or delete columns, reorder columns), '#10'according to the list of fields in the list below.'#10'Don''t use this button for applying renaming of columns, for which there is another dedicated button!!!'
                    Top = 5
                    Width = 129
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Set Fields Schema'
                    Font.Color = clRed
                    Font.Style = [fsBold]
                    OnClick = ButtonSetFieldsSchemaClick
                    ParentFont = False
                    ParentShowHint = False
                    ShowHint = True
                    TabOrder = 1
                  end
                  object ButtonApplyFieldsRenaming: TButton
                    Left = 272
                    Height = 28
                    Hint = 'Use this button to confirm fields (columns) renaming.'#10'This will trigger procedure which will rename columns in underlying CSV file,'#10'according to changes manually done in the schema definition.'#10#10'Important notice: Renaming is done positionally,  according to positional order of columns.'#10'Column names in the CSV file will be changed according the order of columns in the schema definition.'#10'Therefore, you must not change order of columns and column names simultaneously!'
                    Top = 5
                    Width = 158
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Apply Fields Renaming'
                    Font.Color = clRed
                    Font.Style = [fsBold]
                    OnClick = ButtonApplyFieldsRenamingClick
                    ParentFont = False
                    ParentShowHint = False
                    ShowHint = True
                    TabOrder = 2
                  end
                end
                object Panel19: TPanel
                  Left = 436
                  Height = 38
                  Top = 1
                  Width = 173
                  Align = alLeft
                  AutoSize = True
                  ChildSizing.EnlargeHorizontal = crsHomogenousChildResize
                  ChildSizing.EnlargeVertical = crsHomogenousChildResize
                  ChildSizing.ShrinkHorizontal = crsHomogenousChildResize
                  ChildSizing.ShrinkVertical = crsHomogenousChildResize
                  ChildSizing.Layout = cclTopToBottomThenLeftToRight
                  ClientHeight = 34
                  ClientWidth = 169
                  TabOrder = 2
                  object ButtonDeleteAllFields: TButton
                    Left = 5
                    Height = 28
                    Hint = 'Delete all registered fields (columns) for the currently selected table (CSV file).'#10'Note that it just deletion of information about fields, not deleting actual columns in the file.'
                    Top = 5
                    Width = 91
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Delete Fields'
                    OnClick = ButtonDeleteAllFieldsClick
                    ParentShowHint = False
                    ShowHint = True
                    TabOrder = 0
                  end
                  object SpeedButtonMoveFieldDown: TSpeedButton
                    Left = 100
                    Height = 36
                    Hint = 'Move field (column) down'
                    Top = 1
                    Width = 36
                    Align = alLeft
                    AutoSize = True
                    Glyph.Data = {
                      [encoded data, 8256 characters]
                      0000000000000000000000000000000000000000000000000000
                    }
                    OnClick = SpeedButtonMoveFieldDownClick
                  end
                  object SpeedButtonMoveFieldUp: TSpeedButton
                    Left = 136
                    Height = 36
                    Hint = 'Move field (column) up'
                    Top = 1
                    Width = 36
                    Align = alLeft
                    AutoSize = True
                    Glyph.Data = {
                      [encoded data, 8256 characters]
                      0000000000000000000000000000000000000000000000000000
                    }
                    OnClick = SpeedButtonMoveFieldUpClick
                  end
                end
              end
              object Panel7: TPanel
                Left = 0
                Height = 348
                Top = 60
                Width = 1771
                Align = alClient
                ClientHeight = 344
                ClientWidth = 1767
                TabOrder = 1
                object DBGridFields: TRxDBGrid
                  Left = 1
                  Height = 346
                  Top = 1
                  Width = 1769
                  ColumnDefValues.BlobText = '(blob)'
                  TitleButtons = True
                  AutoSort = True
                  Columns = <                  
                    item
                      ReadOnly = True
                      Title.Alignment = taCenter
                      Title.Orientation = toHorizontal
                      Title.Caption = 'TABLE_ID'
                      Width = 75
                      FieldName = 'TABLE_ID'
                      EditButtons = <>
                      Filter.DropDownRows = 0
                      Filter.EmptyValue = '(Empty)'
                      Filter.NotEmptyValue = '(Not empty)'
                      Filter.AllValue = '(All values)'
                      Filter.EmptyFont.Style = [fsItalic]
                      Filter.ItemIndex = -1
                      Footers = <>
                    end                  
                    item
                      ReadOnly = True
                      Title.Alignment = taCenter
                      Title.Orientation = toHorizontal
                      Title.Caption = 'FIELD_ID'
                      Width = 70
                      FieldName = 'FIELD_ID'
                      EditButtons = <>
                      Filter.DropDownRows = 0
                      Filter.EmptyValue = '(Empty)'
                      Filter.NotEmptyValue = '(Not empty)'
                      Filter.AllValue = '(All values)'
                      Filter.EmptyFont.Style = [fsItalic]
                      Filter.ItemIndex = -1
                      Footers = <>
                    end                  
                    item
                      Title.Alignment = taCenter
                      Title.Orientation = toHorizontal
                      Title.Caption = 'Field'
                      Width = 500
                      FieldName = 'FIELDNAME'
                      EditButtons = <>
                      Filter.DropDownRows = 0
                      Filter.EmptyValue = '(Empty)'
                      Filter.NotEmptyValue = '(Not empty)'
                      Filter.AllValue = '(All values)'
                      Filter.EmptyFont.Style = [fsItalic]
                      Filter.ItemIndex = -1
                      Footers = <>
                    end                  
                    item
                      Title.Alignment = taCenter
                      Title.Orientation = toHorizontal
                      Title.Caption = 'Comment'
                      Width = 500
                      FieldName = 'FIELDCOMMENT'
                      EditButtons = <>
                      Filter.DropDownRows = 0
                      Filter.EmptyValue = '(Empty)'
                      Filter.NotEmptyValue = '(Not empty)'
                      Filter.AllValue = '(All values)'
                      Filter.EmptyFont.Style = [fsItalic]
                      Filter.ItemIndex = -1
                      Footers = <>
                    end>
                  KeyStrokes = <                  
                    item
                      Command = rxgcShowFindDlg
                      ShortCut = 16454
                      Enabled = True
                    end                  
                    item
                      Command = rxgcShowColumnsDlg
                      ShortCut = 16471
                      Enabled = True
                    end                  
                    item
                      Command = rxgcShowFilterDlg
                      ShortCut = 16468
                      Enabled = True
                    end                  
                    item
                      Command = rxgcShowSortDlg
                      ShortCut = 16467
                      Enabled = True
                    end                  
                    item
                      Command = rxgcShowQuickFilter
                      ShortCut = 16465
                      Enabled = True
                    end                  
                    item
                      Command = rxgcHideQuickFilter
                      ShortCut = 16456
                      Enabled = True
                    end                  
                    item
                      Command = rxgcSelectAll
                      ShortCut = 16449
                      Enabled = True
                    end                  
                    item
                      Command = rxgcDeSelectAll
                      ShortCut = 16429
                      Enabled = True
                    end                  
                    item
                      Command = rxgcInvertSelection
                      ShortCut = 16426
                      Enabled = True
                    end                  
                    item
                      Command = rxgcOptimizeColumnsWidth
                      ShortCut = 16427
                      Enabled = True
                    end                  
                    item
                      Command = rxgcCopyCellValue
                      ShortCut = 16451
                      Enabled = True
                    end>
                  FooterOptions.RowCount = 1
                  FooterOptions.DrawFullLine = False
                  SearchOptions.QuickSearchOptions = [loCaseInsensitive, loPartialKey]
                  SearchOptions.FromStart = False
                  OptionsRx = [rdgAllowColumnsForm, rdgAllowDialogFind, rdgDblClickOptimizeColWidth, rdgAllowQuickSearch, rdgAllowQuickFilter, rdgAllowFilterForm, rdgAllowSortForm, rdgAllowToolMenu, rdgCaseInsensitiveSort]
                  FooterRowCount = 1
                  Align = alClient
                  Color = clWindow
                  DrawFullLine = False
                  FocusColor = clRed
                  SelectedColor = clHighlight
                  DataSource = DataModule1.DatasourceFields
                  DoubleBuffered = True
                  Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgHeaderHotTracking, dgHeaderPushedLook, dgDblClickAutoSize, dgDisplayMemoText]
                  ParentDoubleBuffered = False
                  TabOrder = 0
                end
              end
              object Panel42: TPanel
                Left = 0
                Height = 20
                Top = 0
                Width = 1771
                Align = alTop
                ClientHeight = 16
                ClientWidth = 1767
                TabOrder = 2
                object Label6: TLabel
                  Left = 1
                  Height = 18
                  Top = 1
                  Width = 1769
                  Align = alClient
                  Alignment = taCenter
                  Caption = 'Investigate Or Edit Fields (Columns)'
                  ParentColor = False
                end
              end
            end
          end
        end
        object TabSheetTableData: TTabSheet
          Caption = 'TableData'
          ClientHeight = 839
          ClientWidth = 1777
          object Panel52: TPanel
            Left = 0
            Height = 813
            Top = 0
            Width = 1771
            Align = alClient
            Caption = 'Panel52'
            ClientHeight = 809
            ClientWidth = 1767
            TabOrder = 0
            object Panel8: TPanel
              Left = 1
              Height = 40
              Top = 21
              Width = 1769
              Align = alTop
              Caption = 'Panel8'
              ClientHeight = 36
              ClientWidth = 1765
              TabOrder = 0
              object DBNavigatorCSVTable: TDBNavigator
                Left = 551
                Height = 30
                Top = 5
                Width = 1213
                Align = alClient
                BevelOuter = bvNone
                BorderSpacing.Around = 4
                ChildSizing.EnlargeHorizontal = crsScaleChilds
                ChildSizing.EnlargeVertical = crsScaleChilds
                ChildSizing.ShrinkHorizontal = crsScaleChilds
                ChildSizing.ShrinkVertical = crsScaleChilds
                ChildSizing.Layout = cclLeftToRightThenTopToBottom
                ChildSizing.ControlsPerLine = 100
                ClientHeight = 26
                ClientWidth = 1209
                DataSource = DataModule1.DatasourceCSVTableData
                Options = []
                TabOrder = 0
              end
              object ButtonDeactivateCSVTablePreview: TButton
                Left = 84
                Height = 30
                Hint = 'Unload dataset from the data grid.'
                Top = 5
                Width = 89
                Align = alLeft
                AutoSize = True
                BorderSpacing.Around = 4
                Caption = 'Unload Data'
                OnClick = ButtonDeactivateCSVTablePreviewClick
                TabOrder = 1
              end
              object ButtonActivateCSVTablePreview: TButton
                Left = 5
                Height = 30
                Hint = 'Load currently selected table (CSV file) into data grid below.'
                Top = 5
                Width = 75
                Align = alLeft
                AutoSize = True
                BorderSpacing.Around = 4
                Caption = 'Load Data'
                OnClick = ButtonActivateCSVTablePreviewClick
                TabOrder = 2
              end
              object ButtonUpdateCSVTable: TButton
                Left = 269
                Height = 30
                Hint = 'This action will save changes made in the data grid, into underlying CSV file.'
                Top = 5
                Width = 126
                Align = alLeft
                AutoSize = True
                BorderSpacing.Around = 4
                Caption = 'Update CSV table'
                Font.Style = [fsBold]
                OnClick = ButtonUpdateCSVTableClick
                ParentFont = False
                TabOrder = 3
              end
              object ButtonFilterCSVTableData: TButton
                Left = 443
                Height = 30
                Hint = 'Filter dataset according to some filter criteria.'
                Top = 5
                Width = 45
                Align = alLeft
                AutoSize = True
                BorderSpacing.Around = 4
                Caption = 'Filter'
                OnClick = ButtonFilterCSVTableDataClick
                TabOrder = 4
              end
              object ButtonFindCSVTableData: TButton
                Left = 399
                Height = 30
                Hint = 'Search table for a row satisfying some search criteria.'
                Top = 5
                Width = 40
                Align = alLeft
                AutoSize = True
                BorderSpacing.Around = 4
                Caption = 'Find'
                OnClick = ButtonFindCSVTableDataClick
                TabOrder = 5
              end
              object ButtonExportCSVTableData: TButton
                Left = 492
                Height = 30
                Hint = 'Export dataset from datagrid into another file.'
                Top = 5
                Width = 55
                Align = alLeft
                AutoSize = True
                BorderSpacing.Around = 4
                Caption = 'Export'
                OnClick = ButtonExportCSVTableDataClick
                TabOrder = 6
              end
              object ButtonDeleteAllRowsCSVTableData: TButton
                Left = 177
                Height = 30
                Hint = 'Delete all rows in the table!'
                Top = 5
                Width = 88
                Align = alLeft
                AutoSize = True
                BorderSpacing.Around = 4
                Caption = 'Delete Rows'
                OnClick = ButtonDeleteAllRowsCSVTableDataClick
                ParentShowHint = False
                ShowHint = True
                TabOrder = 7
              end
            end
            object Panel9: TPanel
              Left = 1
              Height = 751
              Top = 61
              Width = 1769
              Align = alClient
              Caption = 'Panel9'
              ClientHeight = 747
              ClientWidth = 1765
              TabOrder = 1
              object DBGridCSVTableData: TRxDBGrid
                Left = 1
                Height = 749
                Top = 1
                Width = 1767
                ColumnDefValues.BlobText = '(blob)'
                TitleButtons = True
                AutoSort = True
                KeyStrokes = <                
                  item
                    Command = rxgcShowFindDlg
                    ShortCut = 16454
                    Enabled = True
                  end                
                  item
                    Command = rxgcShowColumnsDlg
                    ShortCut = 16471
                    Enabled = True
                  end                
                  item
                    Command = rxgcShowFilterDlg
                    ShortCut = 16468
                    Enabled = True
                  end                
                  item
                    Command = rxgcShowSortDlg
                    ShortCut = 16467
                    Enabled = True
                  end                
                  item
                    Command = rxgcShowQuickFilter
                    ShortCut = 16465
                    Enabled = True
                  end                
                  item
                    Command = rxgcHideQuickFilter
                    ShortCut = 16456
                    Enabled = True
                  end                
                  item
                    Command = rxgcSelectAll
                    ShortCut = 16449
                    Enabled = True
                  end                
                  item
                    Command = rxgcDeSelectAll
                    ShortCut = 16429
                    Enabled = True
                  end                
                  item
                    Command = rxgcInvertSelection
                    ShortCut = 16426
                    Enabled = True
                  end                
                  item
                    Command = rxgcOptimizeColumnsWidth
                    ShortCut = 16427
                    Enabled = True
                  end                
                  item
                    Command = rxgcCopyCellValue
                    ShortCut = 16451
                    Enabled = True
                  end>
                FooterOptions.RowCount = 1
                FooterOptions.DrawFullLine = False
                SearchOptions.QuickSearchOptions = [loCaseInsensitive, loPartialKey]
                SearchOptions.FromStart = False
                OptionsRx = [rdgAllowColumnsForm, rdgAllowDialogFind, rdgDblClickOptimizeColWidth, rdgAllowQuickSearch, rdgAllowQuickFilter, rdgAllowFilterForm, rdgAllowSortForm, rdgAllowToolMenu, rdgCaseInsensitiveSort]
                FooterRowCount = 1
                Align = alClient
                Color = clWindow
                DrawFullLine = False
                FocusColor = clRed
                SelectedColor = clHighlight
                DataSource = DataModule1.DatasourceCSVTableData
                DoubleBuffered = True
                Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgHeaderHotTracking, dgHeaderPushedLook, dgDblClickAutoSize, dgDisplayMemoText]
                ParentDoubleBuffered = False
                TabOrder = 0
              end
            end
            object Panel46: TPanel
              Left = 1
              Height = 20
              Top = 1
              Width = 1769
              Align = alTop
              ClientHeight = 16
              ClientWidth = 1765
              TabOrder = 2
              object Label12: TLabel
                Left = 1
                Height = 18
                Top = 1
                Width = 1767
                Align = alClient
                Alignment = taCenter
                Caption = 'Records'
                ParentColor = False
              end
            end
          end
        end
      end
    end
    object TabSheetQueries: TTabSheet
      Caption = 'Queries'
      ClientHeight = 869
      ClientWidth = 1781
      object PageControlQueries: TPageControl
        Left = 0
        Height = 843
        Top = 0
        Width = 1781
        ActivePage = TabSheetQueryDesign
        Align = alClient
        TabIndex = 0
        TabOrder = 0
        object TabSheetQueryDesign: TTabSheet
          Caption = 'QueryDesign'
          ClientHeight = 839
          ClientWidth = 1777
          object PairSplitter3: TPairSplitter
            Cursor = crVSplit
            Left = 0
            Height = 813
            Top = 0
            Width = 1771
            Align = alClient
            Position = 260
            SplitterType = pstVertical
            object PairSplitterSide5: TPairSplitterSide
              Cursor = crArrow
              Left = 0
              Height = 260
              Top = 0
              Width = 1771
              ClientWidth = 1771
              ClientHeight = 260
              object Panel13: TPanel
                Left = 0
                Height = 40
                Top = 20
                Width = 1771
                Align = alTop
                ClientHeight = 36
                ClientWidth = 1767
                TabOrder = 0
                object DBNavigatorQueries: TDBNavigator
                  Left = 111
                  Height = 30
                  Top = 5
                  Width = 1655
                  Align = alClient
                  AutoSize = True
                  BevelOuter = bvNone
                  BorderSpacing.Around = 4
                  ChildSizing.EnlargeHorizontal = crsScaleChilds
                  ChildSizing.EnlargeVertical = crsScaleChilds
                  ChildSizing.ShrinkHorizontal = crsScaleChilds
                  ChildSizing.ShrinkVertical = crsScaleChilds
                  ChildSizing.Layout = cclLeftToRightThenTopToBottom
                  ChildSizing.ControlsPerLine = 100
                  ClientHeight = 26
                  ClientWidth = 1651
                  DataSource = DataModule1.DatasourceQueries
                  Options = []
                  TabOrder = 0
                end
                object ButtonDeleteAllQueries: TButton
                  Left = 5
                  Height = 30
                  Hint = 'Delete all saved SQL queries.'
                  Top = 5
                  Width = 102
                  Align = alLeft
                  AutoSize = True
                  BorderSpacing.Around = 4
                  Caption = 'Delete Queries'
                  OnClick = ButtonDeleteAllQueriesClick
                  TabOrder = 1
                end
              end
              object Panel14: TPanel
                Left = 0
                Height = 120
                Top = 60
                Width = 1771
                Align = alClient
                Caption = 'Panel14'
                ClientHeight = 116
                ClientWidth = 1767
                TabOrder = 1
                object DBGridQueries: TRxDBGrid
                  Left = 1
                  Height = 118
                  Top = 1
                  Width = 1769
                  ColumnDefValues.BlobText = '(blob)'
                  TitleButtons = True
                  AutoSort = True
                  Columns = <                  
                    item
                      ReadOnly = True
                      Title.Alignment = taCenter
                      Title.Orientation = toHorizontal
                      Title.Caption = 'PROJECT_ID'
                      FieldName = 'PROJECT_ID'
                      EditButtons = <>
                      Filter.DropDownRows = 0
                      Filter.EmptyValue = '(Empty)'
                      Filter.NotEmptyValue = '(Not empty)'
                      Filter.AllValue = '(All values)'
                      Filter.EmptyFont.Style = [fsItalic]
                      Filter.ItemIndex = -1
                      Footers = <>
                    end                  
                    item
                      ReadOnly = True
                      Title.Alignment = taCenter
                      Title.Orientation = toHorizontal
                      Title.Caption = 'QUERY_ID'
                      FieldName = 'QUERY_ID'
                      EditButtons = <>
                      Filter.DropDownRows = 0
                      Filter.EmptyValue = '(Empty)'
                      Filter.NotEmptyValue = '(Not empty)'
                      Filter.AllValue = '(All values)'
                      Filter.EmptyFont.Style = [fsItalic]
                      Filter.ItemIndex = -1
                      Footers = <>
                    end                  
                    item
                      Title.Alignment = taCenter
                      Title.Orientation = toHorizontal
                      Title.Caption = 'Query Name'
                      Width = 700
                      FieldName = 'QUERYNAME'
                      EditButtons = <>
                      Filter.DropDownRows = 0
                      Filter.EmptyValue = '(Empty)'
                      Filter.NotEmptyValue = '(Not empty)'
                      Filter.AllValue = '(All values)'
                      Filter.EmptyFont.Style = [fsItalic]
                      Filter.ItemIndex = -1
                      Footers = <>
                    end                  
                    item
                      Title.Alignment = taCenter
                      Title.Orientation = toHorizontal
                      Title.Caption = 'Comment'
                      Width = 600
                      FieldName = 'QUERYCOMMENT'
                      EditButtons = <>
                      Filter.DropDownRows = 0
                      Filter.EmptyValue = '(Empty)'
                      Filter.NotEmptyValue = '(Not empty)'
                      Filter.AllValue = '(All values)'
                      Filter.EmptyFont.Style = [fsItalic]
                      Filter.ItemIndex = -1
                      Footers = <>
                    end>
                  KeyStrokes = <                  
                    item
                      Command = rxgcShowFindDlg
                      ShortCut = 16454
                      Enabled = True
                    end                  
                    item
                      Command = rxgcShowColumnsDlg
                      ShortCut = 16471
                      Enabled = True
                    end                  
                    item
                      Command = rxgcShowFilterDlg
                      ShortCut = 16468
                      Enabled = True
                    end                  
                    item
                      Command = rxgcShowSortDlg
                      ShortCut = 16467
                      Enabled = True
                    end                  
                    item
                      Command = rxgcShowQuickFilter
                      ShortCut = 16465
                      Enabled = True
                    end                  
                    item
                      Command = rxgcHideQuickFilter
                      ShortCut = 16456
                      Enabled = True
                    end                  
                    item
                      Command = rxgcSelectAll
                      ShortCut = 16449
                      Enabled = True
                    end                  
                    item
                      Command = rxgcDeSelectAll
                      ShortCut = 16429
                      Enabled = True
                    end                  
                    item
                      Command = rxgcInvertSelection
                      ShortCut = 16426
                      Enabled = True
                    end                  
                    item
                      Command = rxgcOptimizeColumnsWidth
                      ShortCut = 16427
                      Enabled = True
                    end                  
                    item
                      Command = rxgcCopyCellValue
                      ShortCut = 16451
                      Enabled = True
                    end>
                  FooterOptions.RowCount = 1
                  FooterOptions.DrawFullLine = False
                  SearchOptions.QuickSearchOptions = [loCaseInsensitive, loPartialKey]
                  SearchOptions.FromStart = False
                  OptionsRx = [rdgAllowColumnsForm, rdgAllowDialogFind, rdgDblClickOptimizeColWidth, rdgAllowQuickSearch, rdgAllowQuickFilter, rdgAllowFilterForm, rdgAllowSortForm, rdgAllowToolMenu, rdgCaseInsensitiveSort]
                  FooterRowCount = 1
                  Align = alClient
                  Color = clWindow
                  DrawFullLine = False
                  FocusColor = clRed
                  SelectedColor = clHighlight
                  DataSource = DataModule1.DatasourceQueries
                  DoubleBuffered = True
                  Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgHeaderHotTracking, dgHeaderPushedLook, dgDblClickAutoSize, dgDisplayMemoText]
                  ParentDoubleBuffered = False
                  TabOrder = 0
                end
              end
              object Panel15: TPanel
                Left = 0
                Height = 80
                Top = 180
                Width = 1771
                Align = alBottom
                ChildSizing.EnlargeHorizontal = crsScaleChilds
                ChildSizing.EnlargeVertical = crsScaleChilds
                ChildSizing.ShrinkHorizontal = crsScaleChilds
                ChildSizing.ShrinkVertical = crsScaleChilds
                ClientHeight = 76
                ClientWidth = 1767
                TabOrder = 2
                object Panel36: TPanel
                  Left = 1
                  Height = 40
                  Top = 39
                  Width = 1769
                  Align = alBottom
                  ChildSizing.EnlargeHorizontal = crsScaleChilds
                  ChildSizing.EnlargeVertical = crsScaleChilds
                  ChildSizing.ShrinkHorizontal = crsScaleChilds
                  ChildSizing.ShrinkVertical = crsScaleChilds
                  ClientHeight = 36
                  ClientWidth = 1765
                  TabOrder = 0
                  object FileNameEditSaveQuerySQL: TFileNameEdit
                    Left = 5
                    Height = 30
                    Top = 5
                    Width = 1461
                    DialogOptions = []
                    FilterIndex = 0
                    HideDirectories = False
                    ButtonWidth = 23
                    NumGlyphs = 1
                    Align = alClient
                    BorderSpacing.Around = 4
                    MaxLength = 0
                    TabOrder = 0
                  end
                  object ButtonSaveQueryToFile: TButton
                    Left = 1470
                    Height = 30
                    Top = 5
                    Width = 136
                    Align = alRight
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Save Query To A File'
                    OnClick = ButtonSaveQueryToFileClick
                    TabOrder = 1
                  end
                  object ButtonLoadQueryFromFile: TButton
                    Left = 1610
                    Height = 30
                    Top = 5
                    Width = 154
                    Align = alRight
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Load Query From A File'
                    OnClick = ButtonLoadQueryFromFileClick
                    TabOrder = 2
                  end
                end
                object ButtonRunQuery: TButton
                  Left = 374
                  Height = 30
                  Hint = 'Run simple query'
                  Top = 5
                  Width = 82
                  Align = alLeft
                  AutoSize = True
                  BorderSpacing.Around = 4
                  Caption = 'Run Query'
                  Font.Color = clRed
                  Font.Style = [fsBold]
                  OnClick = ButtonRunQueryClick
                  ParentFont = False
                  TabOrder = 1
                end
                object ButtonRunQueryBuilder: TButton
                  Left = 5
                  Height = 30
                  Hint = 'Construct a query by using visual query builder (QBuilder)'
                  Top = 5
                  Width = 184
                  Align = alLeft
                  AutoSize = True
                  BorderSpacing.Around = 4
                  Caption = 'Open Visual Query Builder'
                  Font.Color = clBlue
                  Font.Style = [fsBold]
                  OnClick = ButtonRunQueryBuilderClick
                  ParentFont = False
                  TabOrder = 2
                end
                object ButtonRunParameterizedQuery: TButton
                  Left = 193
                  Height = 30
                  Hint = 'Run parameterized query'
                  Top = 5
                  Width = 177
                  Align = alLeft
                  AutoSize = True
                  BorderSpacing.Around = 4
                  Caption = 'Run Parameterized Query'
                  Font.Color = clRed
                  Font.Style = [fsBold]
                  OnClick = ButtonRunParameterizedQueryClick
                  ParentFont = False
                  TabOrder = 3
                end
                object ComboBoxFieldDelimiter: TComboBox
                  Left = 752
                  Height = 28
                  Top = 5
                  Width = 168
                  DoubleBuffered = True
                  ItemHeight = 0
                  Items.Strings = (
                    'Semicolon'
                    'Tab'
                    'Comma'
                    'Bar'
                    'Colon'
                    'Dash'
                    'Slash'
                    'BackSlash'
                  )
                  ParentDoubleBuffered = False
                  TabOrder = 4
                  Text = 'Semicolon'
                end
                object Label23: TLabel
                  Left = 517
                  Height = 16
                  Top = 11
                  Width = 219
                  Caption = 'Explicitely specify csv field delimiter:'
                end
                object ButtonDetermineCurrentFieldDelimiter: TButton
                  Left = 936
                  Height = 30
                  Hint = 'Determine what is currently set field delimiter in ZMQueryDataset, and show it in the combobox.'
                  Top = 5
                  Width = 117
                  AutoSize = True
                  BorderSpacing.Around = 4
                  Caption = 'Current Delimiter'
                  OnClick = ButtonDetermineCurrentFieldDelimiterClick
                  TabOrder = 5
                end
                object ButtonApplySelectedFieldDelimiter: TButton
                  Left = 1064
                  Height = 30
                  Hint = 'Apply currently selected field delimiter.'
                  Top = 5
                  Width = 107
                  AutoSize = True
                  BorderSpacing.Around = 4
                  Caption = 'Apply Delimiter'
                  OnClick = ButtonApplySelectedFieldDelimiterClick
                  TabOrder = 6
                end
              end
              object Panel47: TPanel
                Left = 0
                Height = 20
                Top = 0
                Width = 1771
                Align = alTop
                ClientHeight = 16
                ClientWidth = 1767
                TabOrder = 3
                object Label13: TLabel
                  Left = 1
                  Height = 18
                  Top = 1
                  Width = 1769
                  Align = alClient
                  Alignment = taCenter
                  Caption = 'Saved Queries'
                  ParentColor = False
                end
              end
            end
            object PairSplitterSide6: TPairSplitterSide
              Cursor = crArrow
              Left = 0
              Height = 548
              Top = 265
              Width = 1771
              ClientWidth = 1771
              ClientHeight = 548
              object PairSplitter5: TPairSplitter
                Cursor = crVSplit
                Left = 0
                Height = 548
                Top = 0
                Width = 1771
                Align = alClient
                Position = 200
                SplitterType = pstVertical
                object PairSplitterSide9: TPairSplitterSide
                  Cursor = crArrow
                  Left = 0
                  Height = 200
                  Top = 0
                  Width = 1771
                  ClientWidth = 1771
                  ClientHeight = 200
                  inline SynEditSQLEditor: TSynMemo
                    Cursor = crIBeam
                    Left = 0
                    Height = 180
                    Hint = 'Use [CTRL]+[Space] for autocompletion.'
                    Top = 20
                    Width = 1771
                    Align = alClient
                    Font.Height = 12
                    Font.Name = '-misc-dejavu sans mono-*-*-*-*-*-*-*-*-*-*-iso10646-1'
                    Font.Pitch = fpFixed
                    Font.Quality = fqNonAntialiased
                    ParentColor = False
                    ParentFont = False
                    ParentShowHint = False
                    ShowHint = True
                    TabOrder = 0
                    Gutter.Width = 55
                    Gutter.MouseActions = <                    
                      item
                        ClickCount = ccAny
                        ClickDir = cdDown
                        Command = emcOnMainGutterClick
                      end                    
                      item
                        Button = mbRight
                        Command = emcContextMenu
                      end>
                    Highlighter = SynSQLSyn1
                    Keystrokes = <                    
                      item
                        Command = ecUp
                        ShortCut = 38
                      end                    
                      item
                        Command = ecSelUp
                        ShortCut = 8230
                      end                    
                      item
                        Command = ecScrollUp
                        ShortCut = 16422
                      end                    
                      item
                        Command = ecDown
                        ShortCut = 40
                      end                    
                      item
                        Command = ecSelDown
                        ShortCut = 8232
                      end                    
                      item
                        Command = ecScrollDown
                        ShortCut = 16424
                      end                    
                      item
                        Command = ecLeft
                        ShortCut = 37
                      end                    
                      item
                        Command = ecSelLeft
                        ShortCut = 8229
                      end                    
                      item
                        Command = ecWordLeft
                        ShortCut = 16421
                      end                    
                      item
                        Command = ecSelWordLeft
                        ShortCut = 24613
                      end                    
                      item
                        Command = ecRight
                        ShortCut = 39
                      end                    
                      item
                        Command = ecSelRight
                        ShortCut = 8231
                      end                    
                      item
                        Command = ecWordRight
                        ShortCut = 16423
                      end                    
                      item
                        Command = ecSelWordRight
                        ShortCut = 24615
                      end                    
                      item
                        Command = ecPageDown
                        ShortCut = 34
                      end                    
                      item
                        Command = ecSelPageDown
                        ShortCut = 8226
                      end                    
                      item
                        Command = ecPageBottom
                        ShortCut = 16418
                      end                    
                      item
                        Command = ecSelPageBottom
                        ShortCut = 24610
                      end                    
                      item
                        Command = ecPageUp
                        ShortCut = 33
                      end                    
                      item
                        Command = ecSelPageUp
                        ShortCut = 8225
                      end                    
                      item
                        Command = ecPageTop
                        ShortCut = 16417
                      end                    
                      item
                        Command = ecSelPageTop
                        ShortCut = 24609
                      end                    
                      item
                        Command = ecLineStart
                        ShortCut = 36
                      end                    
                      item
                        Command = ecSelLineStart
                        ShortCut = 8228
                      end                    
                      item
                        Command = ecEditorTop
                        ShortCut = 16420
                      end                    
                      item
                        Command = ecSelEditorTop
                        ShortCut = 24612
                      end                    
                      item
                        Command = ecLineEnd
                        ShortCut = 35
                      end                    
                      item
                        Command = ecSelLineEnd
                        ShortCut = 8227
                      end                    
                      item
                        Command = ecEditorBottom
                        ShortCut = 16419
                      end                    
                      item
                        Command = ecSelEditorBottom
                        ShortCut = 24611
                      end                    
                      item
                        Command = ecToggleMode
                        ShortCut = 45
                      end                    
                      item
                        Command = ecCopy
                        ShortCut = 16429
                      end                    
                      item
                        Command = ecPaste
                        ShortCut = 8237
                      end                    
                      item
                        Command = ecDeleteChar
                        ShortCut = 46
                      end                    
                      item
                        Command = ecCut
                        ShortCut = 8238
                      end                    
                      item
                        Command = ecDeleteLastChar
                        ShortCut = 8
                      end                    
                      item
                        Command = ecDeleteLastChar
                        ShortCut = 8200
                      end                    
                      item
                        Command = ecDeleteLastWord
                        ShortCut = 16392
                      end                    
                      item
                        Command = ecUndo
                        ShortCut = 32776
                      end                    
                      item
                        Command = ecRedo
                        ShortCut = 40968
                      end                    
                      item
                        Command = ecLineBreak
                        ShortCut = 13
                      end                    
                      item
                        Command = ecSelectAll
                        ShortCut = 16449
                      end                    
                      item
                        Command = ecCopy
                        ShortCut = 16451
                      end                    
                      item
                        Command = ecBlockIndent
                        ShortCut = 24649
                      end                    
                      item
                        Command = ecLineBreak
                        ShortCut = 16461
                      end                    
                      item
                        Command = ecInsertLine
                        ShortCut = 16462
                      end                    
                      item
                        Command = ecDeleteWord
                        ShortCut = 16468
                      end                    
                      item
                        Command = ecBlockUnindent
                        ShortCut = 24661
                      end                    
                      item
                        Command = ecPaste
                        ShortCut = 16470
                      end                    
                      item
                        Command = ecCut
                        ShortCut = 16472
                      end                    
                      item
                        Command = ecDeleteLine
                        ShortCut = 16473
                      end                    
                      item
                        Command = ecDeleteEOL
                        ShortCut = 24665
                      end                    
                      item
                        Command = ecUndo
                        ShortCut = 16474
                      end                    
                      item
                        Command = ecRedo
                        ShortCut = 24666
                      end                    
                      item
                        Command = ecGotoMarker0
                        ShortCut = 16432
                      end                    
                      item
                        Command = ecGotoMarker1
                        ShortCut = 16433
                      end                    
                      item
                        Command = ecGotoMarker2
                        ShortCut = 16434
                      end                    
                      item
                        Command = ecGotoMarker3
                        ShortCut = 16435
                      end                    
                      item
                        Command = ecGotoMarker4
                        ShortCut = 16436
                      end                    
                      item
                        Command = ecGotoMarker5
                        ShortCut = 16437
                      end                    
                      item
                        Command = ecGotoMarker6
                        ShortCut = 16438
                      end                    
                      item
                        Command = ecGotoMarker7
                        ShortCut = 16439
                      end                    
                      item
                        Command = ecGotoMarker8
                        ShortCut = 16440
                      end                    
                      item
                        Command = ecGotoMarker9
                        ShortCut = 16441
                      end                    
                      item
                        Command = ecSetMarker0
                        ShortCut = 24624
                      end                    
                      item
                        Command = ecSetMarker1
                        ShortCut = 24625
                      end                    
                      item
                        Command = ecSetMarker2
                        ShortCut = 24626
                      end                    
                      item
                        Command = ecSetMarker3
                        ShortCut = 24627
                      end                    
                      item
                        Command = ecSetMarker4
                        ShortCut = 24628
                      end                    
                      item
                        Command = ecSetMarker5
                        ShortCut = 24629
                      end                    
                      item
                        Command = ecSetMarker6
                        ShortCut = 24630
                      end                    
                      item
                        Command = ecSetMarker7
                        ShortCut = 24631
                      end                    
                      item
                        Command = ecSetMarker8
                        ShortCut = 24632
                      end                    
                      item
                        Command = ecSetMarker9
                        ShortCut = 24633
                      end                    
                      item
                        Command = EcFoldLevel1
                        ShortCut = 41009
                      end                    
                      item
                        Command = EcFoldLevel2
                        ShortCut = 41010
                      end                    
                      item
                        Command = EcFoldLevel1
                        ShortCut = 41011
                      end                    
                      item
                        Command = EcFoldLevel1
                        ShortCut = 41012
                      end                    
                      item
                        Command = EcFoldLevel1
                        ShortCut = 41013
                      end                    
                      item
                        Command = EcFoldLevel6
                        ShortCut = 41014
                      end                    
                      item
                        Command = EcFoldLevel7
                        ShortCut = 41015
                      end                    
                      item
                        Command = EcFoldLevel8
                        ShortCut = 41016
                      end                    
                      item
                        Command = EcFoldLevel9
                        ShortCut = 41017
                      end                    
                      item
                        Command = EcFoldLevel0
                        ShortCut = 41008
                      end                    
                      item
                        Command = EcFoldCurrent
                        ShortCut = 41005
                      end                    
                      item
                        Command = EcUnFoldCurrent
                        ShortCut = 41003
                      end                    
                      item
                        Command = EcToggleMarkupWord
                        ShortCut = 32845
                      end                    
                      item
                        Command = ecNormalSelect
                        ShortCut = 24654
                      end                    
                      item
                        Command = ecColumnSelect
                        ShortCut = 24643
                      end                    
                      item
                        Command = ecLineSelect
                        ShortCut = 24652
                      end                    
                      item
                        Command = ecTab
                        ShortCut = 9
                      end                    
                      item
                        Command = ecShiftTab
                        ShortCut = 8201
                      end                    
                      item
                        Command = ecMatchBracket
                        ShortCut = 24642
                      end                    
                      item
                        Command = ecColSelUp
                        ShortCut = 40998
                      end                    
                      item
                        Command = ecColSelDown
                        ShortCut = 41000
                      end                    
                      item
                        Command = ecColSelLeft
                        ShortCut = 40997
                      end                    
                      item
                        Command = ecColSelRight
                        ShortCut = 40999
                      end                    
                      item
                        Command = ecColSelPageDown
                        ShortCut = 40994
                      end                    
                      item
                        Command = ecColSelPageBottom
                        ShortCut = 57378
                      end                    
                      item
                        Command = ecColSelPageUp
                        ShortCut = 40993
                      end                    
                      item
                        Command = ecColSelPageTop
                        ShortCut = 57377
                      end                    
                      item
                        Command = ecColSelLineStart
                        ShortCut = 40996
                      end                    
                      item
                        Command = ecColSelLineEnd
                        ShortCut = 40995
                      end                    
                      item
                        Command = ecColSelEditorTop
                        ShortCut = 57380
                      end                    
                      item
                        Command = ecColSelEditorBottom
                        ShortCut = 57379
                      end>
                    MouseActions = <                    
                      item
                        ShiftMask = [ssShift, ssAlt]
                        ClickDir = cdDown
                        Command = emcStartSelections
                        MoveCaret = True
                      end                    
                      item
                        Shift = [ssShift]
                        ShiftMask = [ssShift, ssAlt]
                        ClickDir = cdDown
                        Command = emcStartSelections
                        MoveCaret = True
                        Option = 1
                      end                    
                      item
                        Shift = [ssAlt]
                        ShiftMask = [ssShift, ssAlt]
                        ClickDir = cdDown
                        Command = emcStartColumnSelections
                        MoveCaret = True
                      end                    
                      item
                        Shift = [ssShift, ssAlt]
                        ShiftMask = [ssShift, ssAlt]
                        ClickDir = cdDown
                        Command = emcStartColumnSelections
                        MoveCaret = True
                        Option = 1
                      end                    
                      item
                        Button = mbRight
                        Command = emcContextMenu
                      end                    
                      item
                        ClickCount = ccDouble
                        ClickDir = cdDown
                        Command = emcSelectWord
                        MoveCaret = True
                      end                    
                      item
                        ClickCount = ccTriple
                        ClickDir = cdDown
                        Command = emcSelectLine
                        MoveCaret = True
                      end                    
                      item
                        ClickCount = ccQuad
                        ClickDir = cdDown
                        Command = emcSelectPara
                        MoveCaret = True
                      end                    
                      item
                        Button = mbMiddle
                        ClickDir = cdDown
                        Command = emcPasteSelection
                        MoveCaret = True
                      end                    
                      item
                        Shift = [ssCtrl]
                        ShiftMask = [ssShift, ssAlt, ssCtrl]
                        Command = emcMouseLink
                      end>
                    MouseTextActions = <>
                    MouseSelActions = <                    
                      item
                        ClickDir = cdDown
                        Command = emcStartDragMove
                      end>
                    Lines.Strings = (
                      ''
                    )
                    VisibleSpecialChars = [vscSpace, vscTabAtLast]
                    SelectedColor.BackPriority = 50
                    SelectedColor.ForePriority = 50
                    SelectedColor.FramePriority = 50
                    SelectedColor.BoldPriority = 50
                    SelectedColor.ItalicPriority = 50
                    SelectedColor.UnderlinePriority = 50
                    SelectedColor.StrikeOutPriority = 50
                    OnChange = SynEditSQLEditorChange
                    inline SynLeftGutterPartList1: TSynGutterPartList
                      object SynGutterMarks1: TSynGutterMarks
                        Width = 24
                        MouseActions = <>
                      end
                      object SynGutterLineNumber1: TSynGutterLineNumber
                        Width = 15
                        MouseActions = <>
                        MarkupInfo.Background = clBtnFace
                        MarkupInfo.Foreground = clNone
                        DigitCount = 2
                        ShowOnlyLineNumbersMultiplesOf = 1
                        ZeroStart = False
                        LeadingZeros = False
                      end
                      object SynGutterChanges1: TSynGutterChanges
                        Width = 4
                        MouseActions = <>
                        ModifiedColor = 59900
                        SavedColor = clGreen
                      end
                      object SynGutterSeparator1: TSynGutterSeparator
                        Width = 2
                        MouseActions = <>
                        MarkupInfo.Background = clWhite
                        MarkupInfo.Foreground = clGray
                      end
                      object SynGutterCodeFolding1: TSynGutterCodeFolding
                        MouseActions = <                        
                          item
                            Button = mbRight
                            Command = emcCodeFoldContextMenu
                          end                        
                          item
                            ShiftMask = [ssShift]
                            Button = mbMiddle
                            ClickCount = ccAny
                            ClickDir = cdDown
                            Command = emcCodeFoldCollaps
                          end                        
                          item
                            Shift = [ssShift]
                            ShiftMask = [ssShift]
                            Button = mbMiddle
                            ClickCount = ccAny
                            ClickDir = cdDown
                            Command = emcCodeFoldCollaps
                            Option = 1
                          end                        
                          item
                            ClickCount = ccAny
                            ClickDir = cdDown
                            Command = emcNone
                          end>
                        MarkupInfo.Background = clNone
                        MarkupInfo.Foreground = clGray
                        MouseActionsExpanded = <                        
                          item
                            ClickCount = ccAny
                            ClickDir = cdDown
                            Command = emcCodeFoldCollaps
                          end>
                        MouseActionsCollapsed = <                        
                          item
                            Shift = [ssCtrl]
                            ShiftMask = [ssCtrl]
                            ClickCount = ccAny
                            ClickDir = cdDown
                            Command = emcCodeFoldExpand
                          end                        
                          item
                            ShiftMask = [ssCtrl]
                            ClickCount = ccAny
                            ClickDir = cdDown
                            Command = emcCodeFoldExpand
                            Option = 1
                          end>
                      end
                    end
                  end
                  object Panel48: TPanel
                    Left = 0
                    Height = 20
                    Top = 0
                    Width = 1771
                    Align = alTop
                    ClientHeight = 16
                    ClientWidth = 1767
                    TabOrder = 1
                    object Label14: TLabel
                      Left = 1
                      Height = 18
                      Hint = 'Enter your SQL query below'
                      Top = 1
                      Width = 1769
                      Align = alClient
                      Alignment = taCenter
                      Caption = 'SQL Query Editor'
                      ParentColor = False
                    end
                  end
                end
                object PairSplitterSide10: TPairSplitterSide
                  Cursor = crArrow
                  Left = 0
                  Height = 343
                  Top = 205
                  Width = 1771
                  ClientWidth = 1771
                  ClientHeight = 343
                  object PairSplitter6: TPairSplitter
                    Left = 0
                    Height = 343
                    Top = 0
                    Width = 1771
                    Align = alClient
                    Position = 764
                    object PairSplitterSide11: TPairSplitterSide
                      Cursor = crArrow
                      Left = 0
                      Height = 343
                      Top = 0
                      Width = 764
                      ClientWidth = 764
                      ClientHeight = 343
                      object PairSplitter7: TPairSplitter
                        Left = 0
                        Height = 343
                        Top = 0
                        Width = 764
                        Align = alClient
                        Position = 381
                        object PairSplitterSide13: TPairSplitterSide
                          Cursor = crArrow
                          Left = 0
                          Height = 343
                          Top = 0
                          Width = 381
                          ClientWidth = 381
                          ClientHeight = 343
                          object PairSplitter8: TPairSplitter
                            Left = 0
                            Height = 343
                            Top = 0
                            Width = 381
                            Align = alClient
                            Position = 180
                            object PairSplitterSide15: TPairSplitterSide
                              Cursor = crArrow
                              Left = 0
                              Height = 343
                              Top = 0
                              Width = 180
                              ClientWidth = 180
                              ClientHeight = 343
                              object Panel22: TPanel
                                Left = 0
                                Height = 30
                                Top = 20
                                Width = 180
                                Align = alTop
                                Caption = 'Panel22'
                                ClientHeight = 26
                                ClientWidth = 176
                                TabOrder = 0
                                object ButtonApplyTableNameToQueryText: TButton
                                  Left = 1
                                  Height = 28
                                  Hint = 'Insert table name into the SQL query.'
                                  Top = 1
                                  Width = 178
                                  Align = alClient
                                  Caption = 'Apply'
                                  OnClick = ButtonApplyTableNameToQueryTextClick
                                  TabOrder = 0
                                end
                              end
                              object Panel23: TPanel
                                Left = 0
                                Height = 30
                                Top = 50
                                Width = 180
                                Align = alTop
                                Caption = 'Panel23'
                                ClientHeight = 26
                                ClientWidth = 176
                                TabOrder = 1
                                object DBNavigatorTablesForQueries: TDBNavigator
                                  Left = 1
                                  Height = 28
                                  Top = 1
                                  Width = 178
                                  Align = alClient
                                  BevelOuter = bvNone
                                  ChildSizing.EnlargeHorizontal = crsScaleChilds
                                  ChildSizing.EnlargeVertical = crsScaleChilds
                                  ChildSizing.ShrinkHorizontal = crsScaleChilds
                                  ChildSizing.ShrinkVertical = crsScaleChilds
                                  ChildSizing.Layout = cclLeftToRightThenTopToBottom
                                  ChildSizing.ControlsPerLine = 100
                                  ClientHeight = 24
                                  ClientWidth = 174
                                  DataSource = DataModule1.DatasourceTables
                                  Options = []
                                  TabOrder = 0
                                end
                              end
                              object Panel24: TPanel
                                Left = 0
                                Height = 263
                                Top = 80
                                Width = 180
                                Align = alClient
                                Caption = 'Panel24'
                                ClientHeight = 259
                                ClientWidth = 176
                                TabOrder = 2
                                object DBGridTablesForQueries: TRxDBGrid
                                  Left = 1
                                  Height = 261
                                  Top = 1
                                  Width = 178
                                  ColumnDefValues.BlobText = '(blob)'
                                  TitleButtons = True
                                  AutoSort = True
                                  Columns = <                                  
                                    item
                                      Title.Alignment = taCenter
                                      Title.Orientation = toHorizontal
                                      Title.Caption = 'Table'
                                      Width = 162
                                      FieldName = 'TABLENAME'
                                      EditButtons = <>
                                      Filter.DropDownRows = 0
                                      Filter.EmptyValue = '(Empty)'
                                      Filter.NotEmptyValue = '(Not empty)'
                                      Filter.AllValue = '(All values)'
                                      Filter.EmptyFont.Style = [fsItalic]
                                      Filter.ItemIndex = -1
                                      Footers = <>
                                    end>
                                  KeyStrokes = <                                  
                                    item
                                      Command = rxgcShowFindDlg
                                      ShortCut = 16454
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcShowColumnsDlg
                                      ShortCut = 16471
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcShowFilterDlg
                                      ShortCut = 16468
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcShowSortDlg
                                      ShortCut = 16467
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcShowQuickFilter
                                      ShortCut = 16465
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcHideQuickFilter
                                      ShortCut = 16456
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcSelectAll
                                      ShortCut = 16449
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcDeSelectAll
                                      ShortCut = 16429
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcInvertSelection
                                      ShortCut = 16426
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcOptimizeColumnsWidth
                                      ShortCut = 16427
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcCopyCellValue
                                      ShortCut = 16451
                                      Enabled = True
                                    end>
                                  FooterOptions.RowCount = 1
                                  FooterOptions.DrawFullLine = False
                                  SearchOptions.QuickSearchOptions = [loCaseInsensitive, loPartialKey]
                                  SearchOptions.FromStart = False
                                  OptionsRx = [rdgAllowColumnsForm, rdgAllowDialogFind, rdgDblClickOptimizeColWidth, rdgAllowQuickSearch, rdgAllowQuickFilter, rdgAllowFilterForm, rdgAllowSortForm, rdgAllowToolMenu, rdgCaseInsensitiveSort]
                                  FooterRowCount = 1
                                  Align = alClient
                                  AutoFillColumns = True
                                  Color = clWindow
                                  DrawFullLine = False
                                  FocusColor = clRed
                                  SelectedColor = clHighlight
                                  DataSource = DataModule1.DatasourceTables
                                  DoubleBuffered = True
                                  Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgHeaderHotTracking, dgHeaderPushedLook, dgDblClickAutoSize, dgDisplayMemoText]
                                  ParentDoubleBuffered = False
                                  TabOrder = 0
                                end
                              end
                              object Panel17: TPanel
                                Left = 0
                                Height = 20
                                Top = 0
                                Width = 180
                                Align = alTop
                                ClientHeight = 16
                                ClientWidth = 176
                                TabOrder = 3
                                object Label2: TLabel
                                  Left = 1
                                  Height = 18
                                  Top = 1
                                  Width = 178
                                  Align = alClient
                                  Alignment = taCenter
                                  Caption = 'List Of Tables'
                                  ParentColor = False
                                end
                              end
                            end
                            object PairSplitterSide16: TPairSplitterSide
                              Cursor = crArrow
                              Left = 185
                              Height = 343
                              Top = 0
                              Width = 196
                              ClientWidth = 196
                              ClientHeight = 343
                              object Panel25: TPanel
                                Left = 0
                                Height = 30
                                Top = 20
                                Width = 196
                                Align = alTop
                                Caption = 'Panel25'
                                ClientHeight = 26
                                ClientWidth = 192
                                TabOrder = 0
                                object ButtonApplyFieldNameToQueryText: TButton
                                  Left = 1
                                  Height = 28
                                  Hint = 'Insert field (column) into the SQL query.'
                                  Top = 1
                                  Width = 194
                                  Align = alClient
                                  Caption = 'Apply'
                                  OnClick = ButtonApplyFieldNameToQueryTextClick
                                  TabOrder = 0
                                end
                              end
                              object Panel26: TPanel
                                Left = 0
                                Height = 30
                                Top = 50
                                Width = 196
                                Align = alTop
                                Caption = 'Panel26'
                                ClientHeight = 26
                                ClientWidth = 192
                                TabOrder = 1
                                object DBNavigatorFieldsForQueries: TDBNavigator
                                  Left = 1
                                  Height = 28
                                  Top = 1
                                  Width = 194
                                  Align = alClient
                                  BevelOuter = bvNone
                                  ChildSizing.EnlargeHorizontal = crsScaleChilds
                                  ChildSizing.EnlargeVertical = crsScaleChilds
                                  ChildSizing.ShrinkHorizontal = crsScaleChilds
                                  ChildSizing.ShrinkVertical = crsScaleChilds
                                  ChildSizing.Layout = cclLeftToRightThenTopToBottom
                                  ChildSizing.ControlsPerLine = 100
                                  ClientHeight = 24
                                  ClientWidth = 190
                                  DataSource = DataModule1.DatasourceFields
                                  Options = []
                                  TabOrder = 0
                                end
                              end
                              object Panel27: TPanel
                                Left = 0
                                Height = 263
                                Top = 80
                                Width = 196
                                Align = alClient
                                Caption = 'Panel27'
                                ClientHeight = 259
                                ClientWidth = 192
                                TabOrder = 2
                                object DBGridFieldsForQueries: TRxDBGrid
                                  Left = 1
                                  Height = 261
                                  Top = 1
                                  Width = 194
                                  ColumnDefValues.BlobText = '(blob)'
                                  TitleButtons = True
                                  AutoSort = True
                                  Columns = <                                  
                                    item
                                      Title.Alignment = taCenter
                                      Title.Orientation = toHorizontal
                                      Title.Caption = 'Field'
                                      Width = 178
                                      FieldName = 'FIELDNAME'
                                      EditButtons = <>
                                      Filter.DropDownRows = 0
                                      Filter.EmptyValue = '(Empty)'
                                      Filter.NotEmptyValue = '(Not empty)'
                                      Filter.AllValue = '(All values)'
                                      Filter.EmptyFont.Style = [fsItalic]
                                      Filter.ItemIndex = -1
                                      Footers = <>
                                    end>
                                  KeyStrokes = <                                  
                                    item
                                      Command = rxgcShowFindDlg
                                      ShortCut = 16454
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcShowColumnsDlg
                                      ShortCut = 16471
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcShowFilterDlg
                                      ShortCut = 16468
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcShowSortDlg
                                      ShortCut = 16467
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcShowQuickFilter
                                      ShortCut = 16465
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcHideQuickFilter
                                      ShortCut = 16456
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcSelectAll
                                      ShortCut = 16449
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcDeSelectAll
                                      ShortCut = 16429
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcInvertSelection
                                      ShortCut = 16426
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcOptimizeColumnsWidth
                                      ShortCut = 16427
                                      Enabled = True
                                    end                                  
                                    item
                                      Command = rxgcCopyCellValue
                                      ShortCut = 16451
                                      Enabled = True
                                    end>
                                  FooterOptions.RowCount = 1
                                  FooterOptions.DrawFullLine = False
                                  SearchOptions.QuickSearchOptions = [loCaseInsensitive, loPartialKey]
                                  SearchOptions.FromStart = False
                                  OptionsRx = [rdgAllowColumnsForm, rdgAllowDialogFind, rdgDblClickOptimizeColWidth, rdgAllowQuickSearch, rdgAllowQuickFilter, rdgAllowFilterForm, rdgAllowSortForm, rdgAllowToolMenu, rdgCaseInsensitiveSort]
                                  FooterRowCount = 1
                                  Align = alClient
                                  AutoFillColumns = True
                                  Color = clWindow
                                  DrawFullLine = False
                                  FocusColor = clRed
                                  SelectedColor = clHighlight
                                  DataSource = DataModule1.DatasourceFields
                                  DoubleBuffered = True
                                  Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgHeaderHotTracking, dgHeaderPushedLook, dgDblClickAutoSize, dgDisplayMemoText]
                                  ParentDoubleBuffered = False
                                  TabOrder = 0
                                end
                              end
                              object Panel39: TPanel
                                Left = 0
                                Height = 20
                                Top = 0
                                Width = 196
                                Align = alTop
                                ClientHeight = 16
                                ClientWidth = 192
                                TabOrder = 3
                                object Label3: TLabel
                                  Left = 1
                                  Height = 18
                                  Top = 1
                                  Width = 194
                                  Align = alClient
                                  Alignment = taCenter
                                  Caption = 'List Of Fields'
                                  ParentColor = False
                                end
                              end
                            end
                          end
                        end
                        object PairSplitterSide14: TPairSplitterSide
                          Cursor = crArrow
                          Left = 386
                          Height = 343
                          Top = 0
                          Width = 378
                          ClientWidth = 378
                          ClientHeight = 343
                          object PairSplitter9: TPairSplitter
                            Left = 0
                            Height = 343
                            Top = 0
                            Width = 378
                            Align = alClient
                            Position = 194
                            object PairSplitterSide17: TPairSplitterSide
                              Cursor = crArrow
                              Left = 0
                              Height = 343
                              Top = 0
                              Width = 194
                              ClientWidth = 194
                              ClientHeight = 343
                              object Panel28: TPanel
                                Left = 0
                                Height = 30
                                Top = 0
                                Width = 194
                                Align = alTop
                                Caption = 'Panel28'
                                ClientHeight = 26
                                ClientWidth = 190
                                TabOrder = 0
                                object ButtonApplySqlExpressionToQueryText: TButton
                                  Left = 1
                                  Height = 28
                                  Hint = 'Insert expression into the SQL query.'
                                  Top = 1
                                  Width = 192
                                  Align = alClient
                                  Caption = 'Apply'
                                  OnClick = ButtonApplySqlExpressionToQueryTextClick
                                  TabOrder = 0
                                end
                              end
                              object Panel29: TPanel
                                Left = 0
                                Height = 313
                                Top = 30
                                Width = 194
                                Align = alClient
                                Caption = 'Panel29'
                                ClientHeight = 309
                                ClientWidth = 190
                                TabOrder = 1
                                object ListBoxSqlExpressions: TListBox
                                  Left = 1
                                  Height = 311
                                  Top = 1
                                  Width = 192
                                  Align = alClient
                                  Items.Strings = (
                                    'AS'
                                    'SELECT * FROM tablelist'
                                    'SELECT fieldlist FROM tablelist'
                                    'SELECT fieldlist FROM tablelist WHERE condition'
                                    'FROM tablelist'
                                    'WHERE '
                                    'WHERE condition'
                                    'HAVING condition'
                                    'GROUP BY fieldlist'
                                    'CREATE TABLE table (fieldlist)'
                                    'DROP TABLE table'
                                    'ALTER TABLE table ADD COLUMN column'
                                    'ALTER TABLE table DROP COLUMN column'
                                    'ASSIGN TO variable selectstatement'
                                    'SAVE TABLE table'
                                    'RELEASE TABLE tableorvariable'
                                    'COMMIT'
                                    'INSERT INTO table VALUES (valuelist)'
                                    'INSERT INTO table (fieldlist) VALUES (valuelist)'
                                    'INSERT INTO table selectstatement'
                                    'UPDATE table SET updatelist'
                                    'UPDATE table SET updatelist WHERE condition'
                                    'DELETE FROM table '
                                    'DELETE FROM table WHERE condition'
                                  )
                                  ItemHeight = 0
                                  ScrollWidth = 188
                                  TabOrder = 0
                                  TopIndex = -1
                                end
                              end
                            end
                            object PairSplitterSide18: TPairSplitterSide
                              Cursor = crArrow
                              Left = 199
                              Height = 343
                              Top = 0
                              Width = 179
                              ClientWidth = 179
                              ClientHeight = 343
                              object Panel30: TPanel
                                Left = 0
                                Height = 30
                                Top = 0
                                Width = 179
                                Align = alTop
                                Caption = 'Panel30'
                                ClientHeight = 26
                                ClientWidth = 175
                                TabOrder = 0
                                object ButtonApplySqlFunctionToQueryText: TButton
                                  Left = 1
                                  Height = 28
                                  Hint = 'Insert operator into the SQL query.'
                                  Top = 1
                                  Width = 177
                                  Align = alClient
                                  Caption = 'Apply'
                                  OnClick = ButtonApplySqlFunctionToQueryTextClick
                                  TabOrder = 0
                                end
                              end
                              object Panel31: TPanel
                                Left = 0
                                Height = 313
                                Top = 30
                                Width = 179
                                Align = alClient
                                Caption = 'Panel31'
                                ClientHeight = 309
                                ClientWidth = 175
                                TabOrder = 1
                                object ListBoxSqlFunctions: TListBox
                                  Left = 1
                                  Height = 311
                                  Top = 1
                                  Width = 177
                                  Align = alClient
                                  Items.Strings = (
                                    'OR'
                                    'AND'
                                    '+'
                                    '-'
                                    '*'
                                    '/'
                                    '<'
                                    '<='
                                    '>'
                                    '>='
                                    '='
                                    'LIKE'
                                    'LIKE (''%string%'')'
                                    'IN'
                                    'IN (''string1'',''string2'')'
                                    'FIX(expression, precision)'
                                    'TRUNC(expression, precision)'
                                    'ASNUMBER(expression)'
                                    'FORMAT(value, formatstring)'
                                    'FORMAT(value,''[literalstring]%[width][.prec]type'')'
                                    'YEAR'
                                    'MONTH'
                                    'DAY'
                                    'WEEKNUMBERS'
                                    'DATEADD (interval, number, datestring)'
                                    'SOUNDEX(expression)'
                                    'LOWER(expression)'
                                    'UPPER(expression)'
                                    'TRIM(expression)'
                                    'LEFT(expression, count)'
                                    'RIGHT(expression, count)'
                                    'MID(expression, from, count)'
                                    'LENGTH(expression)'
                                    'REPLACE(source, oldpattern, newpattern)'
                                    'SUBSTR_AFTER(source, substring)'
                                    'SUBSTR_BEFORE(source, substring)'
                                    'SQR(expression)'
                                    'SQRT(expression)'
                                    'SIN(expression)'
                                    'COS(expression)'
                                    'CEIL(expression)'
                                    'FLOOR(expression)'
                                  )
                                  ItemHeight = 0
                                  ScrollWidth = 173
                                  TabOrder = 0
                                  TopIndex = -1
                                end
                              end
                            end
                          end
                        end
                      end
                    end
                    object PairSplitterSide12: TPairSplitterSide
                      Cursor = crArrow
                      Left = 769
                      Height = 343
                      Top = 0
                      Width = 1002
                      ClientWidth = 1002
                      ClientHeight = 343
                      object Panel20: TPanel
                        Left = 0
                        Height = 40
                        Top = 20
                        Width = 1002
                        Align = alTop
                        ClientHeight = 36
                        ClientWidth = 998
                        TabOrder = 0
                        object DBNavigatorQueriesParameters: TDBNavigator
                          Left = 193
                          Height = 30
                          Top = 5
                          Width = 804
                          Align = alClient
                          BevelOuter = bvNone
                          BorderSpacing.Around = 4
                          ChildSizing.EnlargeHorizontal = crsScaleChilds
                          ChildSizing.EnlargeVertical = crsScaleChilds
                          ChildSizing.ShrinkHorizontal = crsScaleChilds
                          ChildSizing.ShrinkVertical = crsScaleChilds
                          ChildSizing.Layout = cclLeftToRightThenTopToBottom
                          ChildSizing.ControlsPerLine = 100
                          ClientHeight = 26
                          ClientWidth = 800
                          DataSource = DataModule1.DatasourceQueriesParameters
                          Options = []
                          TabOrder = 0
                        end
                        object ButtonDeleteAllQueryParameters: TButton
                          Left = 5
                          Height = 30
                          Hint = 'Delete all saved query parameters, for the current SQL query.'
                          Top = 5
                          Width = 184
                          Align = alLeft
                          AutoSize = True
                          BorderSpacing.Around = 4
                          Caption = 'Delete All Query Parameters'
                          OnClick = ButtonDeleteAllQueryParametersClick
                          TabOrder = 1
                        end
                      end
                      object Panel21: TPanel
                        Left = 0
                        Height = 283
                        Top = 60
                        Width = 1002
                        Align = alClient
                        Caption = 'Panel21'
                        ClientHeight = 279
                        ClientWidth = 998
                        TabOrder = 1
                        object DBGridQueriesParameters: TRxDBGrid
                          Left = 1
                          Height = 281
                          Top = 1
                          Width = 1000
                          ColumnDefValues.BlobText = '(blob)'
                          TitleButtons = True
                          AutoSort = True
                          Columns = <                          
                            item
                              ReadOnly = True
                              Title.Alignment = taCenter
                              Title.Orientation = toHorizontal
                              Title.Caption = 'QUERY_ID'
                              Width = 60
                              FieldName = 'QUERY_ID'
                              EditButtons = <>
                              Filter.DropDownRows = 0
                              Filter.EmptyValue = '(Empty)'
                              Filter.NotEmptyValue = '(Not empty)'
                              Filter.AllValue = '(All values)'
                              Filter.EmptyFont.Style = [fsItalic]
                              Filter.ItemIndex = -1
                              Footers = <>
                            end                          
                            item
                              ReadOnly = True
                              Title.Alignment = taCenter
                              Title.Orientation = toHorizontal
                              Title.Caption = 'QUERYPARAMETER_ID'
                              Width = 60
                              FieldName = 'QUERYPARAMETER_ID'
                              EditButtons = <>
                              Filter.DropDownRows = 0
                              Filter.EmptyValue = '(Empty)'
                              Filter.NotEmptyValue = '(Not empty)'
                              Filter.AllValue = '(All values)'
                              Filter.EmptyFont.Style = [fsItalic]
                              Filter.ItemIndex = -1
                              Footers = <>
                            end                          
                            item
                              Title.Alignment = taCenter
                              Title.Orientation = toHorizontal
                              Title.Caption = 'Parameter'
                              Width = 300
                              FieldName = 'QUERYPARAMETERNAME'
                              EditButtons = <>
                              Filter.DropDownRows = 0
                              Filter.EmptyValue = '(Empty)'
                              Filter.NotEmptyValue = '(Not empty)'
                              Filter.AllValue = '(All values)'
                              Filter.EmptyFont.Style = [fsItalic]
                              Filter.ItemIndex = -1
                              Footers = <>
                            end                          
                            item
                              Title.Alignment = taCenter
                              Title.Orientation = toHorizontal
                              Title.Caption = 'Value'
                              Width = 500
                              FieldName = 'QUERYPARAMETERVALUE'
                              EditButtons = <>
                              Filter.DropDownRows = 0
                              Filter.EmptyValue = '(Empty)'
                              Filter.NotEmptyValue = '(Not empty)'
                              Filter.AllValue = '(All values)'
                              Filter.EmptyFont.Style = [fsItalic]
                              Filter.ItemIndex = -1
                              Footers = <>
                            end                          
                            item
                              Title.Alignment = taCenter
                              Title.Orientation = toHorizontal
                              Title.Caption = 'Comment'
                              Width = 300
                              FieldName = 'QUERYCOMMENT'
                              EditButtons = <>
                              Filter.DropDownRows = 0
                              Filter.EmptyValue = '(Empty)'
                              Filter.NotEmptyValue = '(Not empty)'
                              Filter.AllValue = '(All values)'
                              Filter.EmptyFont.Style = [fsItalic]
                              Filter.ItemIndex = -1
                              Footers = <>
                            end>
                          KeyStrokes = <                          
                            item
                              Command = rxgcShowFindDlg
                              ShortCut = 16454
                              Enabled = True
                            end                          
                            item
                              Command = rxgcShowColumnsDlg
                              ShortCut = 16471
                              Enabled = True
                            end                          
                            item
                              Command = rxgcShowFilterDlg
                              ShortCut = 16468
                              Enabled = True
                            end                          
                            item
                              Command = rxgcShowSortDlg
                              ShortCut = 16467
                              Enabled = True
                            end                          
                            item
                              Command = rxgcShowQuickFilter
                              ShortCut = 16465
                              Enabled = True
                            end                          
                            item
                              Command = rxgcHideQuickFilter
                              ShortCut = 16456
                              Enabled = True
                            end                          
                            item
                              Command = rxgcSelectAll
                              ShortCut = 16449
                              Enabled = True
                            end                          
                            item
                              Command = rxgcDeSelectAll
                              ShortCut = 16429
                              Enabled = True
                            end                          
                            item
                              Command = rxgcInvertSelection
                              ShortCut = 16426
                              Enabled = True
                            end                          
                            item
                              Command = rxgcOptimizeColumnsWidth
                              ShortCut = 16427
                              Enabled = True
                            end                          
                            item
                              Command = rxgcCopyCellValue
                              ShortCut = 16451
                              Enabled = True
                            end>
                          FooterOptions.RowCount = 1
                          FooterOptions.DrawFullLine = False
                          SearchOptions.QuickSearchOptions = [loCaseInsensitive, loPartialKey]
                          SearchOptions.FromStart = False
                          OptionsRx = [rdgAllowColumnsForm, rdgAllowDialogFind, rdgDblClickOptimizeColWidth, rdgAllowQuickSearch, rdgAllowQuickFilter, rdgAllowFilterForm, rdgAllowSortForm, rdgAllowToolMenu, rdgCaseInsensitiveSort]
                          FooterRowCount = 1
                          Align = alClient
                          Color = clWindow
                          DrawFullLine = False
                          FocusColor = clRed
                          SelectedColor = clHighlight
                          DataSource = DataModule1.DatasourceQueriesParameters
                          DoubleBuffered = True
                          Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgHeaderHotTracking, dgHeaderPushedLook, dgDblClickAutoSize, dgDisplayMemoText]
                          ParentDoubleBuffered = False
                          TabOrder = 0
                        end
                      end
                      object Panel49: TPanel
                        Left = 0
                        Height = 20
                        Top = 0
                        Width = 1002
                        Align = alTop
                        ClientHeight = 16
                        ClientWidth = 998
                        TabOrder = 2
                        object Label15: TLabel
                          Left = 1
                          Height = 18
                          Top = 1
                          Width = 1000
                          Align = alClient
                          Alignment = taCenter
                          Caption = 'Query Parameters'
                          ParentColor = False
                        end
                      end
                    end
                  end
                end
              end
            end
          end
        end
        object TabSheetQueryResult: TTabSheet
          Caption = 'QueryResult'
          ClientHeight = 839
          ClientWidth = 1777
          object Panel32: TPanel
            Left = 0
            Height = 813
            Top = 0
            Width = 1771
            Align = alClient
            Caption = 'Panel32'
            ClientHeight = 809
            ClientWidth = 1767
            TabOrder = 0
            object Panel16: TPanel
              Left = 1
              Height = 40
              Top = 21
              Width = 1769
              Align = alTop
              ClientHeight = 36
              ClientWidth = 1765
              TabOrder = 0
              object DBNavigatorQueryResult: TDBNavigator
                Left = 227
                Height = 38
                Top = 1
                Width = 1541
                Align = alClient
                BevelOuter = bvNone
                ChildSizing.EnlargeHorizontal = crsScaleChilds
                ChildSizing.EnlargeVertical = crsScaleChilds
                ChildSizing.ShrinkHorizontal = crsScaleChilds
                ChildSizing.ShrinkVertical = crsScaleChilds
                ChildSizing.Layout = cclLeftToRightThenTopToBottom
                ChildSizing.ControlsPerLine = 100
                ClientHeight = 34
                ClientWidth = 1537
                DataSource = DataModule1.DatasourceQueryResult
                Options = []
                TabOrder = 0
              end
              object ButtonFilterQueryResult: TButton
                Left = 127
                Height = 38
                Top = 1
                Width = 45
                Align = alLeft
                AutoSize = True
                Caption = 'Filter'
                OnClick = ButtonFilterQueryResultClick
                TabOrder = 1
              end
              object ButtonFindQueryResult: TButton
                Left = 87
                Height = 38
                Top = 1
                Width = 40
                Align = alLeft
                AutoSize = True
                Caption = 'Find'
                OnClick = ButtonFindQueryResultClick
                TabOrder = 2
              end
              object ButtonExportQueryResult: TButton
                Left = 172
                Height = 38
                Top = 1
                Width = 55
                Align = alLeft
                AutoSize = True
                Caption = 'Export'
                OnClick = ButtonExportQueryResultClick
                TabOrder = 3
              end
              object ButtonFindUnloadQueryResult: TButton
                Left = 1
                Height = 38
                Top = 1
                Width = 86
                Align = alLeft
                AutoSize = True
                Caption = 'UnloadData'
                OnClick = ButtonFindUnloadQueryResultClick
                TabOrder = 4
              end
            end
            object Panel18: TPanel
              Left = 1
              Height = 721
              Top = 61
              Width = 1769
              Align = alClient
              Caption = 'Panel18'
              ClientHeight = 717
              ClientWidth = 1765
              TabOrder = 1
              object DBGridQueryResult: TRxDBGrid
                Left = 1
                Height = 719
                Top = 1
                Width = 1767
                ColumnDefValues.BlobText = '(blob)'
                TitleButtons = True
                AutoSort = True
                KeyStrokes = <                
                  item
                    Command = rxgcShowFindDlg
                    ShortCut = 16454
                    Enabled = True
                  end                
                  item
                    Command = rxgcShowColumnsDlg
                    ShortCut = 16471
                    Enabled = True
                  end                
                  item
                    Command = rxgcShowFilterDlg
                    ShortCut = 16468
                    Enabled = True
                  end                
                  item
                    Command = rxgcShowSortDlg
                    ShortCut = 16467
                    Enabled = True
                  end                
                  item
                    Command = rxgcShowQuickFilter
                    ShortCut = 16465
                    Enabled = True
                  end                
                  item
                    Command = rxgcHideQuickFilter
                    ShortCut = 16456
                    Enabled = True
                  end                
                  item
                    Command = rxgcSelectAll
                    ShortCut = 16449
                    Enabled = True
                  end                
                  item
                    Command = rxgcDeSelectAll
                    ShortCut = 16429
                    Enabled = True
                  end                
                  item
                    Command = rxgcInvertSelection
                    ShortCut = 16426
                    Enabled = True
                  end                
                  item
                    Command = rxgcOptimizeColumnsWidth
                    ShortCut = 16427
                    Enabled = True
                  end                
                  item
                    Command = rxgcCopyCellValue
                    ShortCut = 16451
                    Enabled = True
                  end>
                FooterOptions.RowCount = 1
                FooterOptions.DrawFullLine = False
                SearchOptions.QuickSearchOptions = [loCaseInsensitive, loPartialKey]
                SearchOptions.FromStart = False
                OptionsRx = [rdgAllowColumnsForm, rdgAllowDialogFind, rdgDblClickOptimizeColWidth, rdgAllowQuickSearch, rdgAllowQuickFilter, rdgAllowFilterForm, rdgAllowSortForm, rdgAllowToolMenu, rdgCaseInsensitiveSort]
                FooterRowCount = 1
                Align = alClient
                Color = clWindow
                DrawFullLine = False
                FocusColor = clRed
                SelectedColor = clHighlight
                DataSource = DataModule1.DatasourceQueryResult
                DoubleBuffered = True
                Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgHeaderHotTracking, dgHeaderPushedLook, dgDblClickAutoSize, dgDisplayMemoText]
                ParentDoubleBuffered = False
                TabOrder = 0
              end
            end
            object Panel34: TPanel
              Left = 1
              Height = 30
              Top = 782
              Width = 1769
              Align = alBottom
              ClientHeight = 26
              ClientWidth = 1765
              TabOrder = 2
              object ButtonSaveQueryResult: TButton
                Left = 5
                Height = 20
                Top = 5
                Width = 183
                Align = alLeft
                AutoSize = True
                BorderSpacing.Right = 8
                BorderSpacing.Around = 4
                Caption = 'Save Query Result To A File: '
                OnClick = ButtonSaveQueryResultClick
                TabOrder = 0
              end
              object FileNameEditSaveQueryResult: TFileNameEdit
                Left = 200
                Height = 28
                Top = 1
                Width = 1568
                DialogOptions = []
                FilterIndex = 0
                HideDirectories = False
                ButtonWidth = 23
                NumGlyphs = 1
                Align = alClient
                MaxLength = 0
                TabOrder = 1
              end
            end
            object Panel45: TPanel
              Left = 1
              Height = 20
              Top = 1
              Width = 1769
              Align = alTop
              ClientHeight = 16
              ClientWidth = 1765
              TabOrder = 3
              object Label11: TLabel
                Left = 1
                Height = 18
                Top = 1
                Width = 1767
                Align = alClient
                Alignment = taCenter
                Caption = 'Query Result'
                ParentColor = False
              end
            end
          end
        end
      end
    end
    object TabSheetExternalSources: TTabSheet
      Caption = 'ExternalSources'
      ClientHeight = 869
      ClientWidth = 1781
      object PairSplitter16: TPairSplitter
        Cursor = crVSplit
        Left = 0
        Height = 843
        Top = 0
        Width = 1781
        Align = alClient
        Position = 400
        SplitterType = pstVertical
        object PairSplitterSide31: TPairSplitterSide
          Cursor = crArrow
          Left = 0
          Height = 400
          Top = 0
          Width = 1781
          ClientWidth = 1781
          ClientHeight = 400
          object Panel67: TPanel
            Left = 0
            Height = 400
            Top = 0
            Width = 1781
            Align = alClient
            Caption = 'Panel67'
            ClientHeight = 396
            ClientWidth = 1777
            TabOrder = 0
            object PairSplitter17: TPairSplitter
              Cursor = crVSplit
              Left = 1
              Height = 398
              Top = 1
              Width = 1779
              Align = alClient
              Position = 150
              SplitterType = pstVertical
              object PairSplitterSide33: TPairSplitterSide
                Cursor = crArrow
                Left = 0
                Height = 150
                Top = 0
                Width = 1779
                ClientWidth = 1779
                ClientHeight = 150
                object Panel68: TPanel
                  Left = 0
                  Height = 40
                  Top = 20
                  Width = 1779
                  Align = alTop
                  ClientHeight = 36
                  ClientWidth = 1775
                  TabOrder = 0
                  object DBNavigatorSQLConnectors: TDBNavigator
                    Left = 710
                    Height = 30
                    Top = 5
                    Width = 1064
                    Align = alClient
                    BevelOuter = bvNone
                    BorderSpacing.Around = 4
                    ChildSizing.EnlargeHorizontal = crsScaleChilds
                    ChildSizing.EnlargeVertical = crsScaleChilds
                    ChildSizing.ShrinkHorizontal = crsScaleChilds
                    ChildSizing.ShrinkVertical = crsScaleChilds
                    ChildSizing.Layout = cclLeftToRightThenTopToBottom
                    ChildSizing.ControlsPerLine = 100
                    ClientHeight = 26
                    ClientWidth = 1060
                    DataSource = DataModule1.DatasourceSQLConnectors
                    Options = []
                    TabOrder = 0
                  end
                  object ButtonImport: TButton
                    Left = 120
                    Height = 30
                    Hint = 'Import tables from the external database, into MightyQuery project,'#10'as new CSV files.'
                    Top = 5
                    Width = 129
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'IMPORT TABLE(S)'
                    Font.Style = [fsBold]
                    OnClick = ButtonImportClick
                    ParentFont = False
                    TabOrder = 1
                  end
                  object ButtonTestConnection: TButton
                    Left = 5
                    Height = 30
                    Hint = 'Test SQL connector connection.'
                    Top = 5
                    Width = 111
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Test Connection'
                    OnClick = ButtonTestConnectionClick
                    TabOrder = 2
                  end
                  object ButtonDeleteAllConnectors: TButton
                    Left = 253
                    Height = 30
                    Hint = 'Delete all SQL connectors for external databases.'
                    Top = 5
                    Width = 145
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Delete All Connectors'
                    OnClick = ButtonDeleteAllConnectorsClick
                    TabOrder = 3
                  end
                  object ButtonSelectAllConnectors: TButton
                    Left = 402
                    Height = 30
                    Hint = 'Mark all external databases for import.'
                    Top = 5
                    Width = 142
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Select All Connectors'
                    OnClick = ButtonSelectAllConnectorsClick
                    TabOrder = 4
                  end
                  object ButtonUnselectAllConnectors: TButton
                    Left = 548
                    Height = 30
                    Hint = 'Unmark all external databases for import.'
                    Top = 5
                    Width = 158
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Unselect All Connectors'
                    OnClick = ButtonUnselectAllConnectorsClick
                    TabOrder = 5
                  end
                end
                object Panel69: TPanel
                  Left = 0
                  Height = 90
                  Top = 60
                  Width = 1779
                  Align = alClient
                  Caption = 'Panel69'
                  ClientHeight = 86
                  ClientWidth = 1775
                  TabOrder = 1
                  object DBGridSQLConnectors: TRxDBGrid
                    Left = 1
                    Height = 88
                    Top = 1
                    Width = 1777
                    ColumnDefValues.BlobText = '(blob)'
                    TitleButtons = True
                    AutoSort = True
                    Columns = <                    
                      item
                        Title.Alignment = taCenter
                        Title.Orientation = toHorizontal
                        Title.Caption = 'PROJECT_ID'
                        Width = 91
                        FieldName = 'PROJECT_ID'
                        EditButtons = <>
                        Filter.DropDownRows = 0
                        Filter.EmptyValue = '(Empty)'
                        Filter.NotEmptyValue = '(Not empty)'
                        Filter.AllValue = '(All values)'
                        Filter.EmptyFont.Style = [fsItalic]
                        Filter.ItemIndex = -1
                        Footers = <>
                      end                    
                      item
                        Title.Alignment = taCenter
                        Title.Orientation = toHorizontal
                        Title.Caption = 'SQLCONNECTOR_ID'
                        Width = 136
                        FieldName = 'SQLCONNECTOR_ID'
                        EditButtons = <>
                        Filter.DropDownRows = 0
                        Filter.EmptyValue = '(Empty)'
                        Filter.NotEmptyValue = '(Not empty)'
                        Filter.AllValue = '(All values)'
                        Filter.EmptyFont.Style = [fsItalic]
                        Filter.ItemIndex = -1
                        Footers = <>
                      end                    
                      item
                        Title.Alignment = taCenter
                        Title.Orientation = toHorizontal
                        Title.Caption = 'SqlConnectorName'
                        Width = 200
                        FieldName = 'SQLCONNECTORNAME'
                        EditButtons = <>
                        Filter.DropDownRows = 0
                        Filter.EmptyValue = '(Empty)'
                        Filter.NotEmptyValue = '(Not empty)'
                        Filter.AllValue = '(All values)'
                        Filter.EmptyFont.Style = [fsItalic]
                        Filter.ItemIndex = -1
                        Footers = <>
                      end                    
                      item
                        Title.Alignment = taCenter
                        Title.Orientation = toHorizontal
                        Title.Caption = 'ToBeImported'
                        Width = 102
                        FieldName = 'TOBEIMPORTED'
                        EditButtons = <>
                        Filter.DropDownRows = 0
                        Filter.EmptyValue = '(Empty)'
                        Filter.NotEmptyValue = '(Not empty)'
                        Filter.AllValue = '(All values)'
                        Filter.EmptyFont.Style = [fsItalic]
                        Filter.ItemIndex = -1
                        Footers = <>
                      end                    
                      item
                        ButtonStyle = cbsPickList
                        PickList.Strings = (
                          'ado '
                          'ASA7 '
                          'ASA8 '
                          'ASA9 '
                          'firebird-1.0 '
                          'firebird-1.5 '
                          'firebird-2.0 '
                          'firebirdd-1.5 '
                          'firebirdd-2.0 '
                          'interbase-5 '
                          'interbase-6 '
                          'mssql '
                          'mysql '
                          'mysql-4.1 '
                          'mysql-5 '
                          'mysqld-4.1 '
                          'mysqld-5 '
                          'oracle '
                          'oracle-9i '
                          'postgresql '
                          'postgresql-7 '
                          'postgresql-8 '
                          'sqlite '
                          'sqlite-2.8 '
                          'sqlite-3 '
                          'sybase'
                        )
                        Title.Alignment = taCenter
                        Title.Orientation = toHorizontal
                        Title.Caption = 'Protocol'
                        Width = 200
                        FieldName = 'PROTOCOL'
                        EditButtons = <>
                        Filter.DropDownRows = 0
                        Filter.EmptyValue = '(Empty)'
                        Filter.NotEmptyValue = '(Not empty)'
                        Filter.AllValue = '(All values)'
                        Filter.EmptyFont.Style = [fsItalic]
                        Filter.ItemIndex = -1
                        Footers = <>
                      end                    
                      item
                        Title.Alignment = taCenter
                        Title.Orientation = toHorizontal
                        Title.Caption = 'Catalog'
                        Width = 100
                        FieldName = 'CATALOG'
                        EditButtons = <>
                        Filter.DropDownRows = 0
                        Filter.EmptyValue = '(Empty)'
                        Filter.NotEmptyValue = '(Not empty)'
                        Filter.AllValue = '(All values)'
                        Filter.EmptyFont.Style = [fsItalic]
                        Filter.ItemIndex = -1
                        Footers = <>
                      end                    
                      item
                        Title.Alignment = taCenter
                        Title.Orientation = toHorizontal
                        Title.Caption = 'Database'
                        Width = 200
                        FieldName = 'DATABASE'
                        EditButtons = <>
                        Filter.DropDownRows = 0
                        Filter.EmptyValue = '(Empty)'
                        Filter.NotEmptyValue = '(Not empty)'
                        Filter.AllValue = '(All values)'
                        Filter.EmptyFont.Style = [fsItalic]
                        Filter.ItemIndex = -1
                        Footers = <>
                      end                    
                      item
                        Title.Alignment = taCenter
                        Title.Orientation = toHorizontal
                        Title.Caption = 'HostName'
                        Width = 200
                        FieldName = 'HOSTNAME'
                        EditButtons = <>
                        Filter.DropDownRows = 0
                        Filter.EmptyValue = '(Empty)'
                        Filter.NotEmptyValue = '(Not empty)'
                        Filter.AllValue = '(All values)'
                        Filter.EmptyFont.Style = [fsItalic]
                        Filter.ItemIndex = -1
                        Footers = <>
                      end                    
                      item
                        Title.Alignment = taCenter
                        Title.Orientation = toHorizontal
                        Title.Caption = 'Port'
                        Width = 60
                        FieldName = 'PORT'
                        EditButtons = <>
                        Filter.DropDownRows = 0
                        Filter.EmptyValue = '(Empty)'
                        Filter.NotEmptyValue = '(Not empty)'
                        Filter.AllValue = '(All values)'
                        Filter.EmptyFont.Style = [fsItalic]
                        Filter.ItemIndex = -1
                        Footers = <>
                      end                    
                      item
                        Title.Alignment = taCenter
                        Title.Orientation = toHorizontal
                        Title.Caption = 'User'
                        Width = 200
                        FieldName = 'USER'
                        EditButtons = <>
                        Filter.DropDownRows = 0
                        Filter.EmptyValue = '(Empty)'
                        Filter.NotEmptyValue = '(Not empty)'
                        Filter.AllValue = '(All values)'
                        Filter.EmptyFont.Style = [fsItalic]
                        Filter.ItemIndex = -1
                        Footers = <>
                      end                    
                      item
                        Title.Alignment = taCenter
                        Title.Orientation = toHorizontal
                        Title.Caption = 'Password'
                        Width = 250
                        FieldName = 'PASSWORD'
                        EditButtons = <>
                        Filter.DropDownRows = 0
                        Filter.EmptyValue = '(Empty)'
                        Filter.NotEmptyValue = '(Not empty)'
                        Filter.AllValue = '(All values)'
                        Filter.EmptyFont.Style = [fsItalic]
                        Filter.ItemIndex = -1
                        Footers = <>
                      end>
                    KeyStrokes = <                    
                      item
                        Command = rxgcShowFindDlg
                        ShortCut = 16454
                        Enabled = True
                      end                    
                      item
                        Command = rxgcShowColumnsDlg
                        ShortCut = 16471
                        Enabled = True
                      end                    
                      item
                        Command = rxgcShowFilterDlg
                        ShortCut = 16468
                        Enabled = True
                      end                    
                      item
                        Command = rxgcShowSortDlg
                        ShortCut = 16467
                        Enabled = True
                      end                    
                      item
                        Command = rxgcShowQuickFilter
                        ShortCut = 16465
                        Enabled = True
                      end                    
                      item
                        Command = rxgcHideQuickFilter
                        ShortCut = 16456
                        Enabled = True
                      end                    
                      item
                        Command = rxgcSelectAll
                        ShortCut = 16449
                        Enabled = True
                      end                    
                      item
                        Command = rxgcDeSelectAll
                        ShortCut = 16429
                        Enabled = True
                      end                    
                      item
                        Command = rxgcInvertSelection
                        ShortCut = 16426
                        Enabled = True
                      end                    
                      item
                        Command = rxgcOptimizeColumnsWidth
                        ShortCut = 16427
                        Enabled = True
                      end                    
                      item
                        Command = rxgcCopyCellValue
                        ShortCut = 16451
                        Enabled = True
                      end>
                    FooterOptions.RowCount = 1
                    FooterOptions.DrawFullLine = False
                    SearchOptions.QuickSearchOptions = [loCaseInsensitive, loPartialKey]
                    SearchOptions.FromStart = False
                    OptionsRx = [rdgAllowColumnsForm, rdgAllowDialogFind, rdgDblClickOptimizeColWidth, rdgAllowQuickSearch, rdgAllowQuickFilter, rdgAllowFilterForm, rdgAllowSortForm, rdgAllowToolMenu, rdgCaseInsensitiveSort]
                    FooterRowCount = 1
                    Align = alClient
                    Color = clWindow
                    DrawFullLine = False
                    FocusColor = clRed
                    SelectedColor = clHighlight
                    DataSource = DataModule1.DatasourceSQLConnectors
                    DoubleBuffered = True
                    Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgHeaderHotTracking, dgHeaderPushedLook, dgDblClickAutoSize, dgDisplayMemoText]
                    ParentDoubleBuffered = False
                    TabOrder = 0
                  end
                end
                object Panel72: TPanel
                  Left = 0
                  Height = 20
                  Top = 0
                  Width = 1779
                  Align = alTop
                  ClientHeight = 16
                  ClientWidth = 1775
                  TabOrder = 2
                  object Label8: TLabel
                    Left = 1
                    Height = 18
                    Top = 1
                    Width = 1777
                    Align = alClient
                    Alignment = taCenter
                    Caption = 'SQL Connectors'
                    ParentColor = False
                  end
                end
              end
              object PairSplitterSide34: TPairSplitterSide
                Cursor = crArrow
                Left = 0
                Height = 243
                Top = 155
                Width = 1779
                ClientWidth = 1779
                ClientHeight = 243
                object Panel70: TPanel
                  Left = 0
                  Height = 40
                  Top = 20
                  Width = 1779
                  Align = alTop
                  ClientHeight = 36
                  ClientWidth = 1775
                  TabOrder = 0
                  object DBNavigatorSQLTables: TDBNavigator
                    Left = 664
                    Height = 30
                    Top = 5
                    Width = 1110
                    Align = alClient
                    BevelOuter = bvNone
                    BorderSpacing.Around = 4
                    ChildSizing.EnlargeHorizontal = crsScaleChilds
                    ChildSizing.EnlargeVertical = crsScaleChilds
                    ChildSizing.ShrinkHorizontal = crsScaleChilds
                    ChildSizing.ShrinkVertical = crsScaleChilds
                    ChildSizing.Layout = cclLeftToRightThenTopToBottom
                    ChildSizing.ControlsPerLine = 100
                    ClientHeight = 26
                    ClientWidth = 1106
                    DataSource = DataModule1.DatasourceSQLTables
                    Options = []
                    TabOrder = 0
                  end
                  object ButtonSQLTablesSchema: TButton
                    Left = 5
                    Height = 30
                    Hint = 'Register tables available in the external database.'
                    Top = 5
                    Width = 126
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Get Tables Schema'
                    OnClick = ButtonSQLTablesSchemaClick
                    TabOrder = 1
                  end
                  object ButtonDeleteAllExternalTables: TButton
                    Left = 135
                    Height = 30
                    Hint = 'Delete all registered tables of the external database.'#10'Note that it is just deletion of tables information, not deleting actual tables in the external database.'
                    Top = 5
                    Width = 169
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Delete All External Tables'
                    OnClick = ButtonDeleteAllExternalTablesClick
                    TabOrder = 2
                  end
                  object ButtonSelectAllExternalTables: TButton
                    Left = 308
                    Height = 30
                    Hint = 'Mark all tables from the external database, for import.'
                    Top = 5
                    Width = 166
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Select All External Tables'
                    OnClick = ButtonSelectAllExternalTablesClick
                    TabOrder = 3
                  end
                  object ButtonUnselectAllExternalTables: TButton
                    Left = 478
                    Height = 30
                    Hint = 'Unmark all tables from the external database, for import.'
                    Top = 5
                    Width = 182
                    Align = alLeft
                    AutoSize = True
                    BorderSpacing.Around = 4
                    Caption = 'Unselect All External Tables'
                    OnClick = ButtonUnselectAllExternalTablesClick
                    TabOrder = 4
                  end
                end
                object Panel71: TPanel
                  Left = 0
                  Height = 183
                  Top = 60
                  Width = 1779
                  Align = alClient
                  Caption = 'Panel69'
                  ClientHeight = 179
                  ClientWidth = 1775
                  TabOrder = 1
                  object PairSplitter18: TPairSplitter
                    Left = 1
                    Height = 181
                    Top = 1
                    Width = 1777
                    Align = alClient
                    Position = 1200
                    object PairSplitterSide35: TPairSplitterSide
                      Cursor = crArrow
                      Left = 0
                      Height = 181
                      Top = 0
                      Width = 1200
                      ClientWidth = 1200
                      ClientHeight = 181
                      object DBGridSQLTables: TRxDBGrid
                        Left = 0
                        Height = 181
                        Top = 0
                        Width = 1200
                        ColumnDefValues.BlobText = '(blob)'
                        TitleButtons = True
                        AutoSort = True
                        Columns = <                        
                          item
                            Title.Alignment = taCenter
                            Title.Orientation = toHorizontal
                            Title.Caption = 'SQLCONNECTOR_ID'
                            Width = 136
                            FieldName = 'SQLCONNECTOR_ID'
                            EditButtons = <>
                            Filter.DropDownRows = 0
                            Filter.EmptyValue = '(Empty)'
                            Filter.NotEmptyValue = '(Not empty)'
                            Filter.AllValue = '(All values)'
                            Filter.EmptyFont.Style = [fsItalic]
                            Filter.ItemIndex = -1
                            Footers = <>
                          end                        
                          item
                            Title.Alignment = taCenter
                            Title.Orientation = toHorizontal
                            Title.Caption = 'SQLTABLE_ID'
                            Width = 97
                            FieldName = 'SQLTABLE_ID'
                            EditButtons = <>
                            Filter.DropDownRows = 0
                            Filter.EmptyValue = '(Empty)'
                            Filter.NotEmptyValue = '(Not empty)'
                            Filter.AllValue = '(All values)'
                            Filter.EmptyFont.Style = [fsItalic]
                            Filter.ItemIndex = -1
                            Footers = <>
                          end                        
                          item
                            Title.Alignment = taCenter
                            Title.Orientation = toHorizontal
                            Title.Caption = 'TableName'
                            Width = 300
                            FieldName = 'SQLTABLENAME'
                            EditButtons = <>
                            Filter.DropDownRows = 0
                            Filter.EmptyValue = '(Empty)'
                            Filter.NotEmptyValue = '(Not empty)'
                            Filter.AllValue = '(All values)'
                            Filter.EmptyFont.Style = [fsItalic]
                            Filter.ItemIndex = -1
                            Footers = <>
                          end                        
                          item
                            Title.Alignment = taCenter
                            Title.Orientation = toHorizontal
                            Title.Caption = 'ToBeImported'
                            Width = 102
                            FieldName = 'TOBEIMPORTED'
                            EditButtons = <>
                            Filter.DropDownRows = 0
                            Filter.EmptyValue = '(Empty)'
                            Filter.NotEmptyValue = '(Not empty)'
                            Filter.AllValue = '(All values)'
                            Filter.EmptyFont.Style = [fsItalic]
                            Filter.ItemIndex = -1
                            Footers = <>
                          end                        
                          item
                            Title.Alignment = taCenter
                            Title.Orientation = toHorizontal
                            Title.Caption = 'ImportedName'
                            Width = 300
                            FieldName = 'IMPORTEDNAME'
                            EditButtons = <>
                            Filter.DropDownRows = 0
                            Filter.EmptyValue = '(Empty)'
                            Filter.NotEmptyValue = '(Not empty)'
                            Filter.AllValue = '(All values)'
                            Filter.EmptyFont.Style = [fsItalic]
                            Filter.ItemIndex = -1
                            Footers = <>
                          end                        
                          item
                            Title.Alignment = taCenter
                            Title.Orientation = toHorizontal
                            Title.Caption = 'Comment'
                            Width = 300
                            FieldName = 'SQLTABLENAMECOMMENT'
                            EditButtons = <>
                            Filter.DropDownRows = 0
                            Filter.EmptyValue = '(Empty)'
                            Filter.NotEmptyValue = '(Not empty)'
                            Filter.AllValue = '(All values)'
                            Filter.EmptyFont.Style = [fsItalic]
                            Filter.ItemIndex = -1
                            Footers = <>
                          end>
                        KeyStrokes = <                        
                          item
                            Command = rxgcShowFindDlg
                            ShortCut = 16454
                            Enabled = True
                          end                        
                          item
                            Command = rxgcShowColumnsDlg
                            ShortCut = 16471
                            Enabled = True
                          end                        
                          item
                            Command = rxgcShowFilterDlg
                            ShortCut = 16468
                            Enabled = True
                          end                        
                          item
                            Command = rxgcShowSortDlg
                            ShortCut = 16467
                            Enabled = True
                          end                        
                          item
                            Command = rxgcShowQuickFilter
                            ShortCut = 16465
                            Enabled = True
                          end                        
                          item
                            Command = rxgcHideQuickFilter
                            ShortCut = 16456
                            Enabled = True
                          end                        
                          item
                            Command = rxgcSelectAll
                            ShortCut = 16449
                            Enabled = True
                          end                        
                          item
                            Command = rxgcDeSelectAll
                            ShortCut = 16429
                            Enabled = True
                          end                        
                          item
                            Command = rxgcInvertSelection
                            ShortCut = 16426
                            Enabled = True
                          end                        
                          item
                            Command = rxgcOptimizeColumnsWidth
                            ShortCut = 16427
                            Enabled = True
                          end                        
                          item
                            Command = rxgcCopyCellValue
                            ShortCut = 16451
                            Enabled = True
                          end>
                        FooterOptions.RowCount = 1
                        FooterOptions.DrawFullLine = False
                        SearchOptions.QuickSearchOptions = [loCaseInsensitive, loPartialKey]
                        SearchOptions.FromStart = False
                        OptionsRx = [rdgAllowColumnsForm, rdgAllowDialogFind, rdgDblClickOptimizeColWidth, rdgAllowQuickSearch, rdgAllowQuickFilter, rdgAllowFilterForm, rdgAllowSortForm, rdgAllowToolMenu, rdgCaseInsensitiveSort]
                        FooterRowCount = 1
                        Align = alClient
                        Color = clWindow
                        DrawFullLine = False
                        FocusColor = clRed
                        SelectedColor = clHighlight
                        DataSource = DataModule1.DatasourceSQLTables
                        DoubleBuffered = True
                        Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgHeaderHotTracking, dgHeaderPushedLook, dgDblClickAutoSize, dgDisplayMemoText]
                        ParentDoubleBuffered = False
                        TabOrder = 0
                      end
                      object ListBoxSQLTables: TListBox
                        Left = 318
                        Height = 101
                        Top = 54
                        Width = 100
                        ItemHeight = 0
                        ScrollWidth = 96
                        TabOrder = 1
                        TopIndex = -1
                        Visible = False
                      end
                    end
                    object PairSplitterSide36: TPairSplitterSide
                      Cursor = crArrow
                      Left = 1205
                      Height = 181
                      Top = 0
                      Width = 572
                      ClientWidth = 572
                      ClientHeight = 181
                      object ListBoxSQLTableFields: TListBox
                        Left = 0
                        Height = 141
                        Top = 40
                        Width = 572
                        Align = alClient
                        ItemHeight = 0
                        ScrollWidth = 292
                        TabOrder = 0
                        TopIndex = -1
                      end
                      object Panel75: TPanel
                        Left = 0
                        Height = 40
                        Top = 0
                        Width = 572
                        Align = alTop
                        ClientHeight = 36
                        ClientWidth = 568
                        TabOrder = 1
                        object ButtonGetSQLTableFieldsSchema: TButton
                          Left = 5
                          Height = 30
                          Top = 5
                          Width = 562
                          Align = alClient
                          AutoSize = True
                          BorderSpacing.Around = 4
                          Caption = 'Get Fields Schema'
                          OnClick = ButtonGetSQLTableFieldsSchemaClick
                          TabOrder = 0
                        end
                      end
                    end
                  end
                end
                object Panel73: TPanel
                  Left = 0
                  Height = 20
                  Top = 0
                  Width = 1779
                  Align = alTop
                  ClientHeight = 16
                  ClientWidth = 1775
                  TabOrder = 2
                  object Label9: TLabel
                    Left = 1
                    Height = 18
                    Top = 1
                    Width = 1777
                    Align = alClient
                    Alignment = taCenter
                    Caption = 'SQL Tables'
                    ParentColor = False
                  end
                end
              end
            end
          end
        end
        object PairSplitterSide32: TPairSplitterSide
          Cursor = crArrow
          Left = 0
          Height = 438
          Top = 405
          Width = 1781
          ClientWidth = 1781
          ClientHeight = 438
          object Panel65: TPanel
            Left = 0
            Height = 40
            Top = 20
            Width = 1781
            Align = alTop
            ClientHeight = 36
            ClientWidth = 1777
            TabOrder = 0
            object DBNavigatorSQLTable: TDBNavigator
              Left = 305
              Height = 38
              Top = 1
              Width = 1475
              Align = alClient
              BevelOuter = bvNone
              ChildSizing.EnlargeHorizontal = crsScaleChilds
              ChildSizing.EnlargeVertical = crsScaleChilds
              ChildSizing.ShrinkHorizontal = crsScaleChilds
              ChildSizing.ShrinkVertical = crsScaleChilds
              ChildSizing.Layout = cclLeftToRightThenTopToBottom
              ChildSizing.ControlsPerLine = 100
              ClientHeight = 34
              ClientWidth = 1471
              DataSource = DataModule1.DatasourceSQLTableData
              Options = []
              TabOrder = 0
            end
            object ButtonActivateSQLTablePreview: TButton
              Left = 1
              Height = 38
              Hint = 'Load external database table data.'
              Top = 1
              Width = 75
              Align = alLeft
              AutoSize = True
              Caption = 'Load Data'
              OnClick = ButtonActivateSQLTablePreviewClick
              TabOrder = 1
            end
            object ButtonDeactivateSQLTablePreview: TButton
              Left = 76
              Height = 38
              Hint = 'Unload external database table data.'
              Top = 1
              Width = 89
              Align = alLeft
              AutoSize = True
              Caption = 'Unload Data'
              OnClick = ButtonDeactivateSQLTablePreviewClick
              TabOrder = 2
            end
            object ButtonFilterSQLTableData: TButton
              Left = 205
              Height = 38
              Hint = 'Filter data according to some criteria'
              Top = 1
              Width = 45
              Align = alLeft
              AutoSize = True
              Caption = 'Filter'
              OnClick = ButtonFilterSQLTableDataClick
              TabOrder = 3
            end
            object ButtonFindSQLTableData: TButton
              Left = 165
              Height = 38
              Hint = 'Search for a rows satidfying some criteria'
              Top = 1
              Width = 40
              Align = alLeft
              AutoSize = True
              Caption = 'Find'
              OnClick = ButtonFindSQLTableDataClick
              TabOrder = 4
            end
            object ButtonExportSQLTableData: TButton
              Left = 250
              Height = 38
              Hint = 'Export dataset into a new file'
              Top = 1
              Width = 55
              Align = alLeft
              AutoSize = True
              Caption = 'Export'
              OnClick = ButtonExportSQLTableDataClick
              TabOrder = 5
            end
          end
          object Panel66: TPanel
            Left = 0
            Height = 378
            Top = 60
            Width = 1781
            Align = alClient
            ClientHeight = 374
            ClientWidth = 1777
            TabOrder = 1
            object DBGridSQLTableData: TRxDBGrid
              Left = 1
              Height = 376
              Top = 1
              Width = 1779
              ColumnDefValues.BlobText = '(blob)'
              TitleButtons = True
              AutoSort = True
              KeyStrokes = <              
                item
                  Command = rxgcShowFindDlg
                  ShortCut = 16454
                  Enabled = True
                end              
                item
                  Command = rxgcShowColumnsDlg
                  ShortCut = 16471
                  Enabled = True
                end              
                item
                  Command = rxgcShowFilterDlg
                  ShortCut = 16468
                  Enabled = True
                end              
                item
                  Command = rxgcShowSortDlg
                  ShortCut = 16467
                  Enabled = True
                end              
                item
                  Command = rxgcShowQuickFilter
                  ShortCut = 16465
                  Enabled = True
                end              
                item
                  Command = rxgcHideQuickFilter
                  ShortCut = 16456
                  Enabled = True
                end              
                item
                  Command = rxgcSelectAll
                  ShortCut = 16449
                  Enabled = True
                end              
                item
                  Command = rxgcDeSelectAll
                  ShortCut = 16429
                  Enabled = True
                end              
                item
                  Command = rxgcInvertSelection
                  ShortCut = 16426
                  Enabled = True
                end              
                item
                  Command = rxgcOptimizeColumnsWidth
                  ShortCut = 16427
                  Enabled = True
                end              
                item
                  Command = rxgcCopyCellValue
                  ShortCut = 16451
                  Enabled = True
                end>
              FooterOptions.RowCount = 1
              FooterOptions.DrawFullLine = False
              SearchOptions.QuickSearchOptions = [loCaseInsensitive, loPartialKey]
              SearchOptions.FromStart = False
              OptionsRx = [rdgAllowColumnsForm, rdgAllowDialogFind, rdgDblClickOptimizeColWidth, rdgAllowQuickSearch, rdgAllowQuickFilter, rdgAllowFilterForm, rdgAllowSortForm, rdgAllowToolMenu, rdgCaseInsensitiveSort]
              FooterRowCount = 1
              Align = alClient
              Color = clWindow
              DrawFullLine = False
              FocusColor = clRed
              SelectedColor = clHighlight
              DataSource = DataModule1.DatasourceSQLTableData
              DoubleBuffered = True
              Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgHeaderHotTracking, dgHeaderPushedLook, dgDblClickAutoSize, dgDisplayMemoText]
              ParentDoubleBuffered = False
              TabOrder = 0
            end
          end
          object Panel74: TPanel
            Left = 0
            Height = 20
            Top = 0
            Width = 1781
            Align = alTop
            ClientHeight = 16
            ClientWidth = 1777
            TabOrder = 2
            object Label10: TLabel
              Left = 1
              Height = 18
              Top = 1
              Width = 1779
              Align = alClient
              Alignment = taCenter
              Caption = 'Data Preview'
              ParentColor = False
            end
          end
        end
      end
    end
    object TabSheetSpreadsheets: TTabSheet
      Caption = 'Spreadsheets'
      ClientHeight = 869
      ClientWidth = 1781
      object Panel57: TPanel
        Left = 0
        Height = 830
        Top = 0
        Width = 2133
        Align = alClient
        ClientHeight = 826
        ClientWidth = 2129
        TabOrder = 0
        object PairSplitter2: TPairSplitter
          Cursor = crVSplit
          Left = 1
          Height = 828
          Top = 1
          Width = 2131
          Align = alClient
          Position = 400
          SplitterType = pstVertical
          object PairSplitterSide3: TPairSplitterSide
            Cursor = crArrow
            Left = 0
            Height = 400
            Top = 0
            Width = 2131
            ClientWidth = 2131
            ClientHeight = 400
            object Panel44: TPanel
              Left = 0
              Height = 400
              Top = 0
              Width = 2131
              Align = alClient
              ClientHeight = 396
              ClientWidth = 2127
              TabOrder = 0
              object Panel55: TPanel
                Left = 1
                Height = 28
                Top = 1
                Width = 2129
                Align = alTop
                AutoSize = True
                ClientHeight = 24
                ClientWidth = 2125
                TabOrder = 0
                object Label20: TLabel
                  Left = 6
                  Height = 16
                  Top = 6
                  Width = 2117
                  Align = alClient
                  Alignment = taCenter
                  BorderSpacing.Around = 5
                  Caption = 'Working with Spreadsheets'
                  ParentColor = False
                end
              end
              object PairSplitter4: TPairSplitter
                Left = 1
                Height = 370
                Top = 29
                Width = 2129
                Align = alClient
                Position = 1000
                object PairSplitterSide7: TPairSplitterSide
                  Cursor = crArrow
                  Left = 0
                  Height = 370
                  Top = 0
                  Width = 1000
                  ClientWidth = 1000
                  ClientHeight = 370
                  object Panel35: TPanel
                    Left = 0
                    Height = 370
                    Top = 0
                    Width = 1000
                    Align = alClient
                    ClientHeight = 366
                    ClientWidth = 996
                    TabOrder = 0
                    object ListBoxSpreadsheets: TListBox
                      Left = 6
                      Height = 282
                      Top = 82
                      Width = 988
                      Align = alClient
                      BorderSpacing.Around = 5
                      Columns = 2
                      ItemHeight = 0
                      ScrollWidth = 999
                      TabOrder = 0
                      TopIndex = -1
                    end
                    object Label5: TLabel
                      Left = 6
                      Height = 16
                      Top = 6
                      Width = 988
                      Align = alTop
                      Alignment = taCenter
                      BorderSpacing.Around = 5
                      Caption = 'Spreadsheet files in the project folder'
                      ParentColor = False
                    end
                    object Panel33: TPanel
                      Left = 1
                      Height = 50
                      Top = 27
                      Width = 998
                      Align = alTop
                      ClientHeight = 46
                      ClientWidth = 994
                      TabOrder = 1
                      object ButtonPopulateSpreadsheetsList: TButton
                        Left = 5
                        Height = 40
                        Hint = 'Populate list of spreadsheets present in the current project folder.'#10'Note that only spreadsheet files will be listed here.'
                        Top = 5
                        Width = 90
                        Align = alLeft
                        AutoSize = True
                        BorderSpacing.Around = 4
                        Caption = 'Populate list'
                        OnClick = ButtonPopulateSpreadsheetsListClick
                        TabOrder = 0
                      end
                      object ButtonOpenSpreadsheet: TButton
                        Left = 99
                        Height = 40
                        Hint = 'Open currently selected spreadsheet.'
                        Top = 5
                        Width = 124
                        Align = alLeft
                        AutoSize = True
                        BorderSpacing.Around = 4
                        Caption = 'Open spreadsheet'
                        OnClick = ButtonOpenSpreadsheetClick
                        TabOrder = 1
                      end
                      object ButtonSpreadsheetToCSV: TButton
                        Left = 543
                        Height = 40
                        Hint = 'Export sheets of the current spreadsheet into corresponding CSV files.'
                        Top = 5
                        Width = 176
                        Align = alLeft
                        AutoSize = True
                        BorderSpacing.Around = 4
                        Caption = 'Export Spreadsheet to CSV'
                        OnClick = ButtonSpreadsheetToCSVClick
                        TabOrder = 2
                      end
                      object ButtonCloseSpreadsheet: TButton
                        Left = 227
                        Height = 40
                        Hint = 'Open currently selected spreadsheet.'
                        Top = 5
                        Width = 124
                        Align = alLeft
                        AutoSize = True
                        BorderSpacing.Around = 4
                        Caption = 'Close spreadsheet'
                        OnClick = ButtonCloseSpreadsheetClick
                        TabOrder = 3
                      end
                      object ButtonAllSpreadsheetsToCSVFiles: TButton
                        Left = 723
                        Height = 40
                        Hint = 'Export all spreadsheets into CSV files.'
                        Top = 5
                        Width = 202
                        Align = alLeft
                        AutoSize = True
                        BorderSpacing.Around = 4
                        Caption = 'Export All Spreadsheets to CSV'
                        OnClick = ButtonAllSpreadsheetsToCSVFilesClick
                        TabOrder = 4
                      end
                      object ButtonCurrentSheetToCSV: TButton
                        Left = 355
                        Height = 40
                        Hint = 'Export current sheet to CSV file.'
                        Top = 5
                        Width = 184
                        Align = alLeft
                        AutoSize = True
                        BorderSpacing.Around = 4
                        Caption = 'Export Current Sheet to CSV'
                        OnClick = ButtonCurrentSheetToCSVClick
                        TabOrder = 5
                      end
                    end
                  end
                end
                object PairSplitterSide8: TPairSplitterSide
                  Cursor = crArrow
                  Left = 1005
                  Height = 370
                  Top = 0
                  Width = 1124
                  ClientWidth = 1124
                  ClientHeight = 370
                  object Panel59: TPanel
                    Left = 0
                    Height = 370
                    Top = 0
                    Width = 1124
                    Align = alClient
                    AutoSize = True
                    ClientHeight = 366
                    ClientWidth = 1120
                    TabOrder = 0
                    object sSpreadsheetInspector1: TsSpreadsheetInspector
                      Left = 6
                      Height = 182
                      Top = 107
                      Width = 1112
                      Align = alClient
                      BorderSpacing.Around = 5
                      RowCount = 39
                      TabOrder = 0
                      Strings.Strings = (
                        'FileName='
                        'FileFormat=(unknown)'
                        'ActiveWorksheet=Sheet1'
                        'Options=boAutoCalc, boReadFormulas'
                        '(-) FormatSettings='
                        '  ThousandSeparator=.'
                        '  DecimalSeparator=.'
                        '  ListSeparator=,'
                        '  DateSeparator=.'
                        '  TimeSeparator=:'
                        '  ShortDateFormat=dd.mm.yyyy'
                        '  LongDateFormat=dd.mm.yyyy'
                        '  ShortTimeFormat=hh:nn:ss'
                        '  LongTimeFormat=hh:nn:ss'
                        '  TimeAMString='
                        '  TimePMString='
                        '  ShortMonthNames=sij, velj, ožu, tra, svi, lip, srp, kol, ruj, lis, stu, pro'
                        '  LongMontNames=siječnja, veljače, ožujka, travnja, svibnja, lipnja, srpnja, kolovoza, rujna, listopada, studenoga, prosinca'
                        '  ShortMonthNames=ned, pon, uto, sri, čet, pet, sub'
                        '  LongMontNames=nedjelja, ponedjeljak, utorak, srijeda, četvrtak, petak, subota'
                        '  CurrencyString=kn'
                        '  PosCurrencyFormat=3'
                        '  NegCurrencyFormat=8'
                        '  TwoDigitYearCenturyWindow=50'
                        '(-) Images='
                        '(-) Fonts='
                        '  Font0=Arial; size 10; black'
                        '  Font1=Arial; size 10; blue; underline'
                        '  Font2=Arial; size 10; black; bold'
                        '  Font3=Arial; size 10; black; italic'
                        '(-) Cell formats='
                        '  CellFormat0=nfGeneral'
                        'Protection=(default)'
                        '(-) CryptoInfo='
                        '  PasswordHash='
                        '  Algorithm='
                        '  SaltValue='
                        '  SpinCount=0'
                      )
                      TitleCaptions.Strings = (
                        'Properties'
                        'Values'
                      )
                      WorkbookSource = sWorkbookSource1
                      Mode = imWorkbook
                      ExtendedColSizing = False
                      ColWidths = (
                        554
                        554
                      )
                    end
                    object Panel60: TPanel
                      Left = 6
                      Height = 70
                      Top = 294
                      Width = 1112
                      Align = alBottom
                      BorderSpacing.Around = 5
                      ClientHeight = 66
                      ClientWidth = 1108
                      TabOrder = 1
                      object sWorkbookTabControl1: TsWorkbookTabControl
                        Left = 6
                        Height = 37
                        Top = 27
                        Width = 1100
                        TabIndex = 0
                        Tabs.Strings = (
                          'Sheet1'
                        )
                        BorderSpacing.Around = 5
                        Options = [nboShowCloseButtons, nboKeyboardTabSwitch, nboShowAddTabButton]
                        TabOrder = 0
                        WorkbookSource = sWorkbookSource1
                      end
                      object Label22: TLabel
                        Left = 6
                        Height = 16
                        Top = 6
                        Width = 1100
                        Align = alTop
                        Alignment = taCenter
                        BorderSpacing.Around = 5
                        Caption = 'Sheets'
                        ParentColor = False
                      end
                    end
                    object Label7: TLabel
                      Left = 6
                      Height = 16
                      Top = 86
                      Width = 1112
                      Align = alTop
                      Alignment = taCenter
                      BorderSpacing.Around = 5
                      Caption = 'Spreadsheet Properties'
                      ParentColor = False
                    end
                    object Panel61: TPanel
                      Left = 1
                      Height = 80
                      Top = 1
                      Width = 1122
                      Align = alTop
                      ClientHeight = 76
                      ClientWidth = 1118
                      TabOrder = 2
                      object edZoom: TSpinEdit
                        AnchorSideLeft.Control = CbOverrideZoomFactor
                        AnchorSideLeft.Side = asrBottom
                        AnchorSideTop.Control = BtnOpen
                        AnchorSideTop.Side = asrCenter
                        Left = 307
                        Height = 28
                        Top = 14
                        Width = 66
                        Alignment = taRightJustify
                        BorderSpacing.Left = 24
                        MaxValue = 900
                        MinValue = 10
                        OnEditingDone = edZoomEditingDone
                        TabOrder = 1
                        Value = 100
                      end
                      object CbOverrideZoomFactor: TCheckBox
                        AnchorSideLeft.Control = BtnOpen
                        AnchorSideLeft.Side = asrBottom
                        AnchorSideTop.Control = BtnOpen
                        AnchorSideTop.Side = asrCenter
                        Left = 107
                        Height = 23
                        Top = 17
                        Width = 176
                        BorderSpacing.Left = 24
                        Caption = 'Override file zoom factor'
                        TabOrder = 2
                      end
                      object BtnSave: TButton
                        AnchorSideLeft.Control = BtnOpen
                        AnchorSideTop.Control = BtnOpen
                        AnchorSideTop.Side = asrBottom
                        Left = 8
                        Height = 25
                        Hint = 'Save the spreadsheet or csv file.'#10'Note that you can save the file under new name and different format.'
                        Top = 49
                        Width = 75
                        BorderSpacing.Top = 8
                        Caption = 'Save...'
                        OnClick = BtnSaveClick
                        TabOrder = 3
                      end
                      object CbWriteZoomFactor: TCheckBox
                        AnchorSideLeft.Control = CbOverrideZoomFactor
                        AnchorSideTop.Control = BtnSave
                        AnchorSideTop.Side = asrCenter
                        Left = 107
                        Height = 23
                        Top = 50
                        Width = 133
                        Caption = 'Write zoom factor'
                        TabOrder = 4
                      end
                      object BtnOpen: TButton
                        Left = 8
                        Height = 25
                        Hint = 'Open spreadsheet or csv file.'
                        Top = 16
                        Width = 75
                        Anchors = [akLeft]
                        Caption = 'Open...'
                        OnClick = BtnOpenClick
                        TabOrder = 0
                      end
                      object BtnNextSheet: TButton
                        Left = 584
                        Height = 30
                        Hint = 'Navigate next sheet'
                        Top = 28
                        Width = 80
                        Anchors = [akLeft]
                        AutoSize = True
                        Caption = 'Next Sheet'
                        OnClick = BtnNextSheetClick
                        TabOrder = 5
                      end
                      object BtnPrevSheet: TButton
                        Left = 464
                        Height = 30
                        Hint = 'Navigate previous sheet'
                        Top = 28
                        Width = 103
                        Anchors = [akLeft]
                        AutoSize = True
                        Caption = 'Previous Sheet'
                        OnClick = BtnPrevSheetClick
                        TabOrder = 6
                      end
                      object SpeedButton1: TSpeedButton
                        Left = 386
                        Height = 54
                        Hint = 'Applpy Zoom'
                        Top = 13
                        Width = 47
                        Glyph.Data = {
                          [encoded data, 18496 characters]
                          0000000000000000000000000000000000000000000000000000
                        }
                        OnClick = SpeedButton1Click
                      end
                    end
                  end
                end
              end
            end
          end
          object PairSplitterSide4: TPairSplitterSide
            Cursor = crArrow
            Left = 0
            Height = 423
            Top = 405
            Width = 2131
            ClientWidth = 2131
            ClientHeight = 423
            object Panel38: TPanel
              Left = 0
              Height = 423
              Top = 0
              Width = 2131
              Align = alClient
              ClientHeight = 419
              ClientWidth = 2127
              TabOrder = 0
              object Panel58: TPanel
                Left = 1
                Height = 361
                Top = 61
                Width = 2129
                Align = alClient
                ClientHeight = 357
                ClientWidth = 2125
                TabOrder = 0
                object sWorksheetGrid1: TsWorksheetGrid
                  Left = 6
                  Height = 349
                  Top = 6
                  Width = 2117
                  AutoCalc = True
                  FrozenCols = 0
                  FrozenRows = 0
                  PageBreakPen.Color = clBlue
                  PageBreakPen.Style = psDash
                  ReadFormulas = False
                  ShowFormulas = True
                  WorkbookSource = sWorkbookSource1
                  Align = alClient
                  AutoAdvance = aaDown
                  BorderSpacing.Around = 5
                  DefaultColWidth = 64
                  DefaultRowHeight = 23
                  Options = [goFixedVertLine, goFixedHorzLine, goVertLine, goHorzLine, goRangeSelect, goRowSizing, goColSizing, goColMoving, goEditing, goAutoAddRows, goTabs, goAlwaysShowEditor, goColSpanning, goDblClickAutoSize, goSmoothScroll, goHeaderHotTracking]
                  TabOrder = 0
                end
              end
              object Panel3: TPanel
                Left = 1
                Height = 60
                Top = 1
                Width = 2129
                Align = alTop
                ClientHeight = 56
                ClientWidth = 2125
                TabOrder = 1
                object sCellIndicator1: TsCellIndicator
                  Left = 6
                  Height = 48
                  Top = 6
                  Width = 175
                  WorkbookSource = sWorkbookSource1
                  Align = alLeft
                  BorderSpacing.Around = 5
                  TabOrder = 0
                  Text = 'A1'
                end
                object sCellEdit1: TsCellEdit
                  Left = 186
                  Height = 48
                  Top = 6
                  Width = 1937
                  Align = alClient
                  BorderSpacing.Around = 5
                  ScrollBars = ssAutoBoth
                  TabOrder = 1
                  WorkbookSource = sWorkbookSource1
                end
              end
            end
          end
        end
      end
    end
    object UsersManual: TTabSheet
      Caption = 'UsersManual'
      ClientHeight = 869
      ClientWidth = 1781
      object Panel78: TPanel
        Left = 0
        Height = 843
        Top = 0
        Width = 1781
        Align = alClient
        ClientHeight = 839
        ClientWidth = 1777
        TabOrder = 0
        object Memo1: TMemo
          Left = 1
          Height = 841
          Top = 1
          Width = 1779
          Align = alClient
          HideSelection = False
          Lines.Strings = (
            'Mighty Query Users Manual'
            'Ver 1.1.'
            '2011-08-04'
            ''
            '1.'#9'Introduction'
            ''
            'MightyQuery is a single user SQL database management system , working with semi-colon separated data, which are stored as flat textual files. '
            'In contrast to most database systems, MightyQuery does not require neither server installation, neither external libraries. It is self-contained, simple and effective , multiplatform solution '
            'that can process and query textual (CSV) files. '
            'Though there are other database solutions that can process single textual file, MightyQuery is distinguished from them by its SQL engine, by which you can query and modify CSV '
            'tables with '
            'power that is normally reserved for huge enterprize-level SQL engines.'
            'If you need to process heterogenous business data exported from various enterprize ERP, MRP, Data Warehouse, Accounting or other database systems, MightyQuery could be your '
            'solution. It is, also, suitable for managing simple personal databases, in cases where installing and managing complicated SQL servers is overkill for you.'
            'To enable processing of external data, Mighty Query contains importing utility, supporting wide range of  SQL database servers, such as: PostgreSQL, Interbase, Firebird, MSSQL, Sybase, '
            'SQLite, Oracle, ado, ASA.'
            'MightyQuery is developed by using Typhon Free Pascal RAD IDE (www.typhon.freepascal.org) and janSQL database engine, which original code is written Jan Verhoeven '
            '(http://jansfreeware.com) and released under MPL 1.1. license. Modified source code of janSQL is provided in installation folder of MightyQuery application.'
            'Supported SQL: SELECT (with table joins, field aliases and calculated), UPDATE, INSERT (values and sub-select), DELETE, CREATE TABLE, DROP TABLE, ALTER TABLE, CONNECT TO, '
            'COMMIT, WHERE (rich bracketed expression), IN (list or sub query), GROUP BY, HAVING, ORDER BY ( ASC, DESC), nested sub queries, statistics (COUNT, SUM, AVG, MAX, MIN), '
            'operators '
            '(+,-,*,/, and, or,>,>=,<,<=,=,<>,Like), functions (UPPER, LOWER, TRIM, LEFT, MID, RIGHT, LEN, FIX, SOUNDEX, SQR, SQRT). High performance: complete in-memory handling of tables '
            'and recordsets; semi-compiled expressions. Calculated fields (in select and update statements), field aliases, table aliases, join "unlimited" tables, stdDev aggregate function, ASSIGN TO '
            'for '
            'named temporary tables, SAVE TABLE for persisting recordsets, INSERT INTO, ISO 8601 dates, numerous extra functions.'
            ''
            ''
            '2.'#9'General Concepts'
            ''
            'Formatting Issues'
            ''
            'In MightyQuery, by term “database” we consider a folder where your textual files with extension .txt are stored. Txt extension has been chosen, instead of .csv, for the sake of '
            'compatibility '
            'with Microsoft Access that exports data as .txt files rather than .csv.  Storing data in plain text files allows quick opening and editing  in external textual editors, as well as in spreadsheet '
            'programs such as Excel, Calc or Gnumeric.'
            'Columns are separated by semi-colon (;), not by colon (,).  The first row of the file contains the field names.'
            'Decimal separator is point(.), not colon. '
            'No quotes are used around text fields. You can not use the semi-colon character in data fields as it is used as the field separator.'
            'Unlike most other database engines that have strong data typing, there are no data types in MightyQuery. Everything is stored as a string and in calculations converted ad-hoc to a '
            'number '
            'when applicable in the context.'
            'To handle dates, you must store them as a string in the ISO 8601 format:'
            '   YYYY-MM-DD'
            '   YYYY-MM-DDThh:mm:ss'
            'A 4-digit year, followed by the 2-digit month number followed by the 2-digit day number. '
            'In your WHERE clauses you can then compare these string dates with each other. E.g. 1953-11-16 will be less than 2002-03-26.'
            '  SELECT * FROM users WHERE birthday>''1980-01-01'''
            'It is adviced to store dates and times in seperate fields. '
            'Times are stored as a string in the hh:mm:ss format: '
            'A 2 digit hour followed by a 2 digit minute value, followed by a 2-digit second value. Times are from ''00:00:00'' to ''23:59:59''.'
            ''
            'Organization And Terminology'
            ''
            'MightyQuery is organized into four main functionalities, placed in different pages of the same form: Projects, Tables, Queries, ExternalSources. Functional segments inside a page are '
            'organized in sections separated by splitters. By dragging splitters you can reorganize visual appearance of the application. Customization  is going to be saved on exiting the program '
            'and will '
            'be loaded when starting the application again.'
            '“Project” is in MightyQuery a term used for named database folders containing textual files. “Tables “ represents corresponding registered textual files. All schema information about '
            'registered databases, tables and fields are stored inside corresponding Dbase tables in the application folder. Saved filters are also saved in Dbase files.'
            'It is important to understand difference between registered projects, tables and fields to actual database folders and textual files. For example, for a project, only those tables are listed '
            'that were previously registered by you, although there can be much more textual files physically placed in the database folder. This is an issue when using direct editing of tables in the '
            'Tables page. When executing queries inside the Queries page, SQL database engine can access all textual files no matters whether they are registered in Tables page or not.'
            'Tables are named as the corresponding textual file name, without extension.'
            ''
            'Writing Changes To Files'
            ''
            'As you will see later on, all data processing is done in memory, rather than on hard disk. Thus, when directly editing some data related to underlying textual files (either schema either '
            'records), you will have to explicitly request saving of changes. The similar case is with modifying tables with  SQL queries. Unless you issue Commit or Save Table commands, no '
            'changes are '
            'saved to hard disk.'
            ''
            '3.'#9'Projects'
            ''
            'By term “Project”, we considered registered and named database (a folder containing textual files) information. Any project represents named information about a database folder. You '
            'can '
            'register more projects for the same physical database (folder).'
            'By using navigator buttons you can navigate through registered projects, edit information about them or insert new projects. Every project can be named (although not required) in '
            'ProjectName field. ProjectPath field represents absolute path of database folder or relative path starting with the application folder as the base path.'
            'You can enter path manually or by using the provided browser.'
            ''
            '4.'#9'Tables'
            ''
            'After you have registered a project, you have to register database tables. You can use file browser to select a textual file from the database folder. MightyQuery will automatically register '
            'selected textual file as the database table. It will name tables according to selected textual file name, removing extension from the name. '
            'Those textual files that are registered can be accessed directly in the Tables page for data retrieval, data editing and schema editing. '
            ''
            'Viewing And Modifying  Fields(Columns) Schema'
            ''
            'For current table, get schema information by pressing the button “Get Fields Schema”.'
            'If you wish, you can modify schema of a registered table, in the sense of inserting, editing or deleting fields (columns). Bare in mind that changes you make to fields schema in the '
            'Fields '
            'datagrid are not immediately written to underlying textual files, unless you click the button “Set Fields Schema”. Only when you click the button, MightyQuery will physically reorganize '
            'the '
            'underlying textual file to reflect requested changes. If you don’t click the button, underlying textual file will not be changed.'
            ''
            'Retrieving Data'
            ''
            'In order to retrieve data from a registered table, press the button “Load Data”. This will load data from currently selected table and show it in a datagrid and populate corresponding '
            'fields '
            'lists used for Find and Filter functionalities. Then you can navigate data, modify data, find a value on a field or filter records.'
            ''
            'Searching And Filtering'
            ''
            'Mighty query provides an easy and intuitive way for finding values. Just select the field in the list, enter the requested value and click “Find” button. '
            'For any project, named filters are stored in a separate Dbase file. You can navigate through existing filters, edit them or insert new filters. For the selected saved filter, you can use already '
            'saved expression or modify it before execution. You can enter expression manually or by using corresponding comboboxes with fields and expressions. When you click the “Filter” '
            'button, '
            'filter expression is saved under currently selected named filter and records are filtered. When you click “Remove” button, the filter is removed.'
            'I will not elaborate Filter expression syntax, since it is the same as for any other database. You can use field names, comparison operators (=,>,<,>=,<=, BLANK, IS NULL, IS NOT NULL), '
            'arithmetic and string operators (+, -, *, /), logical operators (AND, OR, NOT), matching functions with placeholder (LIKE, IN, *) and plenty of other functions. For example:'
            'Name LIKE ‘*Smith*’'
            'Name IN (‘Zlatko’, ‘John’, ‘Anthony’)'
            'Name=’Zlatko*’'
            ''
            'Editing Data'
            ''
            'MightyQuery allows you to edit retrieved records. But, since retrieved data is stored only in memory, no changes are saved to underlying textual file unless you press the button “Update '
            'CSV '
            'Table”. Only then changes will be written to disk.'
            ''
            '5.'#9'Queries'
            ''
            'Queries page contains essential functionalities of MightyQuery. It uses janSQL database engine and allows you to query textual files with semi-colon separated data as if they were tables '
            'inside a true database. '
            'You can use most of standard SQL language, as well as some extensions to the language that provide elementary way of creating kind of stored procedures.'
            ''
            'Queries Page'
            ''
            'Every saved query is stored  inside a Dbase table, so you can reuse it anytime. You can scroll through saved queries, edit them or insert new query. '
            ''
            'SQL editor'
            ''
            'In the SQL editor you can enter or view SQL expression for the current query. '
            'You can enter or modify SQL text manually or by using provided helper lists of tables, fields, SQL expressions and operators. By pressing some of  the '
            '“Apply” buttons you can copy currently selected item of a helper list to the current cursor position inside SQL Text. Using helper lists will save your time during creating an SQL query. '
            'The SQL from SQL editor is not immediately saved. If you want to save it, you must click Post button (green checkmark).'
            'The SQL editor has code colouring and autocompletion feature. To use autocompletion, click [CTR]+[Space]. This will open drop-down list from which you can choose an item for '
            'autocompletion.'
            'You can export SQL text as a file, by providing appropriate file name in the FileEdit box and clicking “Save Query To A File” button. Such externally saved query you can load to a '
            'current query anytime, by pressing “Load Query From A File” button.'
            ''
            'Executing Query'
            ''
            'There are two ways of executing queries. First one is by using “Run Query” button, while other way is by using “Run Parameterized Query”. The first one executes saved SQL text '
            'immediately, while other one first prepare SQL text by replacing parameters with actual values provided in Parameters list.'
            ''
            'Parameterized Queries'
            ''
            'MightyQuery provides simple way for writing and execution of parameterized queries. For any current saved query you can insert parameters into corresponding QueriesParameters '
            'Dbase '
            'table. There are two columns in QueriesParameters table: Parameter and Value. '
            'Parameter is a parameter’s name, which must be exactly the same as parameter inside the SQL text'
            'It must match parameter name inside the SQL text, so that MightyQuery can replace parameter with actual Value before passing SQL text to the SQL engine for execution. Replacement '
            'of a '
            'parameter with it’s value is simple string operation, so be aware that inside SQL text you must enclose parameter inside single quotes if it is going to be replaced by a string, while '
            'without '
            'quotes when replaced by a number. '
            'Pay attention that a parameter’s name should be some unique string inside the SQL text. I suggest you to enclose parameter with some recognizable character. For example, I use @ '
            'sign. '
            'Therefore, my parameters look like: @Parameter1@, @StartDate@, etc. You can adhere to standard Delphi way of naming parameters, such as :Parameter1, :Parameter2 etc.'
            'Parameterized queries are comfortable way for frequent execution of the same query with different input conditions, usually inside WHERE clause.'
            ''
            'Searching And Filtration'
            ''
            'Similar to Tables, recordsets retrieved by an SQL Query can be navigated, searched on a column and filtered.'
            'Mighty query provides an easy and intuitive way for finding values in a column. Just select the field in the list, enter the requested value and click “Find” button. '
            'For any project, named filters are stored in a separate Dbase file. You can navigate through existing filters, edit them or insert new filters. For the selected saved filter, you can use already '
            'saved expression or modify it before execution. You can enter expression manually or by using corresponding comboboxes with fields and expressions. Use “<” button to copy selected '
            'value '
            'into the expression. When you click the “Filter” button, filter expression is saved under currently selected named filter and records are filtered. When you click “Remove” button, the filter '
            'is '
            'removed.'
            'I will not elaborate Filter expression syntax, since it is the same as for any other database. You can use field names, comparison operators (=, >,<, >=,<=, BLANK, IS NULL, IS NOT NULL), '
            'arithmetic and string operators (+, -, *, /), logical operators (AND, OR, NOT), matching functions with placeholder (LIKE, IN, *) and plenty of other functions. For example:'
            'Name LIKE ‘*Smith*’'
            'Name IN (‘Zlatko’, ‘John’, ‘Anthony’)'
            'Name=’Zlatko*’'
            ''
            'Editing And Saving Query Results'
            ''
            'Records retrieved by a query are stored only in memory.'
            'Nevertheless, such retrieved recordset can be saved to a persisten .txt table, by providing file name in corresponding FileEdit box and by clicking “Save Query Result To A File” button. '
            'Don’t '
            'forget to add .txt extension to the file name. The result is a plain text file with semi-colon separated values, that you could register inside your project as a table.'
            'There is, also, another way of making query result’s recordset permanent. It is by using appropriate non-standard  SQL statements ASSIGN TO and SAVE TABLE in the SQL itself. See '
            'below, '
            'in SQL syntax explaination.'
            ''
            'SQL introduction '
            ''
            'janSQL database engine supports only a subset of standard SQL but the supported statements are sufficient for single-user desktop application.'
            ''
            'table updates'
            'janSQL loads tables automatically into memory when needed by a query. Any changes to tables (INSERT, UPDATE, DELETE) are performed in memory. Tables are saved to disk when '
            'you use '
            'the COMMIT statement. The only exceptions to this are the CREATE TABLE statement, where the new table is saved to disk immediately and the DROP TABLE statement, where the table '
            'is '
            'immediately deleted from both memory and disk.'
            ''
            'Indexes'
            'janSQL does not use indexes. You will find that for single-user desktop applications running in memory there is no urgent need for indexes.'
            ''
            'Case sensitivity'
            'janSQL is case-insensitive for its keywords: you can use both SELECT and select.'
            ''
            'Non-standard'
            'janSQL has several non-standard SQL statements for manipulation of recordsets.'
            '•'#9'ASSIGN TO '
            '•'#9'SAVE TABLE '
            '•'#9'RELEASE TABLE'
            ''
            'Compound Queries'
            'In MightyQuery, you can execute multiple queries in a batch. Query expressions in a compound query must be separated by semi-colon. '
            'By using the non-standard ASSIGN TO statement you can store the result of a select query as a named variable that can be used in subsequent queries. This resembles SQL stored '
            'procedures in other database systems.'
            ''
            'SQL syntax'
            ''
            'A) Data Definition Language'
            ''
            'CONNECT TO'
            'Connects to a database. In janSQL a database is a folder. Tables are stored in this folder as delimited text files with the .txt extension.'
            'Syntax:'
            'CONNECT TO ''absolute-folder-path'''
            ''
            'Example:'
            ' '#9'connect to ''G:''  '
            ' '
            'Notes'
            'This is always the first statement that you use with janSQL. All other SQL statements require that the engine knows which folder to use.'
            ''
            'CREATE TABLE'
            'Creates a new table in the current catalog.'
            'Syntax:'
            ' '#9'CREATE TABLE tablename (field1,[fieldN])'
            'Example:'
            ' '#9'CREATE TABLE users (userid,username,accountname, accountpassword)'
            'Notes'
            'janSQL does not use fieldtypes. Everything is stored as text. Internally janSQL treats all data as variants. This means that in your SQL queries you can use fields pretty much the way you '
            'want to.'
            ''
            'DROP TABLE'
            'Drops a table from the database.'
            'Syntax:'
            'DROP TABLE tablename'
            'Syntax:'
            'DROP TABLE users'
            'Notes'
            'Use with care, because it deletes a file from hard disk..'
            ''
            'ALTER TABLE'
            'Allows you to alter the structure of a table.'
            'Syntax:'
            ' '#9'ALTER TABLE ADD COLUMN columnname'
            'ALTER TABLE DROP COLUMN columnname'
            'You can only add or drop one column at the time.'
            ''
            'B) Data Manipulation Language'
            ''
            'SELECT FROM'
            'Allows you to select data from one or two tables.'
            'Syntax:'
            'SELECT fieldlist FROM tablename'
            '  '#9'SELECT fieldlist FROM tablename WHERE condition'
            '  '#9'SELECT fieldlist FROM tablename1 [alias1], tablenameN [aliasN]'
            ' '#9'SELECT fieldlist FROM tablename1 [alias1], tablenameN [aliasN] WHERE condition'
            ''
            'fieldlist can be * for selecting all fields or field1[,fieldN]'
            'field: fieldname [AS fieldalias]'
            'condition: see the WHERE topic.'
            ''
            'Notes'
            'When you join two or more tables  you must use fully qualified field names: tablename.fieldname in the WHERE clause. Both tablenames and fieldnames can be aliased.'
            ' '#9'SELECT u.userid as mio, u.username as ma, p.productname as muu'
            '  '#9'FROM users u,products p'
            '  '#9'WHERE u.productid=p.productid'
            'Using a table alias can save you typing.'
            '  '#9'select products.productname as product,count(users.userid) as quantity'
            '  '#9'from users,products'
            '  '#9'where users.productid=products.productid'
            '  '#9'group by product'
            '  '#9'having quantity>10'
            '  '#9'order by product desc'
            ' '
            'The example above shows you that in the WHERE clause you refer to source tables (e.g. products.productid) where as in the GROUP BY, HAVING and ORDER BY clause, you refer to the '
            'result table.'
            'Always use an aliased field name when using an aggregate function:'
            '  '#9'count(users.userid) as quantity'
            ' '
            'WHERE'
            'The WHERE clause can be used together with the SELECT, UPDATE and DELETE clauses.'
            'Syntax:'
            '  '#9'WHERE condition'
            ' '
            'condition'
            'The condition is an expression that must evaluate to a boolean true or false. The following operators are allowed:'
            ''
            'Arithmetic:'
            '+ - * / ( )'
            ''
            'Logic:'
            'and, or '
            ''
            'comparison:'
            '< <= = > >= '
            ''
            'string constants:'
            'e.g. ''Jan Verhoeven'' '
            ''
            'numeric constans:'
            'e.g. 12.45'
            ''
            'fieldnames'
            'e.g. userid, users.userid'
            ''
            'IMPORTANT NOTE: Sometimes JanSQL engine can''t process WHERE clause if there are several conditions and joins. In that case application will freeze.'
            'Therefore, try to simplify WHERE clause of the main expression by filtering one of the joined tables prior the main expression. Split the main query into few steps.'
            'This means you have to split the main expression into, for example, two expressions and assign the first one to a variable (ASSIGN TO) that you will use instead of the original table.'
            ''
            ''
            'IN'
            'e.g.'
            '   '#9'userid IN (300,401,402)'
            '   '#9'username IN (''Verhoeven'',''Smith'')'
            ''
            'LIKE'
            'e.g.'
            ' '#9' username Like ''%Verhoeven'''
            ''
            ''
            'You can use the % character as a placeholder to match any series of characters:'
            ' '#9' ''%Verhoeven'' will match Verhoeven at the end of username'
            '  '#9'''Verhoeven%'' will match Verhoeven at the beginning of username'
            ' '#9' ''%Verhoeven%'' will match Verhoeven anywhere in username'
            '  '
            ''
            'Sub queries'
            ''
            'You can use a subquery after the IN clause. Only non-correlated sub queries are allowed at the moment. A sub query must select a single field from a table. A sub query is executed at '
            'parsing time and returns a comma seperated list of values that replaces the query text in the IN clause. A sub query must be enclosed by brackets.'
            'Example:'
            'select * from users where productid in (select product id from products where productname like ''Ico%'')'
            ''
            'Notes'
            'When using a SELECT with a join between 2 tables you must use fully qualified names (tablename.fieldname) in every part of the query. In all other cases (UPDATE, INSERT) you must '
            'use '
            'the short form fieldname without the tablename.'
            ''
            'GROUP BY'
            'Allows you to group data according grouping fields.'
            'Syntax:'
            '  '#9'group by fieldlist'
            'fieldlist is a comma seperated list of one or more fields that you want to grouping to be applied.'
            'Example:'
            '  '#9'select count(userid), username, productid'
            '  '#9'from users'
            '  '#9'group by productid'
            '  '#9'order by productid'
            ' '
            'Aggregate functions'
            'You can apply the count, sum, avg, max, min, stddev function to an input field. When you use these functions without a GROUP BY clause, the resultset will contain only one row.'
            ''
            'HAVING'
            'Allows you to filter a recordset resulting from a GROUP BY clause.'
            'Syntax:'
            ' '#9'HAVING expression '
            'Example:'
            '  '#9'select count(userid), username, productid'
            ' '#9'from users'
            '  '#9'group by productid'
            ' '#9'having userid>10'
            '  '#9'order by productid'
            ' '
            'Notes'
            'Experienced SQL users will notice that janSQL uses a non-standard syntax in the HAVING clause. Instead of the standard having count(userid)>10, in janSQL you just use the name of the '
            'base table field, in this case userid.'
            ''
            'You should be aware of the difference between the WHERE clause and the HAVING clause. The WHERE clause is applied to table(s) in the FROM clause. The HAVING is applied after '
            'filtering '
            'with where and grouping with group by have been applied. The same applies to the ORDER BY clause which is also applied to the final result set.'
            ''
            'ORDER BY'
            'Allows you to sort the resulting recordsets.'
            'Syntax:'
            '   '#9'ORDER BY orderlist'
            'Example:'
            '   '#9'select * from users order by #userid asc, productid desc  '
            ''
            'orderlist is a comma seperated list of one or more order by components:'
            'component1[,componentN]'
            'ordercomponent:'
            '[#]fieldname [ASC|DESC]'
            ''
            'By placing the optional # before a fieldname it will be treated as a numeric field in the sort. Remember that in janSQL all data is stored as text.'
            'After the fieldname you can optionally put ASC for an ascending sort, or DESC for a descending sort. When you omit the sort direction the default ascending sort order is used.'
            ''
            'ASSIGN TO'
            'Allows you to assign the result of a SELECT statement to a named recordset that can be referred to in subsequent statements. This is a non-standard '
            'SQL statement. ASSIGN TO is like a variable assignment. You can create very complex compound queries with ASSIGN TO.'
            'Syntax:'
            '  '#9'ASSIGN TO tablename selectstatement'
            'Example:'
            '  '#9'ASSIGN TO mis SELECT userid, username FROM users'
            'If tablename allready exists in the catalog then an error occurs. '
            'When tablename does not exist in the catalog but was allready assigned to then the existing recordset is overwritten.'
            ''
            'Notes'
            'Make sure that you use output field alias names when you ASSIGN TO using a  SELECT with joined tables.'
            ''
            'When you execute the ASSIGN TO the given name will be assigned to the new recordset and the recordset itself will not be released until you use RELEASE TABLE.'
            ''
            'RELEASE TABLE'
            'Allows you to release any open table from memory, including intermediate tables created with ASIGN TO. This is a non-standard SQL statement.'
            'Syntax:'
            '  '#9'RELEASE TABLE tablename'
            'Example:'
            ''
            '  '#9'ASSIGN TO mis SELECT * FROM users'
            '  '#9'RELEASE TABLE mis'
            ''
            'SAVE TABLE'
            'Allows you to save any open table, including intermediate tables, to a file. This is a non-standard SQL statement.'
            'Syntax:'
            ' '#9'SAVE TABLE tablename'
            'When tablename is not open, an error occurs. When you save an intermediate table (created with ASSIGN TO), the intermediate table becomes a persistant table that is also saved with '
            'the '
            'COMMIT statement.'
            'Example:'
            'ASSIGN TO mis SELECT * FROM users'
            ' '#9'SAVE TABLE mis'
            'Notes'
            'Once you have saved an intermediate table with TABLE SAVE you can not ASSIGN TO anymore.'
            ''
            'INSERT INTO'
            'Allows you to insert data in a table, either row by row or from a recordset resulting from a SELECT.'
            'Syntax:'
            ' '#9' INSERT INTO tablename [(column1[,column])] VALUES (field1[,fieldN])'
            ' '#9' INSERT INTO tablename selectstatement'
            'Example:'
            '  '#9' INSERT INTO users VALUES (600,''user-600'');'
            ' '#9' INSERT INTO users (userid,username) VALUES (601,''user-601'');'
            ' '#9' INSERT INTO users SELECT * FROM users WHERE userid>400'
            'Notes'
            'When you insert records using a sub select you must make sure that the output fields of the sub select match the fieldnames of tablename. Only values of matching field will be '
            'inserted.'
            ''
            'UPDATE'
            'Allows you to update existing data.'
            'Syntax:'
            '  '#9'UPDATE tablename SET updatelist [WHERE condition]'
            'updatelist:'
            'field1=value1[,fieldN=valueN]'
            ''
            'condition: see WHERE  for the optional condition'
            ''
            'DELETE FROM'
            'Allows you to delete data.'
            'Syntax:'
            '  '#9'DELETE FROM tablename WHERE condition'
            'condition: see WHERE clause for the condition.'
            ''
            'C) Functions'
            ''
            'In janSQL you can use functions wherever you can use an expression to be calculated (Calculated output fields, WHERE clause, HAVING clause).'
            ''
            'Use extra brackets around function parameters when you have a function with more than one parameter:'
            ''
            '  SELECT trunc((userid/7),2) as foo FROM users'
            ' '
            'and not:'
            ''
            '  SELECT trunc(userid/7,2) as foo FROM users'
            ''
            'Conversion'
            ''
            'fix(expression,precision)'
            'Returns the string presentation of (numeric) expression with precision number of decimals.'
            ''
            '  select fix((userid/7), 2) as bobo from users order by bobo'
            ' '
            'You can also use TRUNC i.s.o. FIX. '
            ''
            'asnumber(expression)'
            'Returns (number or string) expression as number. If expression is not a valid floating point number then the function returns 0.'
            ''
            'FORMAT function'
            'Formats a integer or floating point value to a string in a way specified by a format string.'
            'Syntax:'
            '  '#9'format(value,formatstring) '
            'Example:'
            '  '#9'update users set userid=format(userid,''%.8d'')'
            ''
            'Format strings have the following form:'
            '[literalstring]"%" [width] ["." prec] type'
            ''
            '•'#9'An optional literal string that is copied to the output'
            '•'#9'An optional width specifier, [width]'
            '•'#9'An optional precision specifier, ["." prec]'
            '•'#9'The conversion type character, type'
            ''
            'The following table summarizes the possible values for type:'
            ''
            'd'
            'Decimal. The argument must be an integer value. The value is converted to a string of decimal digits. If the format string contains a precision specifier, it indicates that the resulting '
            'string '
            'must contain at least the specified number of digits; if the value has less digits, the resulting string is left-padded with zeros.'
            ''
            'u'
            'Unsigned decimal. Similar to ''d'' but no sign is output.'
            ''
            'e'
            'Scientific. The argument must be a floating-point value. The value is converted to a string of the form "-d.ddd...E+ddd". The resulting string starts with a minus sign if the number is '
            'negative. '
            'One digit always precedes the decimal point.The total number of digits in the resulting string (including the one before the decimal point) is given by the precision specifier in the '
            'format '
            'string—a default precision of 15 is assumed if no precision specifier is present. The "E" exponent character in the resulting string is always followed by a plus or minus sign and at least '
            'three '
            'digits.'
            ''
            'f'
            'Fixed. The argument must be a floating-point value. The value is converted to a string of the form "-ddd.ddd...". The resulting string starts with a minus sign if the number is '
            'negative.The '
            'number of digits after the decimal point is given by the precision specifier in the format string—a default of 2 decimal digits is assumed if no precision specifier is present.'
            ''
            'g'
            'General. The argument must be a floating-point value. The value is converted to the shortest possible decimal string using fixed or scientific format. The number of significant digits in '
            'the '
            'resulting string is given by the precision specifier in the format string—a default precision of 15 is assumed if no precision specifier is present.Trailing zeros are removed from the '
            'resulting '
            'string, and a decimal point appears only if necessary. The resulting string uses fixed point format if the number of digits to the left of the decimal point in the value is less than or equal '
            'to the '
            'specified precision, and if the value is greater than or equal to 0.00001. Otherwise the resulting string uses scientific format.'
            ''
            'n'
            'Number. The argument must be a floating-point value. The value is converted to a string of the form "-d,ddd,ddd.ddd...". The "n" format corresponds to the "f" format, except that the '
            'resulting string contains thousand separators.'
            ''
            'm'
            'Money. The argument must be a floating-point value. The value is converted to a string that represents a currency amount. The conversion is controlled by the CurrencyString, '
            'CurrencyFormat, NegCurrFormat, ThousandSeparator, DecimalSeparator, and CurrencyDecimals global variables, all of which are initialized from the Currency Format in the '
            'International '
            'section of the Windows Control Panel. If the format string contains a precision specifier, it overrides the value given by the CurrencyDecimals global variable.'
            ''
            's'
            'String. The argument must be a string value. The string  is inserted in place of the format specifier. The precision specifier, if present in the format string, specifies the maximum length '
            'of the '
            'resulting string. If the argument is a string that is longer than this maximum, the string is truncated.'
            ''
            'x'
            'Hexadecimal. The argument must be an integer value. The value is converted to a string of hexadecimal digits. If the format string contains a precision specifier, it indicates that the '
            'resulting '
            'string must contain at least the specified number of digits; if the value has fewer digits, the resulting string is left-padded with zeros.'
            ''
            ' Date functions '
            ''
            'Several date functions make working with date strings easier.'
            ''
            'YEAR'
            'Extracts the integer year part of a yyyy-mm-dd date string.'
            ''
            'MONTH'
            'Extracts the integer month part of a yyyy-mm-dd date string.'
            ''
            'DAY'
            'Extracts the integer day part of a yyyy-mm-dd date string.'
            ''
            'WEEKNUMBER'
            'Returns the integer weeknumber of a yyyy-mm-dd date string.'
            ''
            'EASTER'
            'Returns the easter yyyy-mm-dd date string of a given integer year.'
            ''
            'DATEADD'
            'Adds a given number of time intervals to a given data and returns the resulting data as a yyyy-mm-dd data string.'
            'Syntax:'
            ' '#9' DATEADD(interval,number,datestring)'
            ' '
            'Interval can be: ''d'' (day), ''m'' (month), ''y'' (year), ''w'' (week), ''q'' (quarter).'
            'Number must be an integer number.'
            'datestring must be in the yyyy-mm-dd format.'
            ''
            ' String Functions '
            ''
            'janSQL comes with a range of functions that work on strings.'
            ''
            'soundex(expression)'
            'Calculates the soundex value of (string) expression. Only usefull with english terms.'
            ''
            'lower(expression)'
            'Converts (string) expression to lower case.'
            ''
            'upper(expression)'
            'Converts (string) expression to upper case.'
            ''
            'trim(expression)'
            'Trims (string) expression from leading and trailing spaces.'
            ''
            'left(expression,count)'
            'Returns the first count characters of expression'
            ''
            'right(expression,count)'
            'Returns the last count characters of expression'
            ''
            'mid(expression,from,count)'
            'Returns count characters of expression starting at from.'
            ''
            'length(expression)'
            'Returns the length of (string) expression. Can be used to e.g. select fields that exceed a given length.'
            ''
            'replace(source,oldpattern,newpattern'
            'Replaces oldpattern with new pattern in the source string. Is case-insensitive.'
            ' '#9'UPDATE users SET username=replace(username,''user-'',''foo-'')'
            ' '
            'substr_after(source,substring)'
            'Returns the part of source that comes after substring. If substring is not found an empty string is returned.'
            ''
            'substr_before(source,substring)'
            'Returns the part of source that comes before substring. If substring is not found an empty string is returned.'
            ''
            ' Numeric Functions '
            ''
            'Numeric functions work on strings as if they were numbers. Although janSQL is based on strings you can still enter values like 1234, which can be treated like numbers.'
            ''
            'sqr(expression)'
            'Calculates the square of (numeric) expression.'
            ''
            'sqrt(expression)'
            'Calculates the square root of (numeric) expression.'
            ''
            'sin(expression)'
            'Calculates the sin of (numeric) expression.'
            ''
            'cos(expression)'
            'Calculates the cos of (numeric) expression.'
            ''
            'ceil(expression)'
            'Returns the lowest integer greater than or equal to (numeric) expression.'
            ''
            'floor(expression)'
            'Returns the the highest integer less than or equal to (numeric) expression.'
            ''
            ''
            '6.'#9'Import From External Databases'
            ''
            'In the ExternalSource page, you can register different external SQL databases from which you can import tables as plain textual files with semi-colon separated values, suitable for '
            'MightyQuery database.'
            'Insert new record for an external source, name it in the “SqlConnectorName” field, then enter other fields. “Protocol” is a value designating type of SQL Database and is choosed from '
            'the '
            'pick list of predefined values. “Database” is full path to the database file or database name. you must provide values for “HostName”, “User” and “Password”, while “Port” and “Catalog” '
            'are '
            'usually not necessary.'
            'After you enetered all required values, you can test whether connection is OK, by pressing “Test Connection” button. '
            'You can register as much external databases as you wish. Only tables from those that have checked “ToBeImported” field will be imported when “ImportTables” button is clicked.'
            'After you have registered external database, you can populate list of available tables in the database. Press “Get Tables Schema” button and all available tables will be inserted into the '
            'SQLTables rows. Additionally, you can see corresponding fields schema, by pressing “Get Fields Schema”. '
            'Similary for database, you must check those tables that you wish to be imported, in the field “ToBeImported”.'
            'You can, also, retrieve data from external tables, by clicking “LoadData” button.'
            'Since data is copied to memory, any modification of data in the datagrid will not reflect original SQL database.'
            'After you defined which external tables should be imported, you can import them into current MightyQuery database, by pressing “ImportTables” button. Note that you will be able to '
            'query '
            'them instantly in the Queries page, but if you want to edit them in Tables page, you will have to register those tables first.'
            ''
            '7.'#9'Contact'
            ''
            'Zlatko Matić'
            'Milkovićeva 6'
            'Mala Ostrna'
            '10370 Dugo Selo'
            'Croatia'
            ''
            'e-mail: matalab@gmail.com'
            ''
          )
          ScrollBars = ssAutoBoth
          TabOrder = 0
        end
      end
    end
    object About: TTabSheet
      Caption = 'About'
      ClientHeight = 869
      ClientWidth = 1781
      object Panel79: TPanel
        Left = 0
        Height = 843
        Top = 0
        Width = 1781
        Align = alClient
        ClientHeight = 839
        ClientWidth = 1777
        TabOrder = 0
        object Memo2: TMemo
          Left = 1
          Height = 841
          Top = 1
          Width = 1779
          Align = alClient
          Lines.Strings = (
            '*******************************************************************'
            '                                                                                                    '
            '                                   MightyQuery                                                          '
            '            SQL Database Management Software                           '
            ''
            '   Original developer: Zlatko Matić  (matic.zlatko@gmail.com), 2009-2023 '
            '          Milkovićeva 6, Mala Ostrna, 10370 Dugo Selo,  Croatia. '
            ''
            '*******************************************************************'#9' '
            ''
            'MightyQuery is a single user SQL database management software working with data stored as comma separated values (.csv, .txt) in plain, flat, textual files. It is serverless, self-'
            'contained, simple and effective SQL DBMS for querying CSV files. In contrast to most database systems, MightyQuery does not require neither server installation, neither external '
            'libraries. '
            'Though there are other database solutions that can process single textual file, MightyQuery is distinguished from them by its SQL engine, by which you can query and modify CSV '
            'tables with power that is normally reserved for huge enterprize-level SQL engines.'
            'If you need to process heterogenous business data exported from various enterprize ERP, MRP, Data Warehouse, Accounting or other database systems, MightyQuery could be your '
            'solution. It is, also, suitable for managing simple personal databases, in cases where installing and managing complicated SQL servers is overkill for you.'
            'To enable processing of external data, Mighty Query contains importing utility, supporting wide range of  SQL database servers, such as: PostgreSQL, Interbase, Firebird, MSSQL, Sybase, '
            'SQLite, Oracle, ado, ASA.'
            ''
            'MightyQuery is developed by using Typhon Free Pascal RAD IDE (www.typhon.freepascal.org) and zmsql package. '
            ''
            'ZMSQL package is based on TBufDataset/TRxMemoryData and JanSQL database engine, which original code is written Jan Verhoeven (http://jansfreeware.com) and released under MPL 1.1. license. '
            ''
            'You can download MightyQuery''s source code and binaries from:'
            ''
            'Source code (CodeTyphon v. 8.00):'
            'https://matasoft.hr/MightyQuery.7z'
            ''
            'Compiled binaries for Linux and Windows:'
            'https://matasoft.hr/MightyQuery_Binary.7z'
            ''
            'Alternative download:'
            'http://www.4shared.com/folder/XL3EZwUR/MightyQuery.html'
            ''
          )
          ReadOnly = True
          ScrollBars = ssAutoBoth
          TabOrder = 0
        end
      end
    end
    object Contact: TTabSheet
      Caption = 'Contact'
      ClientHeight = 869
      ClientWidth = 1781
      object Panel80: TPanel
        Left = 0
        Height = 843
        Top = 0
        Width = 1781
        Align = alClient
        ChildSizing.EnlargeHorizontal = crsScaleChilds
        ChildSizing.EnlargeVertical = crsScaleChilds
        ChildSizing.ShrinkHorizontal = crsScaleChilds
        ChildSizing.ShrinkVertical = crsScaleChilds
        ChildSizing.Layout = cclLeftToRightThenTopToBottom
        ClientHeight = 839
        ClientWidth = 1777
        TabOrder = 0
        object Memo4: TMemo
          Left = 1
          Height = 841
          Top = 1
          Width = 1779
          Align = alClient
          Alignment = taCenter
          Lines.Strings = (
            ''
            'Original author of the MightyQuery Software:'
            ''
            'Zlatko Matić'
            'Milkovićeva 6'
            'Mala Ostrna'
            '10370 Dugo Selo'
            'Croatia'
            ''
            'e-mail: '
            'matic.zlatko@gmail.com'
            'zlatko.matic@matasoft.hr'
            'zmatasoft@gmail.com'
            ''
            'https://matasoft.hr'
          )
          ScrollBars = ssAutoBoth
          TabOrder = 0
        end
      end
    end
    object Donate: TTabSheet
      Caption = 'Donate'
      ClientHeight = 869
      ClientWidth = 1781
      object Memo3: TMemo
        Left = 0
        Height = 843
        Top = 0
        Width = 1781
        Align = alClient
        Alignment = taCenter
        Lines.Strings = (
          ''
          'If you find this software useful, please support this software by donation.'
          ''
          'Donation:'
          ''
          'Zlatko Matić, '
          'Milkovićeva 6, Mala Ostrna, 10370 Dugo Selo, Croatia'
          'Bank: Zagrebacka banka dd, Zagreb, Paromlinska 2'
          'SWIFT/BIC: ZABAHR2X'
          'IBAN: HR3323600003214136777'
          ''
          'Thank you!'
        )
        ScrollBars = ssAutoBoth
        TabOrder = 0
      end
    end
  end
  object CSVExporterQueryResult: TCSVExporter
    ExportFields = <>
    FromCurrent = False
    RestorePosition = False
    FormatSettings.DecimalSeparator = #0
    FormatSettings.CurrencyDigits = 0
    FormatSettings.FieldDelimiter = ';'
    FormatSettings.IgnoreOuterWhitespace = False
    FormatSettings.RowDelimiter = #10
    FormatSettings.QuoteChar = '"'
    Left = 664
    Top = 374
  end
  object XMLPropStorage1: TXMLPropStorage
    StoredValues = <>
    FileName = 'MightyQuerySession.xml'
    Active = False
    Left = 824
  end
  object CSVExporterExternalTable: TCSVExporter
    ExportFields = <>
    FromCurrent = False
    RestorePosition = False
    FormatSettings.DecimalSeparator = #0
    FormatSettings.CurrencyDigits = 0
    FormatSettings.FieldDelimiter = ';'
    FormatSettings.IgnoreOuterWhitespace = False
    FormatSettings.RowDelimiter = #10
    FormatSettings.QuoteChar = '"'
    Left = 464
    Top = 424
  end
  object CSVExporterCSVTableData: TCSVExporter
    ExportFields = <>
    FromCurrent = False
    RestorePosition = False
    FormatSettings.DecimalSeparator = #0
    FormatSettings.CurrencyDigits = 0
    FormatSettings.FieldDelimiter = ';'
    FormatSettings.IgnoreOuterWhitespace = False
    FormatSettings.RowDelimiter = #10
    FormatSettings.QuoteChar = '"'
    Left = 688
    Top = 440
  end
  object SynSQLSyn1: TSynSQLSyn
    DefaultFilter = 'SQL Files (*.sql)|*.sql'
    Enabled = False
    IdentifierAttri.Foreground = clBlue
    KeyAttri.Foreground = clFuchsia
    NumberAttri.Foreground = clGreen
    PLSQLAttri.Foreground = clTeal
    SQLPlusAttri.Foreground = clAqua
    StringAttri.Foreground = clLime
    SymbolAttri.Foreground = clMaroon
    TableNameAttri.Foreground = clRed
    SQLDialect = sqlStandard
    Left = 592
    Top = 240
  end
  object ZMQueryBuilder1: TZMQueryBuilder
    ZMConnection = DataModule1.ZMConnection1
    ACtive = False
    Left = 843
    Top = 352
  end
  object sWorkbookSource1: TsWorkbookSource
    FileFormat = sfUser
    Options = [boAutoCalc, boReadFormulas]
    Left = 301
    Top = 334
  end
  object FPSExport1: TFPSExport
    Dataset = sWorksheetDataset1
    ExportFields = <>
    FormatSettings.IntegerFormat = '%d'
    FormatSettings.DecimalSeparator = '.'
    FormatSettings.CurrencySymbol = 'Kn'
    FormatSettings.CurrencyDigits = 0
    FormatSettings.BooleanTrue = 'True'
    FormatSettings.BooleanFalse = 'False'
    FormatSettings.DateFormat = 'dd.mm.yyyy'
    FormatSettings.TimeFormat = 'hh:nn:ss'
    FormatSettings.DateTimeFormat = 'dd.mm.yyyy hh:nn:ss'
    FormatSettings.ExportFormat = efODS
    FormatSettings.HeaderRow = True
    FormatSettings.SheetName = 'Sheet1'
    FromCurrent = False
    Left = 537
    Top = 345
  end
  object sWorksheetDataset1: TsWorksheetDataset
    FieldDefs = <>
    Left = 749
    Top = 337
  end
  object RxDBGridFooterTools1: TRxDBGridFooterTools
    Caption = 'Totals row'
    Left = 92
    Top = 203
  end
  object RxDBGridExportSpreadSheet1: TRxDBGridExportSpreadSheet
    Caption = 'Export to speadsheet'
    Options = []
    Left = 254
    Top = 275
  end
  object RxSortZeos1: TRxSortZeos
    Left = 314
    Top = 275
  end
  object RxSortSqlDB1: TRxSortSqlDB
    Left = 156
    Top = 281
  end
  object RxSortFBDataSet1: TRxSortFBDataSet
    Left = 101
    Top = 278
  end
  object VSBEngineZmsql1: TVSBEngineZmsql
    Connection = DataModule1.ZMConnection1
    Left = 936
    Top = 345
  end
  object OpenDialog: TOpenDialog
    Left = 280
    Top = 128
  end
  object SaveDialog: TSaveDialog
    Left = 280
    Top = 187
  end
  object RxDBGridExportSpreadSheetProjects: TRxDBGridExportSpreadSheet
    RxDBGrid = DBGridProjects
    Caption = 'Export to speadsheet'
    ShowSetupForm = True
    OnBeforeExecute = RxDBGridExportSpreadSheetProjectsBeforeExecute
    FileName = 'Projects.ods'
    PageName = 'Sheet1'
    Options = [ressExportTitle]
    OpenAfterExport = True
    Left = 704
    Top = 187
  end
  object RxDBGridExportSpreadSheetAutoinc: TRxDBGridExportSpreadSheet
    RxDBGrid = DBGridAutoincs
    Caption = 'Export to speadsheet'
    ShowSetupForm = True
    FileName = 'Autoinc.ods'
    PageName = 'Sheet1'
    Options = [ressExportTitle]
    OpenAfterExport = True
    Left = 704
    Top = 187
  end
  object RxDBGridExportSpreadSheetCSVTable: TRxDBGridExportSpreadSheet
    RxDBGrid = DBGridCSVTableData
    Caption = 'Export to speadsheet'
    ShowSetupForm = True
    FileName = 'CSVTable.ods'
    PageName = 'Sheet1'
    Options = [ressExportTitle]
    OpenAfterExport = True
    Left = 704
    Top = 187
  end
  object RxDBGridExportSpreadSheetFields: TRxDBGridExportSpreadSheet
    RxDBGrid = DBGridFields
    Caption = 'Export to speadsheet'
    ShowSetupForm = True
    FileName = 'Fields.ods'
    PageName = 'Sheet1'
    Options = [ressExportTitle]
    OpenAfterExport = True
    Left = 704
    Top = 187
  end
  object RxDBGridExportSpreadSheetFieldsForQueries: TRxDBGridExportSpreadSheet
    RxDBGrid = DBGridFieldsForQueries
    Caption = 'Export to speadsheet'
    ShowSetupForm = True
    FileName = 'FieldsForQueries.ods'
    PageName = 'Sheet1'
    Options = [ressExportTitle]
    OpenAfterExport = True
    Left = 704
    Top = 187
  end
  object RxDBGridExportSpreadSheetQueries: TRxDBGridExportSpreadSheet
    RxDBGrid = DBGridQueries
    Caption = 'Export to speadsheet'
    ShowSetupForm = True
    FileName = 'Queries.ods'
    PageName = 'Sheet1'
    Options = [ressExportTitle]
    OpenAfterExport = True
    Left = 704
    Top = 187
  end
  object RxDBGridExportSpreadSheetQueryParameters: TRxDBGridExportSpreadSheet
    RxDBGrid = DBGridQueriesParameters
    Caption = 'Export to speadsheet'
    ShowSetupForm = True
    FileName = 'QueryParameters.ods'
    PageName = 'Sheet1'
    Options = [ressExportTitle]
    OpenAfterExport = True
    Left = 704
    Top = 187
  end
  object RxDBGridExportSpreadSheetQueryResult: TRxDBGridExportSpreadSheet
    RxDBGrid = DBGridQueryResult
    Caption = 'Export to speadsheet'
    ShowSetupForm = True
    FileName = 'QueryResult.ods'
    PageName = 'Sheet1'
    Options = [ressExportTitle]
    OpenAfterExport = True
    Left = 704
    Top = 187
  end
  object RxDBGridExportSpreadSheetSQLConnectors: TRxDBGridExportSpreadSheet
    RxDBGrid = DBGridSQLConnectors
    Caption = 'Export to speadsheet'
    ShowSetupForm = True
    FileName = 'SQLConnectors.ods'
    PageName = 'Sheet1'
    Options = [ressExportTitle]
    OpenAfterExport = True
    Left = 704
    Top = 187
  end
  object RxDBGridExportSpreadSheetSQLTableData: TRxDBGridExportSpreadSheet
    RxDBGrid = DBGridSQLTableData
    Caption = 'Export to speadsheet'
    ShowSetupForm = True
    FileName = 'SQLTableData.ods'
    PageName = 'Sheet1'
    Options = [ressExportTitle]
    OpenAfterExport = True
    Left = 704
    Top = 187
  end
  object RxDBGridExportSpreadSheetSQLTables: TRxDBGridExportSpreadSheet
    RxDBGrid = DBGridSQLTables
    Caption = 'Export to speadsheet'
    ShowSetupForm = True
    FileName = 'SQLTables.ods'
    PageName = 'Sheet1'
    Options = [ressExportTitle]
    OpenAfterExport = True
    Left = 704
    Top = 187
  end
  object RxDBGridExportSpreadSheetTables: TRxDBGridExportSpreadSheet
    RxDBGrid = DBGridTables
    Caption = 'Export to speadsheet'
    ShowSetupForm = True
    FileName = 'Tables.ods'
    PageName = 'Sheet1'
    Options = [ressExportTitle]
    OpenAfterExport = True
    Left = 704
    Top = 187
  end
  object RxDBGridExportSpreadSheetTablesForQueries: TRxDBGridExportSpreadSheet
    RxDBGrid = DBGridTablesForQueries
    Caption = 'Export to speadsheet'
    ShowSetupForm = True
    FileName = 'TablesForQueries.ods'
    PageName = 'Sheet1'
    Options = [ressExportTitle]
    OpenAfterExport = True
    Left = 704
    Top = 187
  end
  object VSBBuilderZmsql1: TVSBBuilderZmsql
    Engine = VSBEngineZmsql1
    Left = 1014
    Top = 358
  end
end
