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: Can we make a particular records line to non editable in Grid
Next Topic: Transfer a file from a report server to an application server
Goto Forum:

Current Time: Fri Jun 23 10:44:09 CDT 2017

Total time taken to generate the page: 0.12985 seconds