Home » Developer & Programmer » Forms » saving file
saving file [message #432435] Tue, 24 November 2009 04:08 Go to next message
kuwait
Messages: 52
Registered: October 2007
Member
Hello,

Please can you help me I want to create a button to copy a file (i.e. PDF file) from a client pc into a shared server folder

is there a pl/sql code capable of doing that?

Thanks
Re: saving file [message #432450 is a reply to message #432435] Tue, 24 November 2009 05:27 Go to previous messageGo to next message
kuwait
Messages: 52
Registered: October 2007
Member
I'm using form builder 6.0
Re: saving file [message #433367 is a reply to message #432450] Tue, 01 December 2009 23:41 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'd2kwutil'.

David
Re: saving file [message #433389 is a reply to message #433367] Wed, 02 December 2009 01:12 Go to previous messageGo to next message
kuwait
Messages: 52
Registered: October 2007
Member
Thanks I solved it this was the solution:

declare
   filename VARCHAR2(600);

begin

   filename:=GET_FILE_NAME('C:\', NULL, 'PDF Files (*.pdf)|*.pdf|', NULL, OPEN_file, TRUE);

   HOST('Y:\DO_COPY.BAT "'||filename||'" "'||'Z:\'||'" /V /Y' );

   if form_success then
      message(filename);
   end if;

end;


I created a bat file which contains the following code:
copy %1 %2

Re: saving file [message #434458 is a reply to message #433389] Wed, 09 December 2009 05:56 Go to previous message
lancer26
Messages: 52
Registered: May 2006
Location: Pakistan
Member

dear, can u more explain batch file...
i also have same problem
i m using following..but it works for some files and ignored others.
DECLARE
RS VARCHAR2(200);
BEGIN
RS := 'COPY '||:REF_FILE||' Z:\'||:CUSTOMER_ORDER.TRANS_ID||'.XLS';
MESSAGE(RS);
HOST(RS);

END;
Previous Topic: enter_query problem
Next Topic: log on erro
Goto Forum:
  


Current Time: Thu Dec 08 06:25:57 CST 2016

Total time taken to generate the page: 0.12476 seconds