怎么样把变量又放到sql语句了去啊?
var
edittext:string;
begin
query1.close;
query1.sql.clear;
query1.sql.add('select * from table1 where id='':edittext');
edittext:=edit1.text;
query1.open;
end;就是按edit里输入的文字来进行数据库字段的查找,但老是出错?各位高手,该怎么写啊?
分数很少,sorry!
var
edittext:string;
begin
query1.close;
query1.sql.clear;
query1.sql.add('select * from table1 where id='':edittext');
edittext:=edit1.text;
query1.open;
end;就是按edit里输入的文字来进行数据库字段的查找,但老是出错?各位高手,该怎么写啊?
分数很少,sorry!
query1.ParamByName('s1').value:=edit1.text;
注意这里的s1不用定义,直接用就行
begin
query1.close;
query1.sql.clear;
query1.sql.add('select * from table1 where id=;str');
query1.ParamByName('s1').value:=edit1.text;
query1.open;
end;
或
query1.sql.add('select * from table1 where id='+edittext);
begin
query1.close;
query1.sql.clear;
query1.sql.add('select * from table1 where id=;str');
query1.ParamByName('str').value:=edit1.text;
query1.open;
end;
或
query1.sql.add('select * from table1 where id='+edit1.text);
query1.sql.add('select * from table1 where id='''+edit1.text'''');
才对的啊......不过,我也搞不清楚那些'号是怎么对应的?还望继续赐教....