按照COMBOBOX中的显示,查询数据库里面的值,程序这样
with adoquery1 do
begin
SQL.Clear ;
SQL.Add('select number from area where name='''+ComboBox1.Text+'''');
怎么提取这个NUMBER的值?
with adoquery1 do
begin
SQL.Clear ;
SQL.Add('select number from area where name='''+ComboBox1.Text+'''');
怎么提取这个NUMBER的值?
begin
SQL.Clear ;
SQL.Add('select number from area where name='''+ComboBox1.Text+'''');
Open;
while not eof do
begin
showmessage(Inttostr(fields[0].asinteger));
Next;
end;
end;
定义个什么类型的变量赋一下就可以了吧
mynumber: integer;
begin
with adoquery1 do
begin
SQL.Clear ;
SQL.Add('select number from area where name='''+ComboBox1.Text+'''');
Open;
mynumber := fieldbyName('number').asinteger;
end;
end;