Home » Developer & Programmer » Forms » Data should be stored in the text file (Oracle Apps ,Forms 6i)
Data should be stored in the text file [message #319911] Tue, 13 May 2008 06:53 Go to next message
Messages: 38
Registered: April 2007
Location: Chennai

Dear All,

I have created a table and started developing new form.In the form i have given to parameters From Date and To Date.
If the user enters this parameters and click on download button then it should automatically save the file and retive the data from that table with the parameters.

Can any one help me in this issue..

Re: Data should be stored in the text file [message #320048 is a reply to message #319911] Tue, 13 May 2008 19:56 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Use d2kwutil and client_host to access local files. Use 'dir > aaa.txt' to get a list of files. Read 'aaa.txt' and work out which files fall into your date range. Use 'utl_file' to 'text_io' to get ideas on how to read the data files once you work out which ones you want to process. Use 'insert' statetments to store the data into the table. Then use the standard Forms functionality to display the data that is in the table.

Previous Topic: Display Mesage
Next Topic: Transfer a file from a report server to an application server
Goto Forum:

Current Time: Sun Aug 20 14:03:48 CDT 2017

Total time taken to generate the page: 0.09344 seconds