We have a fuctionality in the Forms application which we have developed, which allows the user to save the search results as an excel. It will ask for the path to save, default being C:\Filename.xls. It is working fine.
Now, we have web enabled the application. Now when the user tries to save it as an excel, it gets saved only in the server where the application resides and not in the client.
Pls give us some suggestions on how we can save it in the clients system.
Sample code that we are using:
DESTINATION := :FILENAME.EB_FILE ;
outfile := Text_io.fopen(DESTINATION,'w');
text_io.put_line(outfile, 'SL NO'||' '||'PARAMETER TYPE');
for i in cur loop
CNT := CNT + 1;
text_io.Put_line(outfile, CNT ||' '||i.PARAM_TYPE);
As Web Application runs on the server, it stores the file on the server. For VB, there is one INet control, through which you can receive the response at client end and save the response in the format which you want. I am not sure about Forms, if there is any controls available which recieves the response, use that control in the client application and save the response into excel file by code.
Hope, it will satisfy your question