33 |
|
uses |
34 |
|
Classes, SysUtils, FileUtil, Forms, Controls, Graphics, Dialogs, ComCtrls, |
35 |
|
StdCtrls, ExtCtrls, IBSQLEditFrame, IBCustomDataSet, |
36 |
< |
IBDatabase, IBLookupComboEditBox, IBDynamicGrid, Types; |
36 |
> |
IBDatabase, IBLookupComboEditBox, IBDynamicGrid; |
37 |
|
|
38 |
|
type |
39 |
|
|
44 |
|
GenerateParams: TCheckBox; |
45 |
|
IBSQLEditFrame1: TIBSQLEditFrame; |
46 |
|
IncludeSysTables: TCheckBox; |
47 |
+ |
Label5: TLabel; |
48 |
+ |
Label6: TLabel; |
49 |
|
PrimaryKeysGrid: TIBDynamicGrid; |
50 |
+ |
IdentityGrid: TIBDynamicGrid; |
51 |
+ |
ReadOnlyGrid: TIBDynamicGrid; |
52 |
|
SelectSelectAll: TCheckBox; |
53 |
|
SelectTableNames: TIBLookupComboEditBox; |
54 |
|
TestBtn: TButton; |
122 |
|
GenerateParams.Checked := DataSet.GenerateParamNames; |
123 |
|
end; |
124 |
|
FDataSet := DataSet; |
125 |
+ |
with IBSQLEditFrame1 do |
126 |
+ |
begin |
127 |
+ |
IncludeReadOnlyFields := false; |
128 |
+ |
end; |
129 |
|
Result := ShowModal = mrOK; |
130 |
|
if Result and assigned(DataSet) then |
131 |
|
DataSet.GenerateParamNames := GenerateParams.Checked |
138 |
|
{ TIBDataSetEditorForm } |
139 |
|
|
140 |
|
procedure TIBDataSetEditorForm.FormShow(Sender: TObject); |
133 |
– |
var TableName: string; |
141 |
|
begin |
142 |
|
PageControl.ActivePage := FieldsPage; |
143 |
|
FModifySQL.Assign(FDataSet.ModifySQL); |
186 |
|
|
187 |
|
procedure TIBDataSetEditorForm.GenerateButtonClick(Sender: TObject); |
188 |
|
begin |
189 |
< |
IBSQLEditFrame1.GenerateSelectSQL(QuoteFields.Checked,FSelectSQL); |
190 |
< |
IBSQLEditFrame1.GenerateRefreshSQL(QuoteFields.Checked,FRefreshSQL); |
189 |
> |
IBSQLEditFrame1.GenerateSelectSQL(QuoteFields.Checked,FSelectSQL,true); |
190 |
> |
IBSQLEditFrame1.GenerateRefreshSQL(QuoteFields.Checked,FRefreshSQL,true); |
191 |
|
IBSQLEditFrame1.GenerateDeleteSQL(QuoteFields.Checked,FDeleteSQL); |
192 |
|
IBSQLEditFrame1.GenerateInsertSQL(QuoteFields.Checked,FInsertSQL); |
193 |
< |
IBSQLEditFrame1.GenerateModifySQL(QuoteFields.Checked,FModifySQL, not IncludePrimaryKeys.Checked); |
193 |
> |
IBSQLEditFrame1.GenerateModifySQL(QuoteFields.Checked,FModifySQL, IncludePrimaryKeys.Checked); |
194 |
|
FDirty := false; |
195 |
|
PageControl.ActivePage := SQLPage; |
196 |
|
end; |
258 |
|
FieldNamesGrid.DataSource := IBSQLEditFrame1.FieldsSource; |
259 |
|
if PrimaryKeysGrid <> nil then |
260 |
|
PrimaryKeysGrid.DataSource := IBSQLEditFrame1.PrimaryKeySource; |
261 |
+ |
if IdentityGrid <> nil then |
262 |
+ |
IdentityGrid.DataSource := IBSQLEditFrame1.IdentityColsSource; |
263 |
+ |
if ReadOnlyGrid <> nil then |
264 |
+ |
ReadOnlyGrid.DataSource := IBSQLEditFrame1.ReadOnlyFieldsSource; |
265 |
|
end; |
266 |
|
end; |
267 |
|
|