with adoquery2 do
begin
sql.text:='SELECT pj_type FROM pj WHERE pj_name = "网卡"';
open;
end;
flatcombobox1.items.clear;
while not adoquery2.eof do
begin
with flatcombobox1.items do
begin
add(adoquery2.fieldbyname('pj_type').asstring);
end;
next;
end;
为什么总提示“网卡”找不到,无论我该单引号,还是不加引号都不行,单引号干脆就编译过不去。
begin
sql.text:='SELECT pj_type FROM pj WHERE pj_name = "网卡"';
open;
end;
flatcombobox1.items.clear;
while not adoquery2.eof do
begin
with flatcombobox1.items do
begin
add(adoquery2.fieldbyname('pj_type').asstring);
end;
next;
end;
为什么总提示“网卡”找不到,无论我该单引号,还是不加引号都不行,单引号干脆就编译过不去。
解决方案 »
- 求教 BHO插件的 执行javascript代码!
- delphi中的Twebbrowser打开的网页,如何限制不允许下载网页上面的声音等文件
- DELPHI7说没有TServerSocket,不知道此类包含在哪个控件里面~
- 交流一下接外单的经验
- 如何将光盘内容制作成.iso文件,大家多加指点!
- 关于delphi开发的webservice如何发布?
- tcpClient接收不到服务器端发来的消息,这是为什么?急,在线等
- 如何让dbgrid中新增加的一行readonly为false,别的都为true
- 招聘;
- 大家来看看!高分求解!全屏范围内获取鼠标指针的位置信息,并显示在主窗口中?
- 如何设置打印字体
- 我想用按钮来控制listbox的滚动条,就是说,当我按了按钮后,listbox会向下滚动一条记录,注意只是滚动,并不是选中下一条记录。我用了li
begin
close;
sql.clear;
sql.text:='SELECT pj_type FROM pj WHERE pj_name =''网卡''';
open;
end;
flatcombobox1.items.clear;
while not adoquery2.eof do
begin
with flatcombobox1.items do
begin
add(adoquery2.fieldbyname('pj_type').asstring);
end;
next;
end;
begin
close;//缺少
sql.clear;//缺少
sql.text:='SELECT pj_type FROM pj WHERE pj_name =''网卡''';
open;
end;
sql.text:='SELECT pj_type FROM pj WHERE pj_name = "网卡"';
怎么改上面已经有了,最好改成dulei115() ( ) 信誉:100 那样的
with adoquery2 do
begin
close;
sql.clear;
sql.text:='SELECT pj_type FROM pj WHERE pj_name =''网卡''';
open;
end;
flatcombobox1.items.clear;
adoquery2.first;
while not adoquery2.eof do
begin
with flatcombobox1.items do
begin
add(adoquery2.fieldbyname('pj_type').asstring);
end;
next;
end;
改为:sql.text:='SELECT pj_type FROM pj WHERE pj_name ='+#39+'网卡'+#39;
begin
close;//缺少
sql.clear;//缺少
sql.text:='SELECT pj_type FROM pj WHERE pj_name =''网卡''';
open;
end;
sql.text:='SELECT pj_type FROM pj WHERE pj_name = ''网卡''';
'select * from db where name=''abc'' ' =================================================================== ... 我疯了..... ===================================================================
begin
close;
sql.clear;
sql.text:='SELECT pj_type FROM pj WHERE pj_name = :1';
parameters.parambyname('1').value := '网卡';
open;
end;
flatcombobox1.items.clear;
while not adoquery2.eof do
begin
with flatcombobox1.items do
begin
add(adoquery2.fieldbyname('pj_type').asstring);
end;
next;
end;
begin
close;
sql.clear;
sql.text:='SELECT pj_type FROM pj WHERE pj_name ='+''''+'网卡'+'''';
open;
end;
四个''''产生一个',简单明了。嘻嘻!
看楼主少了CLOSE
和SQL。CLEAR看来楼主还得好好学学SQL
begin
Close;
SQL.Clear;
SQL.Add('select pj_type from pj where pj_name = ''网卡''');
Open;
FlatComboBox1.Items.Clear;
while not eof do
begin
FlatComboBox1.Items.Add(FieldByName('pj_type').AsString);
Next;
end;
end;
我的才是标准带码,拷贝过去用吧,至于哪里有错,你自己对比着看吧!唉!现在的年轻人。
begin
close;
sql.clear;
//sql.text:='SELECT pj_type FROM pj WHERE pj_name =''网卡''';
sql.add('SELECT pj_type FROM pj WHERE pj_name =:wk);
parameters.ParamByName('wk').Value:='网卡';
open;
end;
flatcombobox1.items.clear;
adoquery2.first;
while not adoquery2.eof do
begin
with flatcombobox1.items do
begin
add(adoquery2.fieldbyname('pj_type').asstring);
end;
next;
end;