怎样获取DBEdit的值

[qq_34664223]

ADOQuery3.SQL.Add('SELECT program_item_visit.*,operation.operator as operator,operation.type');
ADOQuery3.SQL.Add('FROM program_item_visit INNER JOIN operation ON');
ADOQuery3.SQL.Add('(operation.material_no=program_item_visit.material_no AND program_item_visit.`program_id`=operation.`program_id` AND program_item_visit.`lineseat`=operation.`lineseat`)');
ADOQuery3.SQL.Add('WHERE line='''+cbbline.Text+''' AND work_order='''+cbbwork_order.Text+''' AND board_type='''+cbbtype.Text+''' ORDER BY last_operation_time DESC LIMIT 1');
ADOQuery3.Parameters.parambyname('operator').Value:=DBEdit1.Text;
ADOQuery3.Open;
//DBEdit2.Text:=ADOQuery3.fieldbyname('operator').AsString;
//fieldbyname('operator').AsString;
//DBEdit2.Text:=ADOQuery3.fieldbyname('scan_lineseat').AsString;
//DBEdit3.Text:=ADOQuery3.fieldbyname('lineseat').AsString;
//DBEdit4.Text:=ADOQuery3.fieldbyname('material_no').AsString;
//DBEdit5.Text:=ADOQuery3.fieldbyname('scan_material_no').AsString;

[lyhoo163]

前题：数据集已打开。 1、直接取DBEdit的值： S:=DBEdit1.text 2、通过数据集读取，DBedit1关联字段“AAA” S:=ADOQuery3.fieldbyname('AAAt').AsString;

[jeetliang]

DBEdit1.text:=adoqueryAAA.value; 只要是字符型就这样就能得到了，其它型就做个转换

[lyhoo163]