OraFAQ Forum: Forms » Excel/File Download

Home » Developer & Programmer » Forms » Excel/File Download (form 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Excel/File Download [message #671073]

Tue, 14 August 2018 06:08

prabhakaranr
Messages: 1
Registered: October 2011
Location: Coimbatore

Junior Member

Dear All,

I am using oracle fomrs 6i, I want to move/copy a file from one location to another. I am using the following method. Win_Api_utility.copy_File('D:\PRABHA\TEST.xls','D:\',true);

I attached D2kwutil.pll in forms. it s working successfully. But files are not moving. Please help me to complete this work..

Thanks in Advance.

Report message to a moderator

Re: Excel/File Download [message #671112 is a reply to message #671073]

Wed, 15 August 2018 12:12

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

(Just checking: did you put the PLL into Forms' \bin directory?)

COPY_FILE accepts 4 parameters:

OldFileName - The location and name of the file to Copy
NewFileNme - The new location and name for the copy of the file
AllowOverWrite - TRUE or FALSE(Default) If FALSE, then if the NewFileName already exists then the move will fail. If TRUE the existing file will just be overwritten.
RaiseExceptions - TRUE or FALSE(Default) If set to true, then if the command is not successful (e.g the file does not exist) then the explicit exception NO_DATA_FOUND will be raised.

So, what happens if you include the fourth parameter (set to "true"), i.e.

Win_Api_utility.copy_File('D:\PRABHA\TEST.xls', 'D:\', true, true);

Report message to a moderator

Previous Topic:	ORA-00600 when compiling when-button-pressed
Next Topic:	Go to Specific Record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 22:04:41 CST 2025