trunk/design/ibrefreshsqleditor.pas

unit ibrefreshsqleditor;

{$mode objfpc}{$H+}

interface

uses
  Classes, SysUtils, FileUtil, LResources, Forms, Controls, Graphics, Dialogs,
  StdCtrls, IBSystemTables, IBDatabase;

type

  { TIBRefreshSQLEditorForm }

  TIBRefreshSQLEditorForm = class(TForm)
    Button1: TButton;
    Button2: TButton;
    GenerateBtn: TButton;
    TestBtn: TButton;
    FieldList: TListBox;
    IBTransaction1: TIBTransaction;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    PrimaryKeyList: TListBox;
    QuoteFields: TCheckBox;
    SQLText: TMemo;
    TableNamesCombo: TComboBox;
    procedure GenerateBtnClick(Sender: TObject);
    procedure TestBtnClick(Sender: TObject);
    procedure FieldListDblClick(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure PrimaryKeyListDblClick(Sender: TObject);
    procedure TableNamesComboCloseUp(Sender: TObject);
  private
    { private declarations }
    FIBSystemTables: TIBSystemTables;
  public
    { public declarations }
    constructor Create(TheOwner: TComponent); override;
    destructor Destroy; override;
    procedure SetDatabase(Database: TIBDatabase);
  end; 

var
  IBRefreshSQLEditorForm: TIBRefreshSQLEditorForm;

function EditSQL(Database: TIBDatabase; SelectSQL: TStrings): boolean;

implementation

{$R *.lfm}

function EditSQL(Database: TIBDatabase;  SelectSQL: TStrings): boolean;
begin
  Result := false;
  if assigned(Database) then
    try
      Database.Connected := true;
    except on E: Exception do
      ShowMessage(E.Message)
    end;

  with TIBRefreshSQLEditorForm.Create(Application) do
  try
    SetDatabase(Database);
    SQLText.Lines.Assign(SelectSQL);
    Result := ShowModal = mrOK;
    if Result then
     SelectSQL.Assign(SQLText.Lines)
  finally
    Free
  end;
end;

{ TIBRefreshSQLEditorForm }

procedure TIBRefreshSQLEditorForm.FormShow(Sender: TObject);
var TableName: string;
begin
  GenerateBtn.Enabled := (IBTransaction1.DefaultDatabase <> nil) and IBTransaction1.DefaultDatabase.Connected;
  TestBtn.Enabled := (IBTransaction1.DefaultDatabase <> nil) and IBTransaction1.DefaultDatabase.Connected;
  TableNamesCombo.Items.Clear;
  FIBSystemTables.GetTableNames(TableNamesCombo.Items);
  if TableNamesCombo.Items.Count > 0 then
  begin
    TableNamesCombo.ItemIndex := 0;
    if Trim(SQLText.Text) <> '' then
    begin
      FIBSystemTables.GetTableAndColumns(SQLText.Text,TableName,nil);
      TableNamesCombo.ItemIndex := TableNamesCombo.Items.IndexOf(TableName)
    end;
    FIBSystemTables.GetFieldNames(TableNamesCombo.Text,FieldList.Items);
    FIBSystemTables.GetPrimaryKeys(TableNamesCombo.Text,PrimaryKeyList.Items);
  end;
end;

procedure TIBRefreshSQLEditorForm.PrimaryKeyListDblClick(Sender: TObject);
begin
  SQLText.SelText := PrimaryKeyList.Items[PrimaryKeyList.ItemIndex];
  SQLText.SetFocus
end;

procedure TIBRefreshSQLEditorForm.FieldListDblClick(Sender: TObject);
begin
  SQLText.SelText := FieldList.Items[FieldList.ItemIndex];
  SQLText.SetFocus
end;

procedure TIBRefreshSQLEditorForm.GenerateBtnClick(Sender: TObject);
var FieldNames: TStrings;
begin
  FieldNames :=  FIBSystemTables.GetFieldNames(FieldList);
  try
    FIBSystemTables.GenerateRefreshSQL(TableNamesCombo.Text,QuoteFields.Checked,FieldNames,SQLText.Lines)
  finally
    FieldNames.Free
  end;
end;

procedure TIBRefreshSQLEditorForm.TestBtnClick(Sender: TObject);
begin
  FIBSystemTables.TestSQL(SQLText.Lines.Text)
end;

procedure TIBRefreshSQLEditorForm.TableNamesComboCloseUp(Sender: TObject);
begin
  FIBSystemTables.GetFieldNames(TableNamesCombo.Text,FieldList.Items);
  FIBSystemTables.GetPrimaryKeys(TableNamesCombo.Text,PrimaryKeyList.Items);
end;

constructor TIBRefreshSQLEditorForm.Create(TheOwner: TComponent);
begin
  inherited Create(TheOwner);
  FIBSystemTables := TIBSystemTables.Create;
end;

destructor TIBRefreshSQLEditorForm.Destroy;
begin
  if assigned(FIBSystemTables) then FIBSystemTables.Free;
  inherited Destroy;
end;

procedure TIBRefreshSQLEditorForm.SetDatabase(Database: TIBDatabase);
begin
  IBTransaction1.DefaultDatabase := Database;
  FIBSystemTables.SelectDatabase(Database,IBTransaction1)
end;

end.

Revision:	17
Committed:	Sat Dec 28 19:22:24 2013 UTC (10 years, 11 months ago) by tony
Content type:	text/x-pascal
File size:	4316 byte(s)
Log Message:	Committing updates for Release R1-0-5
#	User	Rev	Content
1	tony	17	unit ibrefreshsqleditor;
2
3			{$mode objfpc}{$H+}
4
5			interface
6
7			uses
8			Classes, SysUtils, FileUtil, LResources, Forms, Controls, Graphics, Dialogs,
9			StdCtrls, IBSystemTables, IBDatabase;
10
11			type
12
13			{ TIBRefreshSQLEditorForm }
14
15			TIBRefreshSQLEditorForm = class(TForm)
16			Button1: TButton;
17			Button2: TButton;
18			GenerateBtn: TButton;
19			TestBtn: TButton;
20			FieldList: TListBox;
21			IBTransaction1: TIBTransaction;
22			Label1: TLabel;
23			Label2: TLabel;
24			Label3: TLabel;
25			Label4: TLabel;
26			PrimaryKeyList: TListBox;
27			QuoteFields: TCheckBox;
28			SQLText: TMemo;
29			TableNamesCombo: TComboBox;
30			procedure GenerateBtnClick(Sender: TObject);
31			procedure TestBtnClick(Sender: TObject);
32			procedure FieldListDblClick(Sender: TObject);
33			procedure FormShow(Sender: TObject);
34			procedure PrimaryKeyListDblClick(Sender: TObject);
35			procedure TableNamesComboCloseUp(Sender: TObject);
36			private
37			{ private declarations }
38			FIBSystemTables: TIBSystemTables;
39			public
40			{ public declarations }
41			constructor Create(TheOwner: TComponent); override;
42			destructor Destroy; override;
43			procedure SetDatabase(Database: TIBDatabase);
44			end;
45
46			var
47			IBRefreshSQLEditorForm: TIBRefreshSQLEditorForm;
48
49			function EditSQL(Database: TIBDatabase; SelectSQL: TStrings): boolean;
50
51			implementation
52
53			{$R *.lfm}
54
55			function EditSQL(Database: TIBDatabase; SelectSQL: TStrings): boolean;
56			begin
57			Result := false;
58			if assigned(Database) then
59			try
60			Database.Connected := true;
61			except on E: Exception do
62			ShowMessage(E.Message)
63			end;
64
65			with TIBRefreshSQLEditorForm.Create(Application) do
66			try
67			SetDatabase(Database);
68			SQLText.Lines.Assign(SelectSQL);
69			Result := ShowModal = mrOK;
70			if Result then
71			SelectSQL.Assign(SQLText.Lines)
72			finally
73			Free
74			end;
75			end;
76
77			{ TIBRefreshSQLEditorForm }
78
79			procedure TIBRefreshSQLEditorForm.FormShow(Sender: TObject);
80			var TableName: string;
81			begin
82			GenerateBtn.Enabled := (IBTransaction1.DefaultDatabase <> nil) and IBTransaction1.DefaultDatabase.Connected;
83			TestBtn.Enabled := (IBTransaction1.DefaultDatabase <> nil) and IBTransaction1.DefaultDatabase.Connected;
84			TableNamesCombo.Items.Clear;
85			FIBSystemTables.GetTableNames(TableNamesCombo.Items);
86			if TableNamesCombo.Items.Count > 0 then
87			begin
88			TableNamesCombo.ItemIndex := 0;
89			if Trim(SQLText.Text) <> '' then
90			begin
91			FIBSystemTables.GetTableAndColumns(SQLText.Text,TableName,nil);
92			TableNamesCombo.ItemIndex := TableNamesCombo.Items.IndexOf(TableName)
93			end;
94			FIBSystemTables.GetFieldNames(TableNamesCombo.Text,FieldList.Items);
95			FIBSystemTables.GetPrimaryKeys(TableNamesCombo.Text,PrimaryKeyList.Items);
96			end;
97			end;
98
99			procedure TIBRefreshSQLEditorForm.PrimaryKeyListDblClick(Sender: TObject);
100			begin
101			SQLText.SelText := PrimaryKeyList.Items[PrimaryKeyList.ItemIndex];
102			SQLText.SetFocus
103			end;
104
105			procedure TIBRefreshSQLEditorForm.FieldListDblClick(Sender: TObject);
106			begin
107			SQLText.SelText := FieldList.Items[FieldList.ItemIndex];
108			SQLText.SetFocus
109			end;
110
111			procedure TIBRefreshSQLEditorForm.GenerateBtnClick(Sender: TObject);
112			var FieldNames: TStrings;
113			begin
114			FieldNames := FIBSystemTables.GetFieldNames(FieldList);
115			try
116			FIBSystemTables.GenerateRefreshSQL(TableNamesCombo.Text,QuoteFields.Checked,FieldNames,SQLText.Lines)
117			finally
118			FieldNames.Free
119			end;
120			end;
121
122			procedure TIBRefreshSQLEditorForm.TestBtnClick(Sender: TObject);
123			begin
124			FIBSystemTables.TestSQL(SQLText.Lines.Text)
125			end;
126
127			procedure TIBRefreshSQLEditorForm.TableNamesComboCloseUp(Sender: TObject);
128			begin
129			FIBSystemTables.GetFieldNames(TableNamesCombo.Text,FieldList.Items);
130			FIBSystemTables.GetPrimaryKeys(TableNamesCombo.Text,PrimaryKeyList.Items);
131			end;
132
133			constructor TIBRefreshSQLEditorForm.Create(TheOwner: TComponent);
134			begin
135			inherited Create(TheOwner);
136			FIBSystemTables := TIBSystemTables.Create;
137			end;
138
139			destructor TIBRefreshSQLEditorForm.Destroy;
140			begin
141			if assigned(FIBSystemTables) then FIBSystemTables.Free;
142			inherited Destroy;
143			end;
144
145			procedure TIBRefreshSQLEditorForm.SetDatabase(Database: TIBDatabase);
146			begin
147			IBTransaction1.DefaultDatabase := Database;
148			FIBSystemTables.SelectDatabase(Database,IBTransaction1)
149			end;
150
151			end.
152