sql.Add('SELECT * FROM Student WHERE studentno in ');
sql.Add('(select studentno from score where Math between 60 and 85)' );
把以上语句改为带以下参数的应该怎么写?
var
KM,CJD:String;
KM:='Math';
CJD:='60 and 85';
sql.Add('(select studentno from score where Math between 60 and 85)' );
把以上语句改为带以下参数的应该怎么写?
var
KM,CJD:String;
KM:='Math';
CJD:='60 and 85';
解决方案 »
- Access violation at address 008BD840 in module 'project1.exe'. Read of address 0
- 请问这样的查询语句有什么问题?
- 求判断字符长度并控制的代码及解释....
- 菜鸟一直想问这个问题,,,,,,,,,
- 局部钩子能影响其它软件????
- setfocus出错
- dxdbgrid 中MEMO字段如何显示
- 200分在线求助一些DEPHI简单的问题,可以加分!!!!!!!!!!!!
- 怎样使 PANEL 能够 执行 DRAG 动作?
- 哪里有中文版的delphi帮助或手册???
- 文件读取遭遇结束符问题,请求各位帮忙。
- combobox的STYLE为:Csdropdownlist,想点下拉按钮时,弹出个窗口,点其它部分时显示下拉部份,请教如何实现?
试试看?
sql.text := 'SELECT * FROM Student WHERE studentno in (select studentno from score where '+KM+'between'+CJD+')'';
var
KM,CJD : String;
sSql : String;
begin
KM := 'Math';
CJD := '60 and 85';
sSql := 'SELECT * FROM Student WHERE studentno in '
+ ' ( select studentno from score where ) ' + KM
+ ' between ' + CJD ;
with query1 do
begin
close;
sql.clear;
sql.Add(sSql);
open;
end;
end;
在查询表达式错误'studentno in ( select studentno from score where )Math between 60 and 85'中