T
Thiru Malai
Guest
I am facing some issue while exporting text file to specific directory. Consider I have created one temp table and it has 100 records so i am passing each and every record to another procedure so that i can get text file for each record but the problem here is client can change the path so I cannot hard code like OUPUT TO "c:/System/Progress/Input.Txt.txt". Hence I assigned this directory to one db field(visible to client) but not exporting why?. Let me share some sample.
DEFINE VARIABLE cExportData AS CHARACTER NO-UNDO.
DEFINE VARIABLE cpath AS CHARACTER NO-UNDO.
ASSIGN cpath = "R:\Downloads\progress\".
OUTPUT TO STRING (cpath) + STRING(MTIME) + "Test.Txt".
ASSIGN
cExportData = "END00003".
MESSAGE cExportData .
OUTPUT TO CLOSE.
NOTE- I MUST USE MTIME SO THAT EACH AND EVERY FILENAME WILL GET DIFFERENT OTHERWISE I CAN GET LAST RECORD FROM THE TABLE
Continue reading...
DEFINE VARIABLE cExportData AS CHARACTER NO-UNDO.
DEFINE VARIABLE cpath AS CHARACTER NO-UNDO.
ASSIGN cpath = "R:\Downloads\progress\".
OUTPUT TO STRING (cpath) + STRING(MTIME) + "Test.Txt".
ASSIGN
cExportData = "END00003".
MESSAGE cExportData .
OUTPUT TO CLOSE.
NOTE- I MUST USE MTIME SO THAT EACH AND EVERY FILENAME WILL GET DIFFERENT OTHERWISE I CAN GET LAST RECORD FROM THE TABLE
Continue reading...