Image Path save in database and image name as Design no [message #406333] |
Wed, 03 June 2009 06:50 |
shahzaib_4vip@hotmail.com
Messages: 410 Registered: December 2008 Location: karachi
|
Senior Member |
|
|
Hellow all
I create a simple table for image
CREATE TABLE image_table (
Design_no varchar2(10),
filename VARCHAR2(255) PRIMARY KEY,
image LONG RAW);
Then i create simple block of image_table
its show me in this website
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:239814548726
My question is i don't want to give my form path always
i want to save my picture path in my database and the name of my picture always same as my design_no column
For example i want to save a picture in my database i will copy my picture in d:\shahzaib\1234.jpg
now i want the path d:\shahzaib\ save in database and when i copy my picture which path= d:\shahzaib and file name = Design no its will automatically save in database
Regards
Shahzaib
|
|
|
|
Re: Image Path save in database and image name as Design no [message #407466 is a reply to message #406333] |
Wed, 10 June 2009 05:19 |
shahzaib_4vip@hotmail.com
Messages: 410 Registered: December 2008 Location: karachi
|
Senior Member |
|
|
Thanks for your reply David
I Am be able to see picture in my form and also in my report
But now i need that user cant give filename to save the picture for example i create a folder in d:\ which name is Filename and when ever i copy the picture which name equal to my Sytle no the picture automatically save in my database
I am using a button to save picture in my database which trigger is
read_image_file( :block3.filename,
'JPG', 'block3.image72' );
Regards
shahzaib ismail
|
|
|
|
|