unit rtest;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, DB, DBTables, Grids, DBGrids,rep, QRCtrls, QuickRpt;type
TRepMain = class(TForm)
DBGrid1: TDBGrid;
Button1: TButton;
Button2: TButton;
Edit1: TEdit;
Query1: TQuery;
DataSource1: TDataSource;
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
RepMain: TRepMain;implementation{$R *.dfm}procedure TRepMain.Button1Click(Sender: TObject);
var s:string;
begin
s:=edit1.text;
showmessage(s);
with query1 do
begin
close;
sql.clear;
sql.add(s);
open;
end;
end;
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, DB, DBTables, Grids, DBGrids,rep, QRCtrls, QuickRpt;type
TRepMain = class(TForm)
DBGrid1: TDBGrid;
Button1: TButton;
Button2: TButton;
Edit1: TEdit;
Query1: TQuery;
DataSource1: TDataSource;
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
RepMain: TRepMain;implementation{$R *.dfm}procedure TRepMain.Button1Click(Sender: TObject);
var s:string;
begin
s:=edit1.text;
showmessage(s);
with query1 do
begin
close;
sql.clear;
sql.add(s);
open;
end;
end;
解决方案 »
- 咨询在delphi程序里打开信使服务问题
- delphi进度条运行时其他的button不能用
- Delphi7中按F1查找帮助时,总是自动定位到“Code completion”帮助
- 有个问题,在toolbar上我放置label控件,该控件始终在toolbar的下方,而诸如edit,statictext控件却可以出现在toolbar上方,我想知道原因
- AdOtable查询??
- 如何返回应用程序的目录?(函数怎么写?)
- 高分相求!!!有没有象安培表(半园)型的仪表控件???急!!!!!!!!!!!!!
- 尚未调用 CoInitialize,调用adoconnection的open方法时的异常。
- 谁能告诉我Team Source 的序列号
- 如果截获win2000中受到的消息?如在win98中使用winpopup发出的消息!
- 请教你们用的是那种数据库呀
- 关于浏览文件夹
QUERY1.SQL.CLEAR;
QUERY1.SQL.ADD('SELECT * FROM TABLENAME WHERE FIELD='''+EDIT1.TEXT+'''';
QUERY1.OPEN;
///////////
OK运行。
begin
Close;
SQL.Clear;
SQL.Add('SELECT * FROM yourtable where c_field like ''%'+eidt1.text+'%''');
Open;
end;
dbgrid1.datasource.dataset:=query1;
procedure TRepMain.Button1Click(Sender: TObject);
var s:string;
begin
s:='select * from field1 like ' + edit1.text;//edit.text由用户输入 如:%kj%,%kjfads___df%等等,这样是最方便的
showmessage(s);
with query1 do
begin
close;
sql.clear;
sql.add(s);
open;
end;
end;
%为通配符,可以去掉任意一个,得到三种结果,
即Edit1.Text 在前,Edit1.Text 在后,Edit1.Text 在任意位置
%为通配符,可以去掉任意一个,得到三种结果,
即Edit1.Text 在前,Edit1.Text 在后,Edit1.Text 在任意位置
query1.sql.clear;
query1.sql.add('select * from table where field1>=:n1 and field1<=:n2');
query1.params[0].asstring:=edit1.text+chr(0);
query1.params[1].asstring:=edit1.text+chr(255);
query1.open;
可显示field1以edit1.text开头的所有记录。
begin
Close;
SQL.Clear;
SQL.Add('SELECT * FROM Table Where Field1 like "%"+Edit1.Text+"%"');
Open;
end;
with dm.ADOQuery do
begin
close;
sql.Clear;
sql.Add('select * from employee where empname like :empname1');
parameters.ParamValues['empname1']:='%'+trim(Edit1.text)+'%';
open;
end;
Query.Open;