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
siva27
Messages: 41
Registered: April 2007
Location: Chennai
Member
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..

Thanks,
Siva.
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
djmartin
Messages: 10181
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.

David
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: Mon Feb 03 07:04:37 CST 2025