你可以定义一个过程,传递的参数是TStringList
procedure GetEmployeeIDs(GonghaoList:TString);
const
SQL_Select_ID :string
= 'Select EmployeeID From Employees';
begin
GonghaoList.Clear;
with TQuery.Create(Self) do begin
DatabaseName := SysDB;
SQL.Clear;
SQL.Add(SQL_FromStat);
Open;
while not Eof do begin
GonghaoList.Add(Fields[0].AsString);
Next;
end; Close;
end;
end;
procedure GetEmployeeIDs(GonghaoList:TString);
const
SQL_Select_ID :string
= 'Select EmployeeID From Employees';
begin
GonghaoList.Clear;
with TQuery.Create(Self) do begin
DatabaseName := SysDB;
SQL.Clear;
SQL.Add(SQL_FromStat);
Open;
while not Eof do begin
GonghaoList.Add(Fields[0].AsString);
Next;
end; Close;
end;
end;
解决方案 »
- 在FastReport中控制Memo值的
- 程序退出后,TOleContainer为什么不能自动关闭进程的winword.exe????
- 新人报到
- Delphi+sql server2000
- 【急:Delphi打开出错“无法定位程序输入点@Sysutils@CheckWin32Version$qqrii于动态链接库rtl60.bpl】
- 数据库的问题,真不知怎么办
- 哈,体验一下放200分的感觉
- 怎么更改TCoolBar里面控件的大小?--------------------------------------------------我只有45分了。。。。。。。。。。。。。谢谢
- DELPHI 或VB 高手 高分奉送
- http控件如何访问cgi或asp?
- 谁有象FOXMAIL这种软件的源代码或核心代码,重分相谢或现金购买!
- 有没有播放.rm文件的空件?
...
procedure GetEmployeeIDS(var GonghaoList: TStringList;);
const
SQL_Select_ID :string
= 'Select EmployeeID From Employees';
begin
with TQuery.Create(Self) do begin
DatabaseName := SysDB;
SQL.Clear;
SQL.Add(SQL_FromStat);
Open;
while not Eof do begin
GonghaoList.Add(Fields[0].AsString);
Next;
end; Close;
Free;
end;
end;
...
procedure CallGetEmployeeIDS;
var
GonghaoList :TStringList;
begin
GonghaoList := TStringList.Create;
try
GetEmployeeIDS(GonghaoList);
finally
...
GonghaoList.Free;
...
end;
...
end;
...