Simplicty and flexibility!


How To Rename A File After It Is Printed





How To Rename A File After It Is Printed

First of all create the following CDFs:

1) Function Name: IsFile
CDF library name: osfunc.dll
Return type: String

Create 2 parameters :
1-Name: Path/File Name Type: String
2-Name: Attributes to find Type: Int

2) Function Name: RenameFile
CDF library name: osfunc.dll
Return type: String

Create 3 parameters :
1-Name: Old File Name Type: String
2-Name: New File Name Type: String
3-Name: Notify User (Y or N) Type: String

Close and re-open your DataEase application (to register the CDF’s).

Copy and paste the following sample DQL code into a new procedure and amend where necessary (such as filenames). Compile and run:

define temp “tRet” number .
define temp “tOldFileNameAndPath” text 20 .
define temp “tNewFileNameAndPath” text 20 .

tOldFileNameAndPath := “C:\MyOldFile.pdf ” .
tNewFileNameAndPath := “C:\MyNewFile.pdf ” .

if IsFile (tOldFileNameAndPath, 00 ) = “True” then
tRet := RenameFile (tOldFileNameAndPath, tNewFileNameAndPath,”N”) .
message concat(“Please ensure file “, tOldFileNameAndPath, ” exists before proceeding”) window.


See Also

On the forum about How To Rename A File After It Is Printed


Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32

Hi there,I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report b...

Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17

no se pude exportar ahora archivos a pdf, ni a excel o otros cosa mala. en verdad creo que hace faltaen las versiones anteriores me funcionaba mas o menos bien. le hace falta a los aplicativos que se desarrollan en Dataeasegr...

Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11

Thanks. Anyway I'm trying to use this fuction but it seems to me that it doesn't work on 8.2. I tried also in a DQL.There's something wrong?<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9IAAAJ3CAYAAAB4NWk3AAAAAXNSR0IArs4...

Product: . Written by Marco Marchesi 15/02/16 at 14:50:46


Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46

Thanks for the very good explanation!AS...

Product: . Written by afonso santos 28/10/19 at 00:50:14

I am pleased to see that the migration from Dos 4.53 is then sa 5.5 works. A really useful thing would be a compiler of SQL languages. Will you get there?Original Text:Mi compiaccio a vedere che la migrazione da Dos 4.53 รจ poi sa 5.5 funzio...

Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44

On the blog about How To Rename A File After It Is Printed