ADOQuery3. SQL. The Add (' the SELECT program_item_visit. *, operation. The operator as operator, operation, type ');
ADOQuery3. SQL. The Add (' the FROM program_item_visit INNER JOIN operation ON ').
ADOQuery3. SQL. The 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. The Add (' WHERE the line='" + cbbline. Text +' ' 'AND work_order=' "+ cbbwork_order. Text + ' ' 'AND board_type='" + cbbtype. Text + ' ' 'ORDER BY last_operation_time DESC LIMIT 1');
ADOQuery3. The Parameters. Parambyname (" operator "). The 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;

CodePudding user response:

Before problem: the data set has been opened,

1, directly take DBEdit value:
S:=DBEdit1. Text
2, read through data collection, DBedit1 associated fields "AAA"
S:=ADOQuery3 fieldbyname (' AAAt). AsString;

CodePudding user response:

DBEdit1. Text:=adoqueryAAA. Value; As long as is the character that I can get, the other type is a transformation

CodePudding user response: