| 1 |
|
object IBDataSetEditorForm: TIBDataSetEditorForm |
| 2 |
< |
Left = 475 |
| 2 |
> |
Left = 442 |
| 3 |
|
Height = 410 |
| 4 |
< |
Top = 327 |
| 4 |
> |
Top = 421 |
| 5 |
|
Width = 662 |
| 6 |
|
ActiveControl = PageControl |
| 7 |
|
BorderIcons = [biSystemMenu] |
| 11 |
|
ClientWidth = 662 |
| 12 |
|
OnClose = FormClose |
| 13 |
|
OnShow = FormShow |
| 14 |
< |
LCLVersion = '0.9.30' |
| 14 |
> |
Position = poScreenCenter |
| 15 |
> |
LCLVersion = '1.8.1.0' |
| 16 |
|
object PageControl: TPageControl |
| 17 |
|
Left = 8 |
| 18 |
|
Height = 352 |
| 19 |
|
Top = 8 |
| 20 |
|
Width = 641 |
| 21 |
< |
ActivePage = SQLPage |
| 21 |
> |
ActivePage = FieldsPage |
| 22 |
|
Anchors = [akTop, akLeft, akRight, akBottom] |
| 23 |
< |
TabIndex = 1 |
| 23 |
> |
TabIndex = 0 |
| 24 |
|
TabOrder = 0 |
| 25 |
|
object FieldsPage: TTabSheet |
| 26 |
|
Caption = 'Options' |
| 27 |
< |
ClientHeight = 317 |
| 27 |
> |
ClientHeight = 320 |
| 28 |
|
ClientWidth = 635 |
| 29 |
|
object GroupBox1: TGroupBox |
| 30 |
|
Left = 8 |
| 31 |
< |
Height = 312 |
| 31 |
> |
Height = 315 |
| 32 |
|
Top = 4 |
| 33 |
|
Width = 617 |
| 34 |
|
Anchors = [akTop, akLeft, akRight, akBottom] |
| 35 |
|
Caption = ' SQL Generation ' |
| 36 |
< |
ClientHeight = 293 |
| 37 |
< |
ClientWidth = 613 |
| 36 |
> |
ClientHeight = 300 |
| 37 |
> |
ClientWidth = 615 |
| 38 |
|
TabOrder = 0 |
| 39 |
|
object Label1: TLabel |
| 40 |
|
Left = 12 |
| 41 |
< |
Height = 18 |
| 41 |
> |
Height = 14 |
| 42 |
|
Top = 18 |
| 43 |
< |
Width = 82 |
| 43 |
> |
Width = 73 |
| 44 |
|
Caption = 'Table &Name:' |
| 44 |
– |
FocusControl = TableNamesCombo |
| 45 |
|
ParentColor = False |
| 46 |
|
end |
| 47 |
|
object Label3: TLabel |
| 48 |
< |
Left = 315 |
| 49 |
< |
Height = 18 |
| 50 |
< |
Top = 18 |
| 51 |
< |
Width = 71 |
| 48 |
> |
Left = 288 |
| 49 |
> |
Height = 14 |
| 50 |
> |
Top = 16 |
| 51 |
> |
Width = 62 |
| 52 |
|
Caption = '&Key Fields:' |
| 53 |
– |
FocusControl = PrimaryKeyList |
| 53 |
|
ParentColor = False |
| 54 |
|
end |
| 55 |
|
object Label4: TLabel |
| 56 |
|
Left = 458 |
| 57 |
< |
Height = 18 |
| 57 |
> |
Height = 14 |
| 58 |
|
Top = 18 |
| 59 |
< |
Width = 94 |
| 59 |
> |
Width = 85 |
| 60 |
|
Caption = 'Update &Fields:' |
| 62 |
– |
FocusControl = FieldList |
| 61 |
|
ParentColor = False |
| 62 |
|
end |
| 65 |
– |
object TableNamesCombo: TComboBox |
| 66 |
– |
Left = 9 |
| 67 |
– |
Height = 29 |
| 68 |
– |
Top = 35 |
| 69 |
– |
Width = 171 |
| 70 |
– |
ItemHeight = 0 |
| 71 |
– |
OnCloseUp = TableNamesComboCloseUp |
| 72 |
– |
TabOrder = 0 |
| 73 |
– |
end |
| 74 |
– |
object PrimaryKeyList: TListBox |
| 75 |
– |
Left = 315 |
| 76 |
– |
Height = 232 |
| 77 |
– |
Top = 35 |
| 78 |
– |
Width = 136 |
| 79 |
– |
Anchors = [akTop, akLeft, akBottom] |
| 80 |
– |
ItemHeight = 0 |
| 81 |
– |
MultiSelect = True |
| 82 |
– |
TabOrder = 3 |
| 83 |
– |
TopIndex = -1 |
| 84 |
– |
end |
| 85 |
– |
object FieldList: TListBox |
| 86 |
– |
Left = 458 |
| 87 |
– |
Height = 232 |
| 88 |
– |
Hint = 'Select Fields to include in Update Statements, or leave unselected to select all' |
| 89 |
– |
Top = 35 |
| 90 |
– |
Width = 136 |
| 91 |
– |
Anchors = [akTop, akLeft, akBottom] |
| 92 |
– |
ItemHeight = 0 |
| 93 |
– |
MultiSelect = True |
| 94 |
– |
ParentShowHint = False |
| 95 |
– |
ShowHint = True |
| 96 |
– |
TabOrder = 4 |
| 97 |
– |
TopIndex = -1 |
| 98 |
– |
end |
| 63 |
|
object GenerateButton: TButton |
| 64 |
|
Left = 9 |
| 65 |
|
Height = 25 |
| 67 |
|
Width = 168 |
| 68 |
|
Caption = '&Generate SQL' |
| 69 |
|
OnClick = GenerateButtonClick |
| 70 |
< |
TabOrder = 1 |
| 70 |
> |
TabOrder = 0 |
| 71 |
|
end |
| 72 |
|
object QuoteFields: TCheckBox |
| 73 |
|
Left = 9 |
| 74 |
|
Height = 22 |
| 75 |
< |
Top = 131 |
| 76 |
< |
Width = 132 |
| 75 |
> |
Top = 160 |
| 76 |
> |
Width = 125 |
| 77 |
|
Caption = '&Quote Identifiers' |
| 78 |
< |
TabOrder = 2 |
| 78 |
> |
TabOrder = 1 |
| 79 |
|
end |
| 80 |
|
object IncludePrimaryKeys: TCheckBox |
| 81 |
+ |
Left = 9 |
| 82 |
+ |
Height = 22 |
| 83 |
+ |
Top = 192 |
| 84 |
+ |
Width = 241 |
| 85 |
+ |
Caption = 'Include Primary keys in Update SQL' |
| 86 |
+ |
TabOrder = 2 |
| 87 |
+ |
end |
| 88 |
+ |
object GenerateParams: TCheckBox |
| 89 |
+ |
Left = 9 |
| 90 |
+ |
Height = 22 |
| 91 |
+ |
Top = 128 |
| 92 |
+ |
Width = 171 |
| 93 |
+ |
Caption = 'Allow DSQL Placeholders' |
| 94 |
+ |
TabOrder = 3 |
| 95 |
+ |
end |
| 96 |
+ |
object SelectTableNames: TIBLookupComboEditBox |
| 97 |
|
Left = 12 |
| 98 |
+ |
Height = 27 |
| 99 |
+ |
Top = 32 |
| 100 |
+ |
Width = 209 |
| 101 |
+ |
OwnerDrawEditable = False |
| 102 |
+ |
KeyField = 'RDB$RELATION_ID' |
| 103 |
+ |
ListField = 'RDB$RELATION_NAME' |
| 104 |
+ |
ListFieldIndex = 0 |
| 105 |
+ |
LookupCache = False |
| 106 |
+ |
ScrollListDataset = True |
| 107 |
+ |
TabOrder = 4 |
| 108 |
+ |
AutoInsert = False |
| 109 |
+ |
AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 110 |
+ |
ItemHeight = 0 |
| 111 |
+ |
end |
| 112 |
+ |
object IncludeSysTables: TCheckBox |
| 113 |
+ |
Left = 13 |
| 114 |
|
Height = 22 |
| 115 |
< |
Top = 163 |
| 116 |
< |
Width = 239 |
| 117 |
< |
Caption = 'Include Primary keys in Field List' |
| 118 |
< |
Checked = True |
| 123 |
< |
OnClick = TableNamesComboCloseUp |
| 124 |
< |
State = cbChecked |
| 115 |
> |
Top = 59 |
| 116 |
> |
Width = 158 |
| 117 |
> |
Caption = 'Include System Tables' |
| 118 |
> |
OnChange = IncludeSysTablesChange |
| 119 |
|
TabOrder = 5 |
| 120 |
|
end |
| 121 |
+ |
object PrimaryKeysGrid: TIBDynamicGrid |
| 122 |
+ |
Left = 288 |
| 123 |
+ |
Height = 181 |
| 124 |
+ |
Top = 35 |
| 125 |
+ |
Width = 144 |
| 126 |
+ |
Color = clWindow |
| 127 |
+ |
Columns = < |
| 128 |
+ |
item |
| 129 |
+ |
ButtonStyle = cbsCheckboxColumn |
| 130 |
+ |
Title.Caption = 'SELECTED' |
| 131 |
+ |
Width = 30 |
| 132 |
+ |
FieldName = 'SELECTED' |
| 133 |
+ |
AutoSizeColumn = False |
| 134 |
+ |
InitialSortColumn = False |
| 135 |
+ |
DBLookupProperties.ItemHeight = 0 |
| 136 |
+ |
DBLookupProperties.ItemWidth = 0 |
| 137 |
+ |
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 138 |
+ |
end |
| 139 |
+ |
item |
| 140 |
+ |
Title.Caption = 'COLUMNNAME' |
| 141 |
+ |
Width = 64 |
| 142 |
+ |
FieldName = 'COLUMNNAME' |
| 143 |
+ |
AutoSizeColumn = True |
| 144 |
+ |
InitialSortColumn = False |
| 145 |
+ |
DBLookupProperties.ItemHeight = 0 |
| 146 |
+ |
DBLookupProperties.ItemWidth = 0 |
| 147 |
+ |
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 148 |
+ |
end> |
| 149 |
+ |
FixedCols = 0 |
| 150 |
+ |
Options = [dgEditing, dgColumnResize, dgColumnMove, dgRowLines, dgConfirmDelete, dgCancelOnExit, dgDisableDelete, dgDisableInsert] |
| 151 |
+ |
Scrollbars = ssAutoVertical |
| 152 |
+ |
TabOrder = 6 |
| 153 |
+ |
ExpandEditorPanelBelowRow = False |
| 154 |
+ |
Descending = False |
| 155 |
+ |
EditorBorderStyle = bsSingle |
| 156 |
+ |
DefaultPositionAtEnd = False |
| 157 |
+ |
end |
| 158 |
+ |
object FieldNamesGrid: TIBDynamicGrid |
| 159 |
+ |
Left = 458 |
| 160 |
+ |
Height = 184 |
| 161 |
+ |
Top = 32 |
| 162 |
+ |
Width = 144 |
| 163 |
+ |
Color = clWindow |
| 164 |
+ |
Columns = < |
| 165 |
+ |
item |
| 166 |
+ |
ButtonStyle = cbsCheckboxColumn |
| 167 |
+ |
Title.Caption = 'SELECTED' |
| 168 |
+ |
Width = 30 |
| 169 |
+ |
FieldName = 'SELECTED' |
| 170 |
+ |
AutoSizeColumn = False |
| 171 |
+ |
InitialSortColumn = False |
| 172 |
+ |
DBLookupProperties.ItemHeight = 0 |
| 173 |
+ |
DBLookupProperties.ItemWidth = 0 |
| 174 |
+ |
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 175 |
+ |
end |
| 176 |
+ |
item |
| 177 |
+ |
Title.Caption = 'COLUMNNAME' |
| 178 |
+ |
Width = 64 |
| 179 |
+ |
FieldName = 'COLUMNNAME' |
| 180 |
+ |
AutoSizeColumn = True |
| 181 |
+ |
InitialSortColumn = False |
| 182 |
+ |
DBLookupProperties.ItemHeight = 0 |
| 183 |
+ |
DBLookupProperties.ItemWidth = 0 |
| 184 |
+ |
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 185 |
+ |
end> |
| 186 |
+ |
DataSource = IBSQLEditFrame.FieldsSource |
| 187 |
+ |
FixedCols = 0 |
| 188 |
+ |
Options = [dgEditing, dgColumnResize, dgColumnMove, dgRowLines, dgConfirmDelete, dgCancelOnExit, dgDisableDelete, dgDisableInsert] |
| 189 |
+ |
Scrollbars = ssAutoVertical |
| 190 |
+ |
TabOrder = 7 |
| 191 |
+ |
ExpandEditorPanelBelowRow = False |
| 192 |
+ |
Descending = False |
| 193 |
+ |
EditorBorderStyle = bsSingle |
| 194 |
+ |
DefaultPositionAtEnd = False |
| 195 |
+ |
end |
| 196 |
+ |
object SelectSelectAll: TCheckBox |
| 197 |
+ |
Left = 456 |
| 198 |
+ |
Height = 22 |
| 199 |
+ |
Top = 216 |
| 200 |
+ |
Width = 134 |
| 201 |
+ |
Caption = 'Select/Deselect All' |
| 202 |
+ |
OnClick = SelectSelectAllClick |
| 203 |
+ |
TabOrder = 8 |
| 204 |
+ |
end |
| 205 |
|
end |
| 206 |
|
end |
| 207 |
|
object SQLPage: TTabSheet |
| 208 |
|
Caption = 'SQL' |
| 209 |
< |
ClientHeight = 317 |
| 209 |
> |
ClientHeight = 320 |
| 210 |
|
ClientWidth = 635 |
| 211 |
|
OnShow = SQLPageShow |
| 212 |
|
object Label2: TLabel |
| 213 |
|
Left = 10 |
| 214 |
< |
Height = 18 |
| 214 |
> |
Height = 14 |
| 215 |
|
Top = 81 |
| 216 |
< |
Width = 61 |
| 216 |
> |
Width = 56 |
| 217 |
|
Caption = 'S&QL Text:' |
| 140 |
– |
FocusControl = SQLMemo |
| 218 |
|
ParentColor = False |
| 219 |
|
end |
| 143 |
– |
object SQLMemo: TMemo |
| 144 |
– |
Left = 9 |
| 145 |
– |
Height = 205 |
| 146 |
– |
Top = 105 |
| 147 |
– |
Width = 615 |
| 148 |
– |
Anchors = [akTop, akLeft, akRight, akBottom] |
| 149 |
– |
OnChange = SQLMemoChange |
| 150 |
– |
ScrollBars = ssAutoBoth |
| 151 |
– |
TabOrder = 0 |
| 152 |
– |
end |
| 220 |
|
object StatementType: TRadioGroup |
| 221 |
|
Left = 10 |
| 222 |
< |
Height = 53 |
| 222 |
> |
Height = 49 |
| 223 |
|
Top = 9 |
| 224 |
< |
Width = 350 |
| 224 |
> |
Width = 327 |
| 225 |
|
AutoFill = True |
| 226 |
|
AutoSize = True |
| 227 |
|
Caption = 'Statement Type' |
| 234 |
|
ChildSizing.Layout = cclLeftToRightThenTopToBottom |
| 235 |
|
ChildSizing.ControlsPerLine = 5 |
| 236 |
|
ClientHeight = 34 |
| 237 |
< |
ClientWidth = 346 |
| 237 |
> |
ClientWidth = 325 |
| 238 |
|
Columns = 5 |
| 239 |
|
ItemIndex = 0 |
| 240 |
|
Items.Strings = ( |
| 245 |
|
'&Refresh' |
| 246 |
|
) |
| 247 |
|
OnClick = StatementTypeClick |
| 248 |
< |
TabOrder = 1 |
| 248 |
> |
TabOrder = 0 |
| 249 |
|
end |
| 250 |
|
object TestBtn: TButton |
| 251 |
< |
Left = 541 |
| 251 |
> |
Left = 539 |
| 252 |
|
Height = 25 |
| 253 |
|
Top = 31 |
| 254 |
|
Width = 75 |
| 255 |
|
Anchors = [akTop, akRight] |
| 256 |
|
Caption = 'Test' |
| 257 |
|
OnClick = TestBtnClick |
| 258 |
+ |
TabOrder = 1 |
| 259 |
+ |
end |
| 260 |
+ |
inline IBSQLEditFrame1: TIBSQLEditFrame |
| 261 |
+ |
Left = 12 |
| 262 |
+ |
Height = 217 |
| 263 |
+ |
Top = 95 |
| 264 |
+ |
Width = 616 |
| 265 |
+ |
Anchors = [akTop, akLeft, akRight, akBottom] |
| 266 |
+ |
ClientHeight = 217 |
| 267 |
+ |
ClientWidth = 616 |
| 268 |
|
TabOrder = 2 |
| 269 |
+ |
inherited SQLText: TSynEdit |
| 270 |
+ |
Height = 191 |
| 271 |
+ |
Width = 616 |
| 272 |
+ |
OnChange = SQLMemoChange |
| 273 |
+ |
end |
| 274 |
+ |
inherited ToolBar1: TToolBar |
| 275 |
+ |
Width = 616 |
| 276 |
+ |
end |
| 277 |
+ |
inherited FieldNameList: TIBQuery |
| 278 |
+ |
ParamData = < |
| 279 |
+ |
item |
| 280 |
+ |
DataType = ftUnknown |
| 281 |
+ |
Name = 'RDB$RELATION_NAME' |
| 282 |
+ |
ParamType = ptInput |
| 283 |
+ |
end> |
| 284 |
+ |
end |
| 285 |
+ |
inherited PrimaryKeys: TIBQuery |
| 286 |
+ |
ParamData = < |
| 287 |
+ |
item |
| 288 |
+ |
DataType = ftUnknown |
| 289 |
+ |
Name = 'RDB$RELATION_NAME' |
| 290 |
+ |
ParamType = ptInput |
| 291 |
+ |
end> |
| 292 |
+ |
end |
| 293 |
+ |
inherited ProcInputParams: TIBQuery |
| 294 |
+ |
ParamData = < |
| 295 |
+ |
item |
| 296 |
+ |
DataType = ftUnknown |
| 297 |
+ |
Name = 'RDB$PROCEDURE_NAME' |
| 298 |
+ |
ParamType = ptInput |
| 299 |
+ |
end> |
| 300 |
+ |
end |
| 301 |
+ |
inherited ProcOutputParams: TIBQuery |
| 302 |
+ |
ParamData = < |
| 303 |
+ |
item |
| 304 |
+ |
DataType = ftUnknown |
| 305 |
+ |
Name = 'RDB$PROCEDURE_NAME' |
| 306 |
+ |
ParamType = ptInput |
| 307 |
+ |
end> |
| 308 |
+ |
end |
| 309 |
|
end |
| 310 |
|
end |
| 311 |
|
end |
| 331 |
|
ModalResult = 2 |
| 332 |
|
TabOrder = 2 |
| 333 |
|
end |
| 217 |
– |
object IBTransaction1: TIBTransaction |
| 218 |
– |
Active = False |
| 219 |
– |
left = 32 |
| 220 |
– |
top = 368 |
| 221 |
– |
end |
| 334 |
|
end |
