Home » Developer & Programmer » Forms » attaching pictures. (Forms6i / 8i / xp)
attaching pictures. [message #413918] Sat, 18 July 2009 23:58 Go to next message
itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

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 #413932 is a reply to message #413918] Sun, 19 July 2009 06:34 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
earlier it was attaching pictures, but suddenly stopped working

What did you do so that it suddenly stopped working? Do things tend to stop working all by themselves?
Re: attaching pictures. [message #414055 is a reply to message #413918] Mon, 20 July 2009 04:04 Go to previous message
itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

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.
Previous Topic: how can we create Menus?
Next Topic: problem in searching using combo
Goto Forum:
  


Current Time: Mon Feb 10 04:27:05 CST 2025