unit Serie;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Grids, DBGrids, Db, DBTables;

type
  TFormaNumeroSerie = class(TForm)
    DataSource1: TDataSource;
    Detalle: TDBGrid;
    TablaNumeroSerie: TTable;
    TablaNumeroSerieNUSER_NS: TStringField;
    TablaNumeroSerieCLPRO_NS: TStringField;
    TablaNumeroSerieNUMAL_NS: TStringField;
    TablaNumeroSerieSTATU_NS: TStringField;
    TablaNumeroSerieDOENT_NS: TStringField;
    TablaNumeroSerieDOSAL_NS: TStringField;
    TablaNumeroSerieFEENT_NS: TStringField;
    TablaNumeroSerieFESAL_NS: TStringField;
    procedure FormCreate(Sender: TObject);
    procedure TablaNumeroSerieAfterInsert(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FormaNumeroSerie: TFormaNumeroSerie;
  clav:string;

procedure AbreNumerosSerie(clave:string);
implementation

{$R *.DFM}
procedure AbreNumerosSerie(clave:string);
begin
with FormaNumeroSerie do
begin
clav:=clave;
TablaNumeroSerie.SetRange([clave],[clave]);
ShowModal;
TablaNumeroSerie.CancelRange;

end;

end;

procedure TFormaNumeroSerie.FormCreate(Sender: TObject);
begin

TablaNumeroSerie.Open;

end;

procedure TFormaNumeroSerie.TablaNumeroSerieAfterInsert(DataSet: TDataSet);
begin
TablaNumeroSerie.FieldByName('CLPRO_NS').AsString:=clav;
end;

end.