| 1 |
object IBUpdateSQLEditorForm: TIBUpdateSQLEditorForm |
| 2 |
Left = 442 |
| 3 |
Height = 410 |
| 4 |
Top = 421 |
| 5 |
Width = 662 |
| 6 |
ActiveControl = PageControl |
| 7 |
BorderIcons = [biSystemMenu] |
| 8 |
BorderStyle = bsDialog |
| 9 |
Caption = 'UpdateSQL Editor' |
| 10 |
ClientHeight = 410 |
| 11 |
ClientWidth = 662 |
| 12 |
OnClose = FormClose |
| 13 |
OnShow = FormShow |
| 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 |
| 22 |
Anchors = [akTop, akLeft, akRight, akBottom] |
| 23 |
TabIndex = 1 |
| 24 |
TabOrder = 0 |
| 25 |
object FieldsPage: TTabSheet |
| 26 |
Caption = 'Options' |
| 27 |
ClientHeight = 320 |
| 28 |
ClientWidth = 635 |
| 29 |
object GroupBox1: TGroupBox |
| 30 |
Left = 8 |
| 31 |
Height = 315 |
| 32 |
Top = 4 |
| 33 |
Width = 617 |
| 34 |
Anchors = [akTop, akLeft, akRight, akBottom] |
| 35 |
Caption = ' SQL Generation ' |
| 36 |
ClientHeight = 300 |
| 37 |
ClientWidth = 615 |
| 38 |
TabOrder = 0 |
| 39 |
object Label1: TLabel |
| 40 |
Left = 12 |
| 41 |
Height = 14 |
| 42 |
Top = 18 |
| 43 |
Width = 73 |
| 44 |
Caption = 'Table &Name:' |
| 45 |
ParentColor = False |
| 46 |
end |
| 47 |
object Label3: TLabel |
| 48 |
Left = 288 |
| 49 |
Height = 14 |
| 50 |
Top = 16 |
| 51 |
Width = 62 |
| 52 |
Caption = '&Key Fields:' |
| 53 |
ParentColor = False |
| 54 |
end |
| 55 |
object Label4: TLabel |
| 56 |
Left = 458 |
| 57 |
Height = 14 |
| 58 |
Top = 18 |
| 59 |
Width = 85 |
| 60 |
Caption = 'Update &Fields:' |
| 61 |
ParentColor = False |
| 62 |
end |
| 63 |
object GenerateButton: TButton |
| 64 |
Left = 9 |
| 65 |
Height = 25 |
| 66 |
Top = 83 |
| 67 |
Width = 168 |
| 68 |
Caption = '&Generate SQL' |
| 69 |
OnClick = GenerateButtonClick |
| 70 |
TabOrder = 0 |
| 71 |
end |
| 72 |
object QuoteFields: TCheckBox |
| 73 |
Left = 9 |
| 74 |
Height = 22 |
| 75 |
Top = 160 |
| 76 |
Width = 125 |
| 77 |
Caption = '&Quote Identifiers' |
| 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 |
KeyField = 'RDB$RELATION_ID' |
| 102 |
ListField = 'RDB$RELATION_NAME' |
| 103 |
ListFieldIndex = 0 |
| 104 |
LookupCache = False |
| 105 |
ScrollListDataset = True |
| 106 |
TabOrder = 4 |
| 107 |
AutoInsert = False |
| 108 |
AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 109 |
ItemHeight = 0 |
| 110 |
end |
| 111 |
object IncludeSysTables: TCheckBox |
| 112 |
Left = 13 |
| 113 |
Height = 22 |
| 114 |
Top = 59 |
| 115 |
Width = 158 |
| 116 |
Caption = 'Include System Tables' |
| 117 |
OnChange = IncludeSysTablesChange |
| 118 |
TabOrder = 5 |
| 119 |
end |
| 120 |
object PrimaryKeysGrid: TIBDynamicGrid |
| 121 |
Left = 288 |
| 122 |
Height = 181 |
| 123 |
Top = 35 |
| 124 |
Width = 144 |
| 125 |
Color = clWindow |
| 126 |
Columns = < |
| 127 |
item |
| 128 |
ButtonStyle = cbsCheckboxColumn |
| 129 |
Title.Caption = 'SELECTED' |
| 130 |
Width = 30 |
| 131 |
FieldName = 'SELECTED' |
| 132 |
AutoSizeColumn = False |
| 133 |
InitialSortColumn = False |
| 134 |
DBLookupProperties.ItemHeight = 0 |
| 135 |
DBLookupProperties.ItemWidth = 0 |
| 136 |
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 137 |
end |
| 138 |
item |
| 139 |
Title.Caption = 'COLUMNNAME' |
| 140 |
Width = 64 |
| 141 |
FieldName = 'COLUMNNAME' |
| 142 |
AutoSizeColumn = True |
| 143 |
InitialSortColumn = False |
| 144 |
DBLookupProperties.ItemHeight = 0 |
| 145 |
DBLookupProperties.ItemWidth = 0 |
| 146 |
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 147 |
end> |
| 148 |
FixedCols = 0 |
| 149 |
Options = [dgEditing, dgColumnResize, dgColumnMove, dgRowLines, dgConfirmDelete, dgCancelOnExit, dgDisableDelete, dgDisableInsert] |
| 150 |
Scrollbars = ssAutoVertical |
| 151 |
TabOrder = 6 |
| 152 |
ExpandEditorPanelBelowRow = False |
| 153 |
Descending = False |
| 154 |
EditorBorderStyle = bsSingle |
| 155 |
DefaultPositionAtEnd = False |
| 156 |
end |
| 157 |
object FieldNamesGrid: TIBDynamicGrid |
| 158 |
Left = 458 |
| 159 |
Height = 184 |
| 160 |
Top = 32 |
| 161 |
Width = 144 |
| 162 |
Color = clWindow |
| 163 |
Columns = < |
| 164 |
item |
| 165 |
ButtonStyle = cbsCheckboxColumn |
| 166 |
Title.Caption = 'SELECTED' |
| 167 |
Width = 30 |
| 168 |
FieldName = 'SELECTED' |
| 169 |
AutoSizeColumn = False |
| 170 |
InitialSortColumn = False |
| 171 |
DBLookupProperties.ItemHeight = 0 |
| 172 |
DBLookupProperties.ItemWidth = 0 |
| 173 |
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 174 |
end |
| 175 |
item |
| 176 |
Title.Caption = 'COLUMNNAME' |
| 177 |
Width = 64 |
| 178 |
FieldName = 'COLUMNNAME' |
| 179 |
AutoSizeColumn = True |
| 180 |
InitialSortColumn = False |
| 181 |
DBLookupProperties.ItemHeight = 0 |
| 182 |
DBLookupProperties.ItemWidth = 0 |
| 183 |
DBLookupProperties.AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
| 184 |
end> |
| 185 |
DataSource = IBSQLEditFrame.FieldsSource |
| 186 |
FixedCols = 0 |
| 187 |
Options = [dgEditing, dgColumnResize, dgColumnMove, dgRowLines, dgConfirmDelete, dgCancelOnExit, dgDisableDelete, dgDisableInsert] |
| 188 |
Scrollbars = ssAutoVertical |
| 189 |
TabOrder = 7 |
| 190 |
ExpandEditorPanelBelowRow = False |
| 191 |
Descending = False |
| 192 |
EditorBorderStyle = bsSingle |
| 193 |
DefaultPositionAtEnd = False |
| 194 |
end |
| 195 |
object SelectSelectAll: TCheckBox |
| 196 |
Left = 456 |
| 197 |
Height = 22 |
| 198 |
Top = 216 |
| 199 |
Width = 134 |
| 200 |
Caption = 'Select/Deselect All' |
| 201 |
OnClick = SelectSelectAllClick |
| 202 |
TabOrder = 8 |
| 203 |
end |
| 204 |
end |
| 205 |
end |
| 206 |
object SQLPage: TTabSheet |
| 207 |
Caption = 'SQL' |
| 208 |
ClientHeight = 320 |
| 209 |
ClientWidth = 635 |
| 210 |
OnShow = SQLPageShow |
| 211 |
object Label2: TLabel |
| 212 |
Left = 10 |
| 213 |
Height = 14 |
| 214 |
Top = 81 |
| 215 |
Width = 56 |
| 216 |
Caption = 'S&QL Text:' |
| 217 |
ParentColor = False |
| 218 |
end |
| 219 |
object StatementType: TRadioGroup |
| 220 |
Left = 10 |
| 221 |
Height = 49 |
| 222 |
Top = 9 |
| 223 |
Width = 266 |
| 224 |
AutoFill = True |
| 225 |
AutoSize = True |
| 226 |
Caption = 'Statement Type' |
| 227 |
ChildSizing.LeftRightSpacing = 6 |
| 228 |
ChildSizing.TopBottomSpacing = 6 |
| 229 |
ChildSizing.EnlargeHorizontal = crsHomogenousChildResize |
| 230 |
ChildSizing.EnlargeVertical = crsHomogenousChildResize |
| 231 |
ChildSizing.ShrinkHorizontal = crsScaleChilds |
| 232 |
ChildSizing.ShrinkVertical = crsScaleChilds |
| 233 |
ChildSizing.Layout = cclLeftToRightThenTopToBottom |
| 234 |
ChildSizing.ControlsPerLine = 5 |
| 235 |
ClientHeight = 34 |
| 236 |
ClientWidth = 264 |
| 237 |
Columns = 5 |
| 238 |
ItemIndex = 0 |
| 239 |
Items.Strings = ( |
| 240 |
'&Modify' |
| 241 |
'&Insert' |
| 242 |
'&Delete' |
| 243 |
'&Refresh' |
| 244 |
) |
| 245 |
OnClick = StatementTypeClick |
| 246 |
TabOrder = 0 |
| 247 |
end |
| 248 |
object TestBtn: TButton |
| 249 |
Left = 539 |
| 250 |
Height = 25 |
| 251 |
Top = 31 |
| 252 |
Width = 75 |
| 253 |
Anchors = [akTop, akRight] |
| 254 |
Caption = 'Test' |
| 255 |
OnClick = TestBtnClick |
| 256 |
TabOrder = 1 |
| 257 |
end |
| 258 |
inline IBSQLEditFrame1: TIBSQLEditFrame |
| 259 |
Left = 12 |
| 260 |
Height = 217 |
| 261 |
Top = 95 |
| 262 |
Width = 616 |
| 263 |
Anchors = [akTop, akLeft, akRight, akBottom] |
| 264 |
ClientHeight = 217 |
| 265 |
ClientWidth = 616 |
| 266 |
TabOrder = 2 |
| 267 |
inherited SQLText: TSynEdit |
| 268 |
Height = 191 |
| 269 |
Width = 616 |
| 270 |
OnChange = SQLMemoChange |
| 271 |
end |
| 272 |
inherited ToolBar1: TToolBar |
| 273 |
Width = 616 |
| 274 |
end |
| 275 |
inherited FieldNameList: TIBQuery |
| 276 |
ParamData = < |
| 277 |
item |
| 278 |
DataType = ftUnknown |
| 279 |
Name = 'RDB$RELATION_NAME' |
| 280 |
ParamType = ptInput |
| 281 |
end> |
| 282 |
end |
| 283 |
inherited PrimaryKeys: TIBQuery |
| 284 |
ParamData = < |
| 285 |
item |
| 286 |
DataType = ftUnknown |
| 287 |
Name = 'RDB$RELATION_NAME' |
| 288 |
ParamType = ptInput |
| 289 |
end> |
| 290 |
end |
| 291 |
inherited ProcInputParams: TIBQuery |
| 292 |
ParamData = < |
| 293 |
item |
| 294 |
DataType = ftUnknown |
| 295 |
Name = 'RDB$PROCEDURE_NAME' |
| 296 |
ParamType = ptInput |
| 297 |
end> |
| 298 |
end |
| 299 |
inherited ProcOutputParams: TIBQuery |
| 300 |
ParamData = < |
| 301 |
item |
| 302 |
DataType = ftUnknown |
| 303 |
Name = 'RDB$PROCEDURE_NAME' |
| 304 |
ParamType = ptInput |
| 305 |
end> |
| 306 |
end |
| 307 |
end |
| 308 |
end |
| 309 |
end |
| 310 |
object OkButton: TButton |
| 311 |
Left = 480 |
| 312 |
Height = 25 |
| 313 |
Top = 376 |
| 314 |
Width = 75 |
| 315 |
Anchors = [akRight, akBottom] |
| 316 |
Caption = '&OK' |
| 317 |
Default = True |
| 318 |
ModalResult = 1 |
| 319 |
TabOrder = 1 |
| 320 |
end |
| 321 |
object CancelButton: TButton |
| 322 |
Left = 573 |
| 323 |
Height = 25 |
| 324 |
Top = 376 |
| 325 |
Width = 75 |
| 326 |
Anchors = [akRight, akBottom] |
| 327 |
Cancel = True |
| 328 |
Caption = 'Cancel' |
| 329 |
ModalResult = 2 |
| 330 |
TabOrder = 2 |
| 331 |
end |
| 332 |
end |
