How to restore database image column value [message #209628] |
Sat, 16 December 2006 00:46 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](/forum/images/custom_avatars/75489.jpg) |
azamkhan
Messages: 557 Registered: August 2005
|
Senior Member |
|
|
Hi,
I am using Oracle 9i as backend and Developer 6i as a front end. I a table that stores an image. The structure of the table is as follows:
CREATE TABLE test1 (
emp_id NUMBER(5),
emp_img LONGRAW
);
I have created a form that has this table on canvas. And this form allows record population. I have stored the image in to the column "EMP_IMG" successfully and the form is also showing it.
Suppose the user has update the record by changing the picture (using READ_IMAGE command) or populating other image from hard disk. The record is not saved yet. What I want to do is at this stage if the user wants to restore the old image i.e. the database stored image then how this can be done. I have tried database_value property but it is not working.
Plz need a solution. If somebody has experience this and has a solution then let me know.
Regards,
Azo Khan
|
|
|
|