1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| function CreerFichier : Boolean;
var Abandon : Integer;
WBons : TTable;
begin
WBons:=TTable.Create(Self);
try
with WBons do
repeat
DatabaseName := 'Travail';
TableName:='WABC'+FloatToStr(Int(Frac(now)*100000));
Fic_ABC:=TableName;
with FieldDefs do begin
Clear;
Add('CLIENT',ftString,4,true);
Add('CA',ftCurrency,0,true);
Add('PAYS',ftString,30,False);
Add('VILLE',ftString,30,False);
end;
with IndexDefs do begin
Clear;
Add('','CLIENT',[ixPrimary,ixUnique]);
Add('ABC_SORT','CA;CLIENT',[ixDescending]);
end;
try
CreateTable;
Result:=True;
except
Abandon:=MessageDlg('Erreur Création Fichier de Travail',
mtConfirmation,[mbRetry,mbAbort],0);
end;
until Result or(Abandon=mrAbort);
if Abandon=mrAbort then Close;
finally
WBons.Free;
end;
end; |
Partager