Home » Developer & Programmer » Forms » GET LOAD IMAGE SIZE BEFOR SAVE DATABASE (6i,Oracle Forms,DB 9i,windows xp)  () 1 Vote
GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605503] Fri, 10 January 2014 01:45 Go to next message
kashif_khan8281
Messages: 11
Registered: June 2012
Location: PAKISTAN
Junior Member
i m using get_file_name built-in on when-button-pressed trigger and save image in database BLOB datatype, every thing is going smoothly but i have a requirement that if load size is more then 25 kb then user unable to save this image with
message ('Image Size is more then 25kb ');
.....
Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605577 is a reply to message #605503] Fri, 10 January 2014 15:46 Go to previous messageGo to next message
cstooch
Messages: 8
Registered: August 2013
Location: Edmonton
Junior Member
You can use Webutil to get a file size.. not sure if you're using it already for getting the file from the user, but something like:

IF WEBUTIL_FILE.FILE_SIZE(filenameandpath) < xxxxxmaxbytes THEN
... process the file
ELSE
... spit out error message
END IF;

Hope that helps.

edit: sorry, I missed that you are using "get_file_name" built-in for getting file, but WEBUTIL_FILE.FILE_SIZE should still work for your case.

[Updated on: Fri, 10 January 2014 15:48]

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605598 is a reply to message #605577] Sat, 11 January 2014 13:35 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
its easy way to resolve this problem to get image size Attached "D2kwutil.pll"


:block3.a := Win_API_File.File_Size('C:\my_image.jpg', TRUE);

see in screen shot.

Regard
Mughal

[Updated on: Sat, 11 January 2014 13:35]

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605599 is a reply to message #605598] Sat, 11 January 2014 13:37 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
if you are still facing any problem let me know i will send you .fmb file according to your requirement.


Regard
Mughal
Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605661 is a reply to message #605577] Mon, 13 January 2014 04:10 Go to previous messageGo to next message
kashif_khan8281
Messages: 11
Registered: June 2012
Location: PAKISTAN
Junior Member
thanks 4 reply dear
but i m using form 6i and and 9i DB
Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605699 is a reply to message #605661] Mon, 13 January 2014 13:28 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
Dear @kashif_khan8281 above code specially works for only in forms6i try this.

take this .fmb which is acomplished in forms 6i just attached "D2kwutil.pll" as i shown you in my previous post screen shot.

Regard
Mughal

[Updated on: Mon, 13 January 2014 13:31]

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605718 is a reply to message #605699] Mon, 13 January 2014 16:56 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
See in the picture how D2KWUTIL.PLL attached
Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605719 is a reply to message #605718] Mon, 13 January 2014 17:16 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
see in the picture i developed according to your requirement by using forms 6i.


Regard
Mughal
Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605814 is a reply to message #605719] Wed, 15 January 2014 02:07 Go to previous messageGo to next message
kashif_khan8281
Messages: 11
Registered: June 2012
Location: PAKISTAN
Junior Member
thanks sir... i m still facing problem after attach d2kwutil.pll
Error is
FRM-40734 Internal Error PL/SQL error occurred
attaching jpg
Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605834 is a reply to message #605814] Wed, 15 January 2014 03:42 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
Dear no problem
FRM-40734: Internal Error: PL/SQL error occurred.

Cause: A fatal error occurred in PL/SQL during trigger execution.

Action: Notify the DBA.

Level: >25

Type: Error 


ctrl+shif->K COMPILE ALL FORM

And the main thing copy these three files in forms6i-->Bin--folder

1.d2kwut60.dll----Specially this
2.D2kwutil.pll
3.D2kcomn.pll

Then Run your form.

Hope your problem will be solved.

Regard
Mughal



[Updated on: Wed, 15 January 2014 03:46]

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605887 is a reply to message #605834] Wed, 15 January 2014 23:41 Go to previous messageGo to next message
kashif_khan8281
Messages: 11
Registered: June 2012
Location: PAKISTAN
Junior Member

Asalamu-Alicum sir
i am unable to find this d2kwut60.dll
give me solution Smile
Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605898 is a reply to message #605887] Thu, 16 January 2014 02:22 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
post your email id i will send u.


Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605925 is a reply to message #605898] Thu, 16 January 2014 05:33 Go to previous messageGo to next message
kashif_khan8281
Messages: 11
Registered: June 2012
Location: PAKISTAN
Junior Member
kashif_khan8281@yahoo.com
Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #605937 is a reply to message #605925] Thu, 16 January 2014 06:52 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
Dear Check your email all three files i have sent to your email account download all these files and copy into Forms6i--Bin--Folder

and run this fmb file which totally according to your requirement



Regard
Mughal

[Updated on: Thu, 16 January 2014 06:53]

Report message to a moderator

Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #606037 is a reply to message #605937] Fri, 17 January 2014 22:57 Go to previous messageGo to next message
kashif_khan8281
Messages: 11
Registered: June 2012
Location: PAKISTAN
Junior Member
sir i still facing problem at download form my yahoo mail account
  • Attachment: error2.JPG
    (Size: 130.62KB, Downloaded 44 times)
Re: GET LOAD IMAGE SIZE BEFOR SAVE DATABASE [message #606041 is a reply to message #606037] Sat, 18 January 2014 03:19 Go to previous message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
ok now try, go to your mail & download
Previous Topic: Cannot make more than 1 Db connect
Next Topic: How to store multiple values in a variable & display it in its field in Forms 6i??
Goto Forum:
  


Current Time: Wed Jul 23 00:48:42 CDT 2014

Total time taken to generate the page: 0.09141 seconds