Home » Developer & Programmer » Forms » attaching pictures. (Forms6i / 8i / xp)
attaching pictures. [message #413918] |
Sat, 18 July 2009 23:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
hi, i have to attach upto 5 pictures in a table. 'M using the BLOB column.
using the D2K, m browsing the supported image formats and when the user selects the file, the image is correctly loaded in the image item. but when i save the form it gives the error no data found.
Below is the show error dialog box.
UPDATE registration
SET rno = :1,
rdate = :2,
xdate = :3,
mname = :4,
fname = :5,
dob = :6,
mstatus = :7,
nic = :8,
qlf = :9,
occup = :10,
address = :11,
busadd = :12,
ntn = :13,
jobdept = :14,
jdate = :15,
memdetail = :16,
office1 = :17,
office2 = :18,
fax = :19,
email = :20,
res1 = :21,
res2 = :22,
cell1 = :23,
cell2 = :24,
depend = :25,
show = :26,
rid = :27,
dname1 = :28,
dname2 = :29,
dname3 = :30,
dname4 = :31,
mpic = EMPTY_BLOB ()
WHERE ROWID = :32
RETURNING ROWID, rno, rdate, xdate, mname, fname, dob, mstatus, nic, qlf,
occup, address, busadd, ntn, jobdept, jdate, memdetail, office1,
office2, fax, email, res1, res2, cell1, cell2, depend, show, dp1,
rid, dname1, dname2, dname3, dname4, mpic
INTO :33, :34, :35, :36, :37, :38, :39, :40, :41, :42,
:43, :44, :45, :46, :47, :48, :49, :50,
:51, :52, :53, :54, :55, :56, :57, :58, :59, :60,
:61, :62, :63, :64, :65, :66
No data found eror is raised only when i change / attach a new pic. (earlier it was attaching pictures, but suddenly stopped working)
[EDITED by LF: formatted the code and applied [code] tags]
[Updated on: Sun, 19 July 2009 06:32] by Moderator Report message to a moderator
|
|
|
|
Re: attaching pictures. [message #414055 is a reply to message #413918] |
Mon, 20 July 2009 04:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
|
i figured out, that when i attach/edit pictures on all 5 image items, then the whole record is saved. else, if any 1 picture is added / edited then it start giving the no data found error.
2ndly, if u have 2 or more image items (in my case they were blob pic1~pic5), and navigation is from 1..5, then only pic1 changes are saved without error, else u need to update all images.
this was happening with me.
however i've changed the table structure, and have created a detail table to attached member pictures, in that case it worked fine.
|
|
|
Goto Forum:
Current Time: Mon Feb 10 04:27:05 CST 2025
|