大哥:
我的代码如下,他说我参数有错,为啥?
with query1 do
begin
close;
with sql do
begin
clear;
add('select min(ID),max(ID) as tian1minid,tian1maxid from tian');
add('where Knowledgepoint=1');
end;
open;
end;
我的代码如下,他说我参数有错,为啥?
with query1 do
begin
close;
with sql do
begin
clear;
add('select min(ID),max(ID) as tian1minid,tian1maxid from tian');
add('where Knowledgepoint=1');
end;
open;
end;
解决方案 »
- 新手要做B/S结构的管理系统,请大家给点建议
- Delphi菜鸟一天一问,这个提示框如何去掉
- 捞分的机会来了 如何做才能在点击dbgrid的VSscrollbar时,记录集位置不变????
- 关于TStrings的AddObject用法,请帮忙。
- Delphi ClientSocket和ServerSocket怎么实现文档的上传下载??
- 关于使用BatchMove的问题
- 关于继承关系的initialization执行顺序问题
- 通过socket获得对方IP地址?
- adotable1['quan1']:=strtoint(adodataset1['quan1']),quan为字符请问为何不成立.
- 请问如何设置动态二维数组?
- 使用tquery组件为何不能使用append添加记录
- 怎么样使小数点在文本框中只出现一次???
begin
close;
with sql do
begin
clear;
add('select min(ID) as tian1minid,max(ID) as tian1maxid from tian');
add('where Knowledgepoint=1');
end;
open;
end;
add('where Knowledgepiont=''1''');
(其中Tgetidscope=Array[1..2]of integer)
function getidscope(tablename,KP:string):Tgetidscope;
begin
with query1 do
begin
close;
with sql do
begin
clear;
add('select min(ID) as minvaluename,max(ID) as maxvaluename from'+tablename);
add('where Knowledgepoint='+KP);
end;
open;
end;
result[1]:=query1.fieldbyname(minvaluename).AsInteger;
result[2]:=query1.fieldbyname(maxvaluename).AsInteger;
end;
调用
recordscope[3,2,1]:=getidscope('tian','1')[1];
recordscope[3,2,2]:=getidscope('tian','1')[2];
with query1 do
begin
close;
with sql do
begin
clear;
add('select min(ID) as tian1minid,max(ID) as tian1maxid from tian');
add(' where Knowledgepoint=1');
~这少一空格
end;
open;
end;add('select min(ID) as minvaluename,max(ID) as maxvaluename from '+tablename);
~这少一空格
add(' where Knowledgepoint='+KP);
~这少一空格
是编译通不过,
[Error] main.pas(33): Undeclared identifier: 'query1'
[Error] main.pas(36): Undeclared identifier: 'sql'
等
拖一个Query 放在你的Form上先
但写成mainform.query1就ok了
但执行open还有错?
select子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确
但是哪个
recordscope[3,2,1]:=getidscope('tian','1')[1];
recordscope[3,2,2]:=getidscope('tian','1')[2];
返回值取不过来
但函数里的result[1]和result[2]已经有值了!
function getidscope(tablename,KP:string):Tgetidscope;
var
temp:Tgetidscope;
begin
with query1 do
begin
close;
with sql do
begin
clear;
add('select min(ID) as minvaluename,max(ID) as maxvaluename from'+tablename);
add('where Knowledgepoint='+KP);
end;
open;
end;
temp[1]:=query1.fieldbyname(minvaluename).AsInteger;
temp[2]:=query1.fieldbyname(maxvaluename).AsInteger;
result:=temp;
end;
调用
var
result:Tgetidscope;
result:=getidscope('tian','1')
recordscope[3,2,1]:=result[1];
recordscope[3,2,2]:=result[2];