unit fcontrolcalidad;

interface

uses
  FireDAC.Stan.Intf, FireDAC.Stan.Option, FireDAC.Stan.Param, FireDAC.Stan.Error, FireDAC.DatS, FireDAC.Phys.Intf, FireDAC.DApt.Intf, FireDAC.Stan.Async, FireDAC.DApt, FireDAC.Comp.DataSet, FireDAC.Comp.Client, uFireDacHelper,
  Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
  Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Data.DB, Vcl.DBCtrls, 
    Vcl.Grids, Vcl.DBGrids, Vcl.ExtCtrls,
  Vcl.StdCtrls;

type
  TForm3 = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    DBGrid1: TDBGrid;
    qcampanyas: TFDQuery;
    qpesadas: TFDQuery;
    dsqcampanyas: TDataSource;
    dsqpesadas: TDataSource;
    DBLookupComboBox1: TDBLookupComboBox;
    qpesadaside: TIntegerField;
    qpesadasid: TIntegerField;
    qpesadasidea: TIntegerField;
    qpesadasfecha: TDateField;
    qpesadasfechasalida: TDateField;
    qpesadasidenvase: TWideStringField;
    qpesadasdescenvase: TWideStringField;
    qpesadasidformato: TWideStringField;
    qpesadasdescformato: TWideStringField;
    qpesadasvariedad: TIntegerField;
    qpesadassocio: TIntegerField;
    qpesadasetiqueta: TWideStringField;
    qpesadasidalbaran: TWideStringField;
    qpesadaslote: TIntegerField;
    qpesadasespecificacionescliente: TIntegerField;
    qpesadasetiquetadodestino: TIntegerField;
    qpesadasetiquetaggn: TIntegerField;
    qpesadasapto: TIntegerField;
    qaux: TFDQuery;
    qcampanyasid: TIntegerField;
    qcampanyasidempresa: TIntegerField;
    qcampanyasid_anterior: TIntegerField;
    qcampanyasdescripcion: TWideStringField;
    qcampanyasfechainicio: TDateField;
    qcampanyasfechafin: TDateField;
    qcampanyasult_pesada: TIntegerField;
    Label1: TLabel;
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form3: TForm3;

implementation

{$R *.dfm}

procedure TForm3.FormShow(Sender: TObject);
begin
    qcampanyas.Open;
    qpesadas.Open;
    qaux.sql.Clear;
    qaux.SQL.Add('select distinct(idempresa),id,idea from ea_pesadas where (idempresa,id,idea) not in (select ide,id,idea from ea_controlcalidad) and idea<=0');
    qaux.Open;
end;

end.