刚才我在这里问了一下`~~~~
可是问题还是没有解决阿~~~~5555555
代码如下
var
name_flag :string;begin
name_flag:=trim(edit1.text);query1.close;
query1.sql.clear;
query1.sql.add('select f_station_code as code from dbo.t_station ');
query1.sql.add('where f_station_name=:name_flag ');
query1.open;
edit5.text:=query1.fieldbyname('code').asstring;end;
query 里面就是
select f_station_code
from t_station
运行到query1.open的时候就报错说没有name_flag这个字段……
暴走ing~~~~~~
现在毕业设计就卡在这里了`~~55555
小弟在delphi方面真的是了解不深,请大家多多指教!!!!
可是问题还是没有解决阿~~~~5555555
代码如下
var
name_flag :string;begin
name_flag:=trim(edit1.text);query1.close;
query1.sql.clear;
query1.sql.add('select f_station_code as code from dbo.t_station ');
query1.sql.add('where f_station_name=:name_flag ');
query1.open;
edit5.text:=query1.fieldbyname('code').asstring;end;
query 里面就是
select f_station_code
from t_station
运行到query1.open的时候就报错说没有name_flag这个字段……
暴走ing~~~~~~
现在毕业设计就卡在这里了`~~55555
小弟在delphi方面真的是了解不深,请大家多多指教!!!!
name_flag :string;begin
name_flag:=trim(edit1.text);query1.close;
query1.sql.clear;
query1.sql.add('select f_station_code as code from dbo.t_station ');
query1.sql.add('where f_station_name='''+name_flag +'''');
query1.open;
edit5.text:=query1.fieldbyname('code').asstring;end;
query1.sql.clear;
query1.sql.add('select f_station_code as code from dbo.t_station ');
query1.sql.add('where f_station_name= :name_flag ');
query1.Paramters.ParamterByName('name_flag').Value := name_Flag;
query1.open;
edit5.text:=query1.fieldbyname('code').asstring;
query1.sql.add('select f_station_code as code from dbo.t_station ');
query1.sql.add('where f_station_name=:name_flag ');
query1.paremeterbyname('name_flag').asstring = '我想要的值';
query1.open;
或者直接
query1.sql.add('select f_station_code as code from dbo.t_station ');
query1.sql.add('where f_station_name''' + '我想要的值' + '''');
query1.open;