home *** CD-ROM | disk | FTP | other *** search
- object frmGQE: TfrmGQE
- Left = 237
- Top = 114
- Width = 710
- Height = 505
- BorderIcons = [biSystemMenu, biMaximize]
- Caption = 'SQL Builder'
- Color = clBtnFace
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clWindowText
- Font.Height = -11
- Font.Name = 'Default'
- Font.Style = []
- KeyPreview = True
- Menu = MainMenu1
- OldCreateOrder = True
- Position = poScreenCenter
- Visible = True
- OnClose = FormClose
- OnCreate = FormCreate
- OnKeyDown = FormKeyDown
- PixelsPerInch = 96
- TextHeight = 13
- object MainSplitter: TSplitter
- Left = 0
- Top = 238
- Width = 702
- Height = 6
- Cursor = crVSplit
- Hint = 'Drag to resize top and bottom query panels'
- Align = alBottom
- Color = clBtnFace
- ParentColor = False
- end
- object nbQuery: TPageControl
- Left = 0
- Top = 244
- Width = 702
- Height = 215
- ActivePage = pageJoins
- Align = alBottom
- TabOrder = 0
- Visible = False
- OnChange = nbQueryChange
- object pageWhere: TTabSheet
- Caption = 'Criteria'
- object criteriaOptions: TPanel
- Left = 0
- Top = 0
- Width = 694
- Height = 26
- Align = alTop
- BevelOuter = bvNone
- TabOrder = 0
- object Label3: TLabel
- Left = 94
- Top = 7
- Width = 146
- Height = 13
- Caption = 'of the following criteria are met:'
- end
- object WhereBlockOp: TComboBox
- Left = 2
- Top = 2
- Width = 90
- Height = 21
- Style = csDropDownList
- ItemHeight = 13
- Items.Strings = (
- 'ALL'
- 'ANY'
- 'NONE'
- 'NOT ALL')
- TabOrder = 0
- end
- end
- end
- object pageSelect: TTabSheet
- Caption = 'Selection'
- object Panel1: TPanel
- Left = 0
- Top = 0
- Width = 694
- Height = 24
- Align = alTop
- BevelOuter = bvNone
- TabOrder = 0
- object cbRemoveDuplicates: TCheckBox
- Left = 7
- Top = 3
- Width = 126
- Height = 17
- Caption = '&Remove Duplicates'
- TabOrder = 0
- OnClick = cbRemoveDuplicatesClick
- end
- end
- end
- object pageGroupBy: TTabSheet
- Caption = 'Grouping'
- end
- object pageHaving: TTabSheet
- Caption = 'Group Criteria'
- object Panel2: TPanel
- Left = 0
- Top = 0
- Width = 0
- Height = 26
- Align = alTop
- BevelOuter = bvNone
- TabOrder = 0
- object Label4: TLabel
- Left = 94
- Top = 7
- Width = 146
- Height = 13
- Caption = 'of the following criteria are met:'
- end
- object HavingBlockOp: TComboBox
- Left = 2
- Top = 2
- Width = 90
- Height = 21
- Style = csDropDownList
- ItemHeight = 13
- Items.Strings = (
- 'ALL'
- 'ANY'
- 'NONE'
- 'NOT ALL')
- TabOrder = 0
- end
- end
- end
- object pageOrderBy: TTabSheet
- Caption = 'Sorting'
- end
- object pageJoins: TTabSheet
- Caption = 'Joins'
- object panelJoinGrid: TPanel
- Left = 0
- Top = 22
- Width = 694
- Height = 165
- Align = alClient
- BevelOuter = bvNone
- TabOrder = 0
- end
- object joinOptions: TPanel
- Left = 0
- Top = 0
- Width = 694
- Height = 22
- Align = alTop
- BevelOuter = bvNone
- TabOrder = 1
- OnResize = joinOptionsResize
- object Panel3: TPanel
- Left = 532
- Top = 0
- Width = 162
- Height = 22
- Align = alRight
- Alignment = taRightJustify
- BevelOuter = bvNone
- Caption = 'Panel3'
- TabOrder = 0
- object cbRightOuter: TCheckBox
- Left = 2
- Top = 2
- Width = 163
- Height = 18
- Caption = 'I&nclude Unmatched Records'
- TabOrder = 0
- end
- end
- object Panel4: TPanel
- Left = 0
- Top = 0
- Width = 170
- Height = 22
- Align = alLeft
- BevelOuter = bvNone
- Caption = 'Panel4'
- TabOrder = 1
- object cbLeftOuter: TCheckBox
- Left = 5
- Top = 2
- Width = 162
- Height = 18
- Caption = '&Include Unmatched Records'
- TabOrder = 0
- end
- end
- object joinCombo: TComboBox
- Left = 172
- Top = 2
- Width = 227
- Height = 21
- Style = csDropDownList
- ItemHeight = 13
- TabOrder = 2
- end
- end
- end
- end
- object basicbuttonbar: TToolBar
- Left = 0
- Top = 0
- Width = 702
- Height = 26
- AutoSize = True
- Images = ImageList1
- Indent = 4
- TabOrder = 1
- object tbbFileNew: TSpeedButton
- Left = 4
- Top = 2
- Width = 21
- Height = 22
- Hint = 'Create a new query'
- Flat = True
- Glyph.Data = {
- F6000000424DF600000000000000760000002800000010000000100000000100
- 0400000000008000000000000000000000001000000010000000FFFFFF000000
- 8000008000000080800080000000800080008080000080808000C0C0C0000000
- FF000000000000FFFF00FF000000FF00FF00FFFF000000666600888888888888
- 88888888888888888888888AAAAAAAAAAA88888A000000000A88888A00000000
- 0A88888A000000000A88888A000000000A88888A000000000A88888A00000000
- 0A88888A000000000A88888A000000000A88888A000000AAAA88888A000000A0
- A888888A000000AA8888888AAAAAAAA888888888888888888888}
- ParentShowHint = False
- ShowHint = True
- OnClick = New1Click
- end
- object tbbOpen: TSpeedButton
- Left = 25
- Top = 2
- Width = 20
- Height = 22
- Hint = 'Open an existing SQL Query'
- Flat = True
- Glyph.Data = {
- 36010000424D3601000000000000760000002800000011000000100000000100
- 040000000000C000000000000000000000001000000010000000FFFFFF000000
- 8000008000000080800080000000800080008080000080808000C0C0C0000000
- FF000000000000FFFF00FF000000FF00FF00FFFF000000666600888888888888
- 8888800000008888888888888888800000008AAAAAAAAAAA8888800000008AA3
- 33333333A888800000008ABA333333333A88800000008A0B0333333333A88000
- 00008AB0BA333333333A800000008A0B0BAAAAAAAAAAA00000008AB0B0B0B0BA
- 8888800000008A0B0B0B0B0A8888800000008AB0BAAAAAAA88888000000088AA
- A88888888AAA8000000088888888888888AA80000000888888888A888A8A8000
- 00008888888888AAA88880000000888888888888888880000000}
- ParentShowHint = False
- ShowHint = True
- OnClick = tbbOpenClick
- end
- object tbbFileSave: TSpeedButton
- Left = 45
- Top = 2
- Width = 20
- Height = 22
- Hint = 'Save the current query'
- Flat = True
- Glyph.Data = {
- F6000000424DF600000000000000760000002800000010000000100000000100
- 0400000000008000000000000000000000001000000010000000FFFFFF000000
- 8000008000000080800080000000800080008080000080808000C0C0C0000000
- FF000000000000FFFF00FF000000FF00FF00FFFF000000666600888888888888
- 888888AAAAAAAAAAAAA88A33AAAAAA88A3A88A33AAAAAA88A3A88A33AAAAAA88
- A3A88A33AAAAAAAAA3A88A333333333333A88A33AAAAAAAA33A88A3A88888888
- A3A88A3A88888888A3A88A3A88888888A3A88A3A88888888A3A88A3A88888888
- AAA88A3A88888888A8A88AAAAAAAAAAAAAA88888888888888888}
- ParentShowHint = False
- ShowHint = True
- OnClick = Save1Click
- end
- object ToolButton3: TToolButton
- Left = 65
- Top = 2
- Width = 8
- Caption = 'ToolButton3'
- ImageIndex = 1
- Style = tbsDivider
- end
- object tbbCut: TSpeedButton
- Left = 73
- Top = 2
- Width = 19
- Height = 22
- Hint = 'Cut to Clipboard'
- Flat = True
- Glyph.Data = {
- 36010000424D3601000000000000760000002800000011000000100000000100
- 040000000000C000000000000000000000001000000010000000FFFFFF000000
- 8000008000000080800080000000800080008080000080808000C0C0C0000000
- FF000000000000FFFF00FF000000FF00FF00FFFF000000666600888888888888
- 8888800000008888844888888888800000008888488488448888800000008888
- 4884848848888000000088884884848848888000000088888444848848888000
- 000088888884844488888000000088888884A48888888000000088888888A888
- 8888800000008888888AAA888888800000008888888A8A888888800000008888
- 88AA8AA8888880000000888888A888A8888880000000888888A888A888888000
- 0000888888A888A8888880000000888888888888888880000000}
- ParentShowHint = False
- ShowHint = True
- OnClick = Cut1Click
- end
- object tbbCopy: TSpeedButton
- Left = 92
- Top = 2
- Width = 20
- Height = 22
- Hint = 'Copy to Clipboard'
- Flat = True
- Glyph.Data = {
- F6000000424DF600000000000000760000002800000010000000100000000100
- 0400000000008000000000000000000000001000000010000000FFFFFF000000
- 8000008000000080800080000000800080008080000080808000C0C0C0000000
- FF000000000000FFFF00FF000000FF00FF00FFFF000000666600888888888888
- 8888888888888888888888888884444444448888888400000004888888840AAA
- AA048AAAAAA4000000048A0000040AAAAA048A0AAAA4000000048A0000040AA0
- 44448A0AAAA4000040488A000004000044888A0AA0A4444448888A0000A0A888
- 88888A0000AA888888888AAAAAA8888888888888888888888888}
- ParentShowHint = False
- ShowHint = True
- OnClick = Copy1Click
- end
- object tbbPaste: TSpeedButton
- Left = 112
- Top = 2
- Width = 21
- Height = 22
- Hint = 'Paste from Clipboard'
- Flat = True
- Glyph.Data = {
- F6000000424DF600000000000000760000002800000010000000100000000100
- 0400000000008000000000000000000000001000000010000000FFFFFF000000
- 8000008000000080800080000000800080008080000080808000C0C0C0000000
- FF000000000000FFFF00FF000000FF00FF00FFFF000000666600888888888888
- 888888888844444444448AAAAA4000000004A7373740AAAAAA04A37373400000
- 0004A7373740AAA04444A373734000004048A737374000004488A37373444444
- 4A88A737373737373A88A30AAAAAAAA77A88A77A888888A73A88A373ABAABA73
- 7A888AAAAABBAAAAA88888888AAAA88888888888888888888888}
- ParentShowHint = False
- ShowHint = True
- OnClick = Paste1Click
- end
- object ToolButton2: TToolButton
- Left = 133
- Top = 2
- Width = 6
- Caption = 'ToolButton2'
- ImageIndex = 1
- Style = tbsDivider
- end
- object tbbSQL: TSpeedButton
- Left = 139
- Top = 2
- Width = 20
- Height = 22
- Hint = 'Show and Edit SQL'
- Flat = True
- Glyph.Data = {
- 4E010000424D4E01000000000000760000002800000012000000120000000100
- 040000000000D800000000000000000000001000000010000000000000000000
- 8000008000000080800080000000800080008080000080808000C0C0C0000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00EEEEEEEEEEEE
- EEEEEE000000E0000000000000000E000000E0FFF0FFFFF0FFFF0E000000E0FF
- F0FFFFF0FFFF0E000000E0F4F0F444F0F44F0E000000E0FFF8FFFFF8FFFF0E00
- 0000E0F991FF9998999F0E000000E0FFF1F9F9F89FFF0E000000E0FF98F9FF98
- 9FFF0E000000E0F9F8F9FF989FFF0E000000E0F191FF99F89FFF0E000000E0FF
- F8FFFFF8FFFF0E000000E0F4F0F444F0F44F0E000000E0FFF0FFFFF0FFFF0E00
- 0000E0000000000000000E000000E0666666666666660E000000E00000000000
- 00000E000000EEEEEEEEEEEEEEEEEE000000}
- ParentShowHint = False
- ShowHint = True
- OnClick = ShowSQL1Click
- end
- object tbbRun: TSpeedButton
- Left = 159
- Top = 2
- Width = 22
- Height = 22
- Hint = 'Execute Query'
- Flat = True
- Glyph.Data = {
- F6000000424DF600000000000000760000002800000010000000100000000100
- 0400000000008000000000000000000000001000000010000000000000000000
- 8000008000000080800080000000800080008080000080808000C0C0C0000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00EEEEE0EEEEEE
- EEEEEEEEE70EEEEEEEEEEEEEEE00EEEEEEEEEEEEEE0B0EEEEEEEEEEE0000B0EE
- EEEEEEEE0BBBBB0EEEEEEEEEE0FB0000EEEEEEEEE0BBB0EEEEEEEE00000BFB0E
- EEEEEE0FBBBFBBB0EEEEEEE0FBFB00000EEEEEE0BFBFB0EEEEEEEEEE0BFBFB0E
- EEEEEEEE0FFFFFF0EEEEEEEEE0FBFFBF0EEEEEEEE000000000EE}
- ParentShowHint = False
- ShowHint = True
- OnClick = RnQuery1Click
- end
- object ToolButton1: TToolButton
- Left = 181
- Top = 2
- Width = 6
- Caption = 'ToolButton1'
- ImageIndex = 0
- Style = tbsDivider
- end
- object Label2: TLabel
- Left = 187
- Top = 2
- Width = 27
- Height = 22
- Alignment = taRightJustify
- Caption = '&Table'
- FocusControl = tblList
- Layout = tlCenter
- end
- object ToolButton5: TToolButton
- Left = 214
- Top = 2
- Width = 8
- Caption = 'ToolButton5'
- ImageIndex = 2
- Style = tbsSeparator
- end
- object tblList: TComboBox
- Left = 222
- Top = 2
- Width = 126
- Height = 21
- Hint = 'Add a table from this list'
- ItemHeight = 13
- Sorted = True
- TabOrder = 1
- OnClick = handleClick
- OnEnter = handleEnter
- OnExit = handleExit
- OnKeyDown = tblListKeyDown
- OnKeyPress = handleKeyPress
- end
- object ToolButton4: TToolButton
- Left = 348
- Top = 2
- Width = 9
- Caption = 'ToolButton4'
- ImageIndex = 1
- Style = tbsSeparator
- end
- object Label1: TLabel
- Left = 357
- Top = 2
- Width = 49
- Height = 22
- Alignment = taRightJustify
- Caption = '&Database '
- FocusControl = comboDatabase
- Layout = tlCenter
- end
- object ToolButton6: TToolButton
- Left = 406
- Top = 2
- Width = 7
- Caption = 'ToolButton6'
- ImageIndex = 2
- Style = tbsSeparator
- end
- object comboDatabase: TComboBox
- Left = 413
- Top = 2
- Width = 109
- Height = 21
- Hint = 'Select a Database'
- ItemHeight = 13
- Sorted = True
- TabOrder = 0
- OnClick = handleClick
- OnEnter = handleEnter
- OnExit = handleExit
- OnKeyDown = tblListKeyDown
- OnKeyPress = handleKeyPress
- end
- end
- object MainMenu1: TMainMenu
- Left = 12
- Top = 38
- object File1: TMenuItem
- Caption = '&File'
- object New1: TMenuItem
- Caption = '&New'
- ShortCut = 16462
- OnClick = New1Click
- end
- object Open1: TMenuItem
- Caption = '&Import from file...'
- ShortCut = 16457
- OnClick = Open1Click
- end
- object SaveAs1: TMenuItem
- Caption = '&Export to file...'
- ShortCut = 16453
- OnClick = SaveAs1Click
- end
- object ReverttoOriginal1: TMenuItem
- Caption = '&Revert to saved'
- ShortCut = 16466
- OnClick = ReverttoOriginal1Click
- end
- object N1: TMenuItem
- Caption = '-'
- end
- object Exit1: TMenuItem
- Caption = 'E&xit'
- OnClick = Exit1Click
- end
- end
- object Edit1: TMenuItem
- Caption = '&Edit'
- object Cut1: TMenuItem
- Caption = 'Cu&t'
- ShortCut = 16472
- OnClick = Cut1Click
- end
- object Copy1: TMenuItem
- Caption = '&Copy'
- ShortCut = 16451
- OnClick = Copy1Click
- end
- object Paste1: TMenuItem
- Caption = '&Paste'
- ShortCut = 16470
- OnClick = Paste1Click
- end
- end
- object mnuQuery: TMenuItem
- Caption = '&Query'
- object RnQuery1: TMenuItem
- Caption = '&Run Query'
- ShortCut = 120
- OnClick = RnQuery1Click
- end
- object ShowSQL1: TMenuItem
- Caption = '&Show SQL'
- ShortCut = 118
- OnClick = ShowSQL1Click
- end
- end
- object Help1: TMenuItem
- Caption = '&Help'
- object Contents1: TMenuItem
- Caption = '&Contents'
- ShortCut = 112
- OnClick = Contents1Click
- end
- end
- end
- object db: TDatabase
- SessionName = 'Default'
- Left = 11
- Top = 71
- end
- object DirBrowser: TOpenDialog
- Options = [ofHideReadOnly, ofPathMustExist, ofNoReadOnlyReturn]
- Title = 'Select a directory'
- Left = 13
- Top = 103
- end
- object ImageList1: TImageList
- Left = 182
- Top = 53
- end
- object OpenDialog1: TOpenDialog
- Left = 104
- Top = 96
- end
- end
-