Execute (TQueryExecuteTask )
De Wiki1000
(Différences entre les versions)
| Ligne 45 : | Ligne 45 : | ||
var qbe:TQueryExecuteTask; doc:TxmlDocument; AStr,AReason:string; | var qbe:TQueryExecuteTask; doc:TxmlDocument; AStr,AReason:string; | ||
begin | begin | ||
| − | + | ... | |
| − | + | qbe.OutputContainerName := 'MyContainerName'; | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | qbe.OutputContainerName := ' | + | |
qbe.OutputDocumentName := 'wfclassea'; | qbe.OutputDocumentName := 'wfclassea'; | ||
| − | + | ... | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
end; | end; | ||
</source> | </source> | ||
| Ligne 71 : | Ligne 58 : | ||
var qbe:TQueryExecuteTask; doc:TxmlDocument; AStr,AReason:string; | var qbe:TQueryExecuteTask; doc:TxmlDocument; AStr,AReason:string; | ||
begin | begin | ||
| − | + | ... | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
// @glbUserName will be translated to current user name | // @glbUserName will be translated to current user name | ||
| Ligne 83 : | Ligne 64 : | ||
qbe.OutputMailTo := '@glbUserName'; | qbe.OutputMailTo := '@glbUserName'; | ||
| − | + | ... | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
end; | end; | ||
</source> | </source> | ||
| + | '''Export envoyé par email:''' | ||
| + | |||
| + | <source lang="delphi"> | ||
| + | //Procedure Test; | ||
| + | var qbe:TQueryExecuteTask; doc:TxmlDocument; AStr,AReason:string; | ||
| + | begin | ||
| + | ... | ||
| + | |||
| + | // Will be send by email using configured smtp service | ||
| + | // | ||
| + | qbe.OutputMailTo := '[email protected]'; | ||
| + | qbe.OutputMailBody := 'This is an export of ... from Sage FRP 1000'; | ||
| + | |||
| + | ... | ||
| + | end; | ||
| + | </source> | ||
Voir aussi: | Voir aussi: | ||
Version actuelle en date du 15 janvier 2020 à 08:16
function Execute(var aReason:string):boolean
Cette méthode exécute l'export.
| aReason | Raison de l'échec |
| Return | True si l'export c'est exécuté |
Exemple :
Export dans un fichier:
//Procedure Test; var qbe:TQueryExecuteTask; doc:TxmlDocument; AStr,AReason:string; begin qbe := TQueryExecuteTask.Create; doc := CreateDescriptor(); AStr := doc.SaveToString; // This will recreate the document with the correct classes qbe.Descriptor.Document.LoadFromString(AStr); qbe.OutputFileName := 'c:\temp\exports\wfclassea.csv'; if not qbe.canExecute then raise Exception.Create('can''t execute'); if qbe.Execute(aReason) then showMessage('execute OK') else showMessage('execute NOK '+aReason) end;
Export dans un containeur:
//Procedure Test; var qbe:TQueryExecuteTask; doc:TxmlDocument; AStr,AReason:string; begin ... qbe.OutputContainerName := 'MyContainerName'; qbe.OutputDocumentName := 'wfclassea'; ... end;
Export dans une boîte à message:
//Procedure Test; var qbe:TQueryExecuteTask; doc:TxmlDocument; AStr,AReason:string; begin ... // @glbUserName will be translated to current user name // qbe.OutputMailTo := '@glbUserName'; ... end;
Export envoyé par email:
//Procedure Test; var qbe:TQueryExecuteTask; doc:TxmlDocument; AStr,AReason:string; begin ... // Will be send by email using configured smtp service // qbe.OutputMailTo := '[email protected]'; qbe.OutputMailBody := 'This is an export of ... from Sage FRP 1000'; ... end;
Voir aussi:
| Whos here now: Members 0 Guests 0 Bots & Crawlers 1 |