browse file 1

[tyb]

can some one plz tell me, how to use the windows open file dialog box or some other way to browse the file.

thanks in advance

 

[lewisp]

You do not tell us what version of forms, or even if it is forms, you are using.

You need to use the D2KWUTIL package supplied with forms if you need to use this feature, and it will only work from client-based forms.

 

[tyb]

sorry lewisp

i'm using forms 5,

2ndly i never used packages, can u plz get me into a start through some simple example that how to call this package etc.

many thanks for this favor.

 

[lewisp]

You need to attach the d2kwutil.pll library to your form(s) and make sure the d2kwut32.dll is loaded into your system directory or <oracle_home>\bin.

The functions to call the open file dialogue are in the packages in the library.

 

[tyb]

thanks lewisp

i'v get ur point but when i try to find this .pll & .dll file there's no such file on my system then from where can i get it.

 

[HimanB]

Hi,
For this simply make use of WINHELP.pll & write follwoing code in your When-button-pressed trigger.

If you do not have WINHELP.PLL write in to me at himanshu.bhardwaj@polaris.co.in, i'll send you the same.

Regards
Himanshu

DECLARE
L_FileName VARCHAR2(2000);
BEGIN
L_FileName := NULL;
Var.L_Eft_Ret_Flag := 0;
Var.L_Array_Flag := 0;


L_FileName := Win_Api_Dialog.Open_File('Select File', '$WINDIR$', 'All Files(*.*)|*.*|',TRUE, WIN_API.OFN_FLAG_DEFAULT,TRUE);

Exception
When Form_Trigger_Failure Then
Raise Form_Trigger_Failure;
When others then
Template.show_error('T');
END;

 

[HimanB]

Dear All,
I would like to make a correction over here.
The code which I have psoted in this thread works with D2KWUTIL.pll & not with WINHELP.pll.

I apologize for the mistake done by me here.

Regards
Himanshu