unit savecomponent1; interface uses type var implementation {$R *.DFM} procedure TForm1.Button1Click(Sender: TObject); procedure TForm1.Button2Click(Sender: TObject); procedure TForm1.Button3Click(Sender: TObject); procedure TForm1.Button4Click(Sender: TObject); procedure TForm1.Button5Click(Sender: TObject);
Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
StdCtrls, Db, DBTables;
TForm1 = class(TForm)
Button1: TButton;
Query1: TQuery;
ListBox1: TListBox;
Button2: TButton;
Button3: TButton;
Button4: TButton;
Label1: TLabel;
Query2: TQuery;
Button5: TButton;
Edit1: TEdit;
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
procedure Button3Click(Sender: TObject);
procedure Button4Click(Sender: TObject);
procedure Button5Click(Sender: TObject);
procedure Edit1KeyPress(Sender: TObject; var Key: Char);
private
{ Private declarations }
public
{ Public declarations }
end;
Form1: TForm1;
var
F:TMemoryStream;
Path:string;
Filename:string;
begin
Path:=ExtractFilePath(application.ExeName);
FileName:=Path+ListBox.ini;
F:=TMemorystream.Create ;
F.WriteComponent(Listbox1);
F.SaveToFile(Filename);
F.Free;
listbox1.Free;
end;
var
F:TMemoryStream;
Path:string;
Filename:string;
xx:Tlistbox;
begin
xx:=Tlistbox.create(self);
xx.parent:=self;
Path:=ExtractFilePath(application.ExeName);
FileName:=Path+ListBox.ini;
F:=TMemorystream.Create ;
F.LoadFromFile(Filename);
xx:=TListBox(F.ReadComponent(xx));
F.Free;
end;
var
Path:string;
Filename:string;
begin
Path:=ExtractFilePath(application.ExeName);
FileName:=Path+ListBox.ini;
with query1 do
begin
close;requestlive:=true;sql.clear;databasename:=OILREP44444;
SQL.Add(select * from zy_query);
open;insert;
fieldbyname(qry_id).asinteger:=strtoint(edit1.text);
TBlobfield(Fieldbyname(sql_blob)).loadfromfile(Filename);
try
post;
except
close;
end;
end;
end;
var
Path:string;
Filename:string;
begin
Path:=ExtractFilePath(application.ExeName);
FileName:=Path+ListBox.ini;
with query1 do
begin
close;sql.clear;databasename:=OILREP44444;
SQL.Add(select * from zy_query where qry_id=:qq);
params[0].AsInteger:=strtoint(edit1.text);
try
open;
TBlobfield(Fieldbyname(sql_blob)).savetofile(Filename);
except
close;
end;
end;
end;
begin
listbox1.Free;
end;