| 1 |
< |
object IBModifySQLEditorForm: TIBModifySQLEditorForm |
| 2 |
< |
Left = 508 |
| 3 |
< |
Height = 438 |
| 4 |
< |
Top = 250 |
| 5 |
< |
Width = 749 |
| 1 |
> |
inherited IBModifySQLEditorForm: TIBModifySQLEditorForm |
| 2 |
> |
Left = 1041 |
| 3 |
> |
Height = 512 |
| 4 |
> |
Top = 330 |
| 5 |
|
Caption = 'Modify SQL Editor' |
| 6 |
< |
ClientHeight = 438 |
| 7 |
< |
ClientWidth = 749 |
| 8 |
< |
OnShow = FormShow |
| 9 |
< |
Position = poScreenCenter |
| 10 |
< |
LCLVersion = '1.8.0.4' |
| 11 |
< |
object Label3: TLabel |
| 13 |
< |
Left = 279 |
| 14 |
< |
Height = 14 |
| 15 |
< |
Top = 16 |
| 16 |
< |
Width = 24 |
| 17 |
< |
Caption = 'SQL' |
| 18 |
< |
ParentColor = False |
| 19 |
< |
end |
| 20 |
< |
object SQLText: TMemo |
| 21 |
< |
Left = 279 |
| 22 |
< |
Height = 328 |
| 23 |
< |
Top = 36 |
| 24 |
< |
Width = 439 |
| 25 |
< |
Anchors = [akTop, akLeft, akRight, akBottom] |
| 26 |
< |
ScrollBars = ssAutoBoth |
| 27 |
< |
TabOrder = 0 |
| 6 |
> |
ClientHeight = 512 |
| 7 |
> |
inherited Button1: TButton |
| 8 |
> |
Top = 457 |
| 9 |
> |
end |
| 10 |
> |
inherited Button2: TButton |
| 11 |
> |
Top = 457 |
| 12 |
|
end |
| 13 |
< |
object Button1: TButton |
| 14 |
< |
Left = 552 |
| 31 |
< |
Height = 30 |
| 32 |
< |
Top = 379 |
| 33 |
< |
Width = 72 |
| 34 |
< |
Anchors = [akRight, akBottom] |
| 35 |
< |
Caption = 'OK' |
| 36 |
< |
Default = True |
| 37 |
< |
ModalResult = 1 |
| 38 |
< |
TabOrder = 1 |
| 39 |
< |
end |
| 40 |
< |
object Button2: TButton |
| 41 |
< |
Left = 640 |
| 42 |
< |
Height = 30 |
| 43 |
< |
Top = 380 |
| 44 |
< |
Width = 72 |
| 45 |
< |
Anchors = [akRight, akBottom] |
| 46 |
< |
Cancel = True |
| 47 |
< |
Caption = 'Cancel' |
| 48 |
< |
ModalResult = 2 |
| 49 |
< |
TabOrder = 2 |
| 50 |
< |
end |
| 51 |
< |
object GenerateBtn: TButton |
| 52 |
< |
Left = 280 |
| 53 |
< |
Height = 30 |
| 54 |
< |
Top = 380 |
| 55 |
< |
Width = 101 |
| 56 |
< |
Anchors = [akRight, akBottom] |
| 57 |
< |
Caption = 'Generate SQL' |
| 13 |
> |
inherited GenerateBtn: TButton |
| 14 |
> |
Top = 457 |
| 15 |
|
OnClick = GenerateBtnClick |
| 59 |
– |
TabOrder = 3 |
| 16 |
|
end |
| 17 |
< |
object TestBtn: TButton |
| 18 |
< |
Left = 416 |
| 63 |
< |
Height = 30 |
| 64 |
< |
Top = 380 |
| 65 |
< |
Width = 66 |
| 66 |
< |
Anchors = [akRight, akBottom] |
| 67 |
< |
Caption = 'Test' |
| 68 |
< |
OnClick = TestBtnClick |
| 69 |
< |
TabOrder = 4 |
| 17 |
> |
inherited TestBtn: TButton |
| 18 |
> |
Top = 457 |
| 19 |
|
end |
| 20 |
< |
object QuoteFields: TCheckBox |
| 21 |
< |
Left = 16 |
| 22 |
< |
Height = 22 |
| 74 |
< |
Top = 400 |
| 75 |
< |
Width = 125 |
| 76 |
< |
Caption = '&Quote Identifiers' |
| 77 |
< |
TabOrder = 5 |
| 78 |
< |
end |
| 79 |
< |
object GenerateParams: TCheckBox |
| 80 |
< |
Left = 16 |
| 81 |
< |
Height = 22 |
| 82 |
< |
Top = 376 |
| 83 |
< |
Width = 171 |
| 84 |
< |
Caption = 'Allow DSQL Placeholders' |
| 85 |
< |
TabOrder = 6 |
| 86 |
< |
end |
| 87 |
< |
object PageControl: TPageControl |
| 88 |
< |
Left = 18 |
| 89 |
< |
Height = 346 |
| 90 |
< |
Top = 18 |
| 91 |
< |
Width = 238 |
| 92 |
< |
ActivePage = ExecutePage |
| 93 |
< |
TabIndex = 1 |
| 94 |
< |
TabOrder = 7 |
| 95 |
< |
object ModifyPage: TTabSheet |
| 96 |
< |
Caption = 'Update' |
| 97 |
< |
ClientHeight = 314 |
| 98 |
< |
ClientWidth = 232 |
| 99 |
< |
OnShow = ModifyPageShow |
| 100 |
< |
object Label1: TLabel |
| 101 |
< |
Left = 8 |
| 102 |
< |
Height = 15 |
| 103 |
< |
Top = 8 |
| 104 |
< |
Width = 69 |
| 105 |
< |
Caption = 'Table Name' |
| 106 |
< |
ParentColor = False |
| 107 |
< |
end |
| 108 |
< |
object TableNamesCombo: TComboBox |
| 109 |
< |
Left = 8 |
| 110 |
< |
Height = 27 |
| 111 |
< |
Top = 22 |
| 112 |
< |
Width = 201 |
| 113 |
< |
AutoComplete = True |
| 114 |
< |
AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 115 |
< |
ItemHeight = 0 |
| 116 |
< |
OnCloseUp = TableNamesComboCloseUp |
| 117 |
< |
TabOrder = 0 |
| 118 |
< |
end |
| 119 |
< |
object Label2: TLabel |
| 120 |
< |
Left = 8 |
| 121 |
< |
Height = 15 |
| 122 |
< |
Top = 56 |
| 123 |
< |
Width = 33 |
| 124 |
< |
Caption = 'Fields' |
| 125 |
< |
ParentColor = False |
| 126 |
< |
end |
| 127 |
< |
object FieldList: TListBox |
| 128 |
< |
Left = 8 |
| 129 |
< |
Height = 120 |
| 130 |
< |
Hint = 'Select Fields to include in Update Statement, or leave unselected to select all' |
| 131 |
< |
Top = 72 |
| 132 |
< |
Width = 200 |
| 133 |
< |
ItemHeight = 0 |
| 134 |
< |
MultiSelect = True |
| 135 |
< |
OnDblClick = FieldListDblClick |
| 136 |
< |
ParentShowHint = False |
| 137 |
< |
ScrollWidth = 198 |
| 138 |
< |
ShowHint = True |
| 139 |
< |
TabOrder = 1 |
| 140 |
< |
TopIndex = -1 |
| 141 |
< |
end |
| 142 |
< |
object IncludePrimaryKeys: TCheckBox |
| 143 |
< |
Left = 8 |
| 144 |
< |
Height = 22 |
| 145 |
< |
Top = 200 |
| 146 |
< |
Width = 221 |
| 147 |
< |
Caption = 'Include Primary keys in Field List' |
| 148 |
< |
Checked = True |
| 149 |
< |
OnClick = TableNamesComboCloseUp |
| 150 |
< |
State = cbChecked |
| 151 |
< |
TabOrder = 2 |
| 152 |
< |
end |
| 153 |
< |
object Label4: TLabel |
| 154 |
< |
Left = 8 |
| 155 |
< |
Height = 15 |
| 156 |
< |
Top = 229 |
| 157 |
< |
Width = 77 |
| 158 |
< |
Caption = 'Primary Keys' |
| 159 |
< |
ParentColor = False |
| 160 |
< |
end |
| 161 |
< |
object PrimaryKeyList: TListBox |
| 162 |
< |
Left = 8 |
| 163 |
< |
Height = 59 |
| 164 |
< |
Top = 248 |
| 165 |
< |
Width = 200 |
| 166 |
< |
ItemHeight = 0 |
| 167 |
< |
OnDblClick = PrimaryKeyListDblClick |
| 168 |
< |
ScrollWidth = 198 |
| 169 |
< |
TabOrder = 3 |
| 170 |
< |
TopIndex = -1 |
| 171 |
< |
end |
| 172 |
< |
end |
| 173 |
< |
object ExecutePage: TTabSheet |
| 174 |
< |
Caption = 'Execute' |
| 175 |
< |
ClientHeight = 314 |
| 176 |
< |
ClientWidth = 232 |
| 177 |
< |
OnShow = ExecutePageShow |
| 178 |
< |
object Label16: TLabel |
| 20 |
> |
inherited PageControl: TPageControl |
| 21 |
> |
inherited SelectPage: TTabSheet |
| 22 |
> |
inherited Label2: TLabel |
| 23 |
|
Left = 7 |
| 24 |
< |
Height = 14 |
| 25 |
< |
Top = 8 |
| 26 |
< |
Width = 100 |
| 183 |
< |
Caption = 'Procedure Name' |
| 184 |
< |
ParentColor = False |
| 24 |
> |
Top = 224 |
| 25 |
> |
Width = 106 |
| 26 |
> |
Caption = 'Updateable Fields' |
| 27 |
|
end |
| 28 |
< |
object ProcedureNames: TComboBox |
| 28 |
> |
inherited Label4: TLabel |
| 29 |
|
Left = 7 |
| 188 |
– |
Height = 27 |
| 189 |
– |
Top = 24 |
| 190 |
– |
Width = 201 |
| 191 |
– |
ItemHeight = 0 |
| 192 |
– |
OnCloseUp = ProcedureNamesCloseUp |
| 193 |
– |
ParentColor = True |
| 194 |
– |
TabOrder = 0 |
| 30 |
|
end |
| 31 |
< |
object Label17: TLabel |
| 32 |
< |
Left = 7 |
| 33 |
< |
Height = 14 |
| 199 |
< |
Top = 56 |
| 200 |
< |
Width = 104 |
| 201 |
< |
Caption = 'Input Parameters' |
| 202 |
< |
ParentColor = False |
| 31 |
> |
inherited FieldNamesGrid: TIBDynamicGrid |
| 32 |
> |
Height = 104 |
| 33 |
> |
Top = 240 |
| 34 |
|
end |
| 35 |
< |
object ProcInputList: TListBox |
| 36 |
< |
Left = 8 |
| 206 |
< |
Height = 103 |
| 207 |
< |
Top = 72 |
| 208 |
< |
Width = 198 |
| 209 |
< |
IntegralHeight = True |
| 210 |
< |
ItemHeight = 0 |
| 211 |
< |
ScrollWidth = 196 |
| 212 |
< |
TabOrder = 1 |
| 213 |
< |
TopIndex = -1 |
| 35 |
> |
inherited PrimaryKeysGrid: TIBDynamicGrid |
| 36 |
> |
Height = 48 |
| 37 |
|
end |
| 38 |
< |
object ProcOutputList: TListBox |
| 39 |
< |
Left = 7 |
| 217 |
< |
Height = 80 |
| 218 |
< |
Top = 200 |
| 219 |
< |
Width = 198 |
| 220 |
< |
IntegralHeight = True |
| 221 |
< |
ItemHeight = 0 |
| 222 |
< |
ScrollWidth = 196 |
| 223 |
< |
TabOrder = 2 |
| 224 |
< |
TopIndex = -1 |
| 38 |
> |
inherited SelectSelectAll: TCheckBox |
| 39 |
> |
Top = 344 |
| 40 |
|
end |
| 41 |
< |
object Label18: TLabel |
| 42 |
< |
Left = 7 |
| 41 |
> |
object Label5: TLabel[8] |
| 42 |
> |
Left = 9 |
| 43 |
|
Height = 14 |
| 44 |
< |
Top = 184 |
| 45 |
< |
Width = 114 |
| 46 |
< |
Caption = 'Output Parameters' |
| 47 |
< |
ParentColor = False |
| 44 |
> |
Top = 152 |
| 45 |
> |
Width = 138 |
| 46 |
> |
Caption = 'Computed By Columns' |
| 47 |
> |
ParentColor = False |
| 48 |
> |
end |
| 49 |
> |
object ReadOnlyGrid: TIBDynamicGrid[9] |
| 50 |
> |
Left = 9 |
| 51 |
> |
Height = 48 |
| 52 |
> |
Top = 168 |
| 53 |
> |
Width = 209 |
| 54 |
> |
Color = clWindow |
| 55 |
> |
Columns = < |
| 56 |
> |
item |
| 57 |
> |
ButtonStyle = cbsCheckboxColumn |
| 58 |
> |
Title.Caption = 'SELECTED' |
| 59 |
> |
Width = 30 |
| 60 |
> |
FieldName = 'SELECTED' |
| 61 |
> |
AutoSizeColumn = False |
| 62 |
> |
InitialSortColumn = False |
| 63 |
> |
DBLookupProperties.ItemHeight = 0 |
| 64 |
> |
DBLookupProperties.ItemWidth = 0 |
| 65 |
> |
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 66 |
> |
end |
| 67 |
> |
item |
| 68 |
> |
Title.Caption = 'COLUMNNAME' |
| 69 |
> |
Width = 64 |
| 70 |
> |
FieldName = 'COLUMNNAME' |
| 71 |
> |
AutoSizeColumn = True |
| 72 |
> |
InitialSortColumn = False |
| 73 |
> |
DBLookupProperties.ItemHeight = 0 |
| 74 |
> |
DBLookupProperties.ItemWidth = 0 |
| 75 |
> |
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 76 |
> |
end> |
| 77 |
> |
FixedCols = 0 |
| 78 |
> |
Options = [dgEditing, dgColumnResize, dgColumnMove, dgRowLines, dgConfirmDelete, dgCancelOnExit, dgDisableDelete, dgDisableInsert] |
| 79 |
> |
Scrollbars = ssAutoVertical |
| 80 |
> |
TabOrder = 5 |
| 81 |
> |
ExpandEditorPanelBelowRow = False |
| 82 |
> |
Descending = False |
| 83 |
> |
EditorBorderStyle = bsSingle |
| 84 |
> |
DefaultPositionAtEnd = False |
| 85 |
|
end |
| 86 |
< |
object ExecuteOnlyIndicator: TLabel |
| 86 |
> |
end |
| 87 |
> |
inherited ExecutePage: TTabSheet |
| 88 |
> |
inherited Label18: TLabel |
| 89 |
> |
Top = 240 |
| 90 |
> |
end |
| 91 |
> |
inherited InputProcGrid: TIBDynamicGrid |
| 92 |
> |
Height = 107 |
| 93 |
> |
end |
| 94 |
> |
inherited OutputProcGrid: TIBDynamicGrid |
| 95 |
|
Left = 10 |
| 96 |
< |
Height = 14 |
| 97 |
< |
Top = 293 |
| 98 |
< |
Width = 89 |
| 99 |
< |
Caption = 'Execute Only' |
| 100 |
< |
Font.Style = [fsBold] |
| 101 |
< |
ParentColor = False |
| 102 |
< |
ParentFont = False |
| 103 |
< |
Visible = False |
| 96 |
> |
Height = 112 |
| 97 |
> |
Top = 256 |
| 98 |
> |
Columns = < |
| 99 |
> |
item |
| 100 |
> |
ButtonStyle = cbsCheckboxColumn |
| 101 |
> |
PickList.Strings = ( ) |
| 102 |
> |
Title.Caption = 'SELECTED' |
| 103 |
> |
Width = 30 |
| 104 |
> |
FieldName = 'SELECTED' |
| 105 |
> |
AutoSizeColumn = False |
| 106 |
> |
InitialSortColumn = False |
| 107 |
> |
DBLookupProperties.ItemHeight = 0 |
| 108 |
> |
DBLookupProperties.ItemWidth = 0 |
| 109 |
> |
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 110 |
> |
end |
| 111 |
> |
item |
| 112 |
> |
PickList.Strings = ( ) |
| 113 |
> |
Title.Caption = 'COLUMNNAME' |
| 114 |
> |
Width = 0 |
| 115 |
> |
Visible = False |
| 116 |
> |
FieldName = 'COLUMNNAME' |
| 117 |
> |
AutoSizeColumn = True |
| 118 |
> |
InitialSortColumn = False |
| 119 |
> |
DBLookupProperties.ItemHeight = 0 |
| 120 |
> |
DBLookupProperties.ItemWidth = 0 |
| 121 |
> |
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 122 |
> |
end> |
| 123 |
|
end |
| 124 |
|
end |
| 125 |
|
end |
| 126 |
< |
object IBTransaction1: TIBTransaction |
| 127 |
< |
Active = False |
| 128 |
< |
left = 209 |
| 129 |
< |
top = 388 |
| 126 |
> |
inherited IBSQLEditFrame1: TIBSQLEditFrame |
| 127 |
> |
Left = 282 |
| 128 |
> |
Height = 389 |
| 129 |
> |
Top = 24 |
| 130 |
> |
Width = 448 |
| 131 |
> |
Anchors = [akTop, akLeft, akRight, akBottom] |
| 132 |
> |
ClientHeight = 389 |
| 133 |
> |
ClientWidth = 448 |
| 134 |
> |
TabOrder = 7 |
| 135 |
> |
DesignLeft = 1974 |
| 136 |
> |
DesignTop = 200 |
| 137 |
> |
inherited SQLText: TSynEdit |
| 138 |
> |
Height = 363 |
| 139 |
> |
Width = 448 |
| 140 |
> |
end |
| 141 |
> |
inherited ToolBar1: TToolBar |
| 142 |
> |
Width = 448 |
| 143 |
> |
end |
| 144 |
> |
inherited FieldNameList: TIBQuery |
| 145 |
> |
ParamData = < |
| 146 |
> |
item |
| 147 |
> |
DataType = ftUnknown |
| 148 |
> |
Name = 'RDB$RELATION_NAME' |
| 149 |
> |
ParamType = ptInput |
| 150 |
> |
end> |
| 151 |
> |
end |
| 152 |
> |
inherited PrimaryKeys: TIBQuery |
| 153 |
> |
ParamData = < |
| 154 |
> |
item |
| 155 |
> |
DataType = ftUnknown |
| 156 |
> |
Name = 'RDB$RELATION_NAME' |
| 157 |
> |
ParamType = ptInput |
| 158 |
> |
end> |
| 159 |
> |
end |
| 160 |
> |
inherited ProcInputParams: TIBQuery |
| 161 |
> |
ParamData = < |
| 162 |
> |
item |
| 163 |
> |
DataType = ftUnknown |
| 164 |
> |
Name = 'RDB$PROCEDURE_NAME' |
| 165 |
> |
ParamType = ptInput |
| 166 |
> |
end> |
| 167 |
> |
end |
| 168 |
> |
inherited ProcOutputParams: TIBQuery |
| 169 |
> |
ParamData = < |
| 170 |
> |
item |
| 171 |
> |
DataType = ftUnknown |
| 172 |
> |
Name = 'RDB$PROCEDURE_NAME' |
| 173 |
> |
ParamType = ptInput |
| 174 |
> |
end> |
| 175 |
> |
end |
| 176 |
> |
inherited SQLTransaction: TIBTransaction |
| 177 |
> |
Params.Strings = ( ) |
| 178 |
> |
end |
| 179 |
> |
inherited IdentityCols: TIBQuery |
| 180 |
> |
ParamData = < |
| 181 |
> |
item |
| 182 |
> |
DataType = ftUnknown |
| 183 |
> |
Name = 'RDB$RELATION_NAME' |
| 184 |
> |
ParamType = ptInput |
| 185 |
> |
end> |
| 186 |
> |
end |
| 187 |
> |
inherited ReadOnlyFields: TIBQuery |
| 188 |
> |
ParamData = < |
| 189 |
> |
item |
| 190 |
> |
DataType = ftUnknown |
| 191 |
> |
Name = 'RDB$RELATION_NAME' |
| 192 |
> |
ParamType = ptInput |
| 193 |
> |
end> |
| 194 |
> |
end |
| 195 |
> |
inherited ReadOnlyFieldsSource: TDataSource |
| 196 |
> |
left = 436 |
| 197 |
> |
top = 203 |
| 198 |
> |
end |
| 199 |
> |
inherited PackageNames: TIBQuery |
| 200 |
> |
BeforeClose = nil |
| 201 |
> |
end |
| 202 |
> |
end |
| 203 |
> |
object IncludePrimaryKeys: TCheckBox[9] |
| 204 |
> |
Left = 24 |
| 205 |
> |
Height = 22 |
| 206 |
> |
Top = 465 |
| 207 |
> |
Width = 241 |
| 208 |
> |
Caption = 'Include Primary keys in Update SQL' |
| 209 |
> |
TabOrder = 8 |
| 210 |
|
end |
| 211 |
|
end |
