Home » Developer & Programmer » Forms » UPDATE RECORD PROBLEM
UPDATE RECORD PROBLEM [message #271075] Sat, 29 September 2007 00:52 Go to next message
fam_bila
Messages: 43
Registered: August 2007
Location: pakistan
Member
i make a form for edit attendance.
for this i have 2 canvases.
first canvas take data from student_attendance table and shows in the second canvas .
in second canvas the attendance_mode can be changed others are not. now after changing when i click on submit button it gives an error

error
records must be enter or deleted first

i'm attaching my form.
CAN ANY ONE TELL ME WHAT IS THE PROBLEM
THANX
  • Attachment: edit_att.fmb
    (Size: 128.00KB, Downloaded 1007 times)
Re: UPDATE RECORD PROBLEM [message #272135 is a reply to message #271075] Thu, 04 October 2007 02:01 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
In the 'when-button-pressed' trigger associated with 'data.show' you have a 'next_record' immediately before your exit. You need to go back up one record or delete the entry after leaving the loop.

David
Re: UPDATE RECORD PROBLEM [message #272400 is a reply to message #272135] Thu, 04 October 2007 22:09 Go to previous messageGo to next message
fam_bila
Messages: 43
Registered: August 2007
Location: pakistan
Member

thanx djmartin

this problem is solve , but another is occour that is
when click on "submit" button having update query on "button click trigger"
then the records are updated in tables but also insert it into table.
means
1. updated previous records
2. add new record with same data

can u tellme what is the problem now.
i'm waiting 4 ur reply
thanx,
Re: UPDATE RECORD PROBLEM [message #272851 is a reply to message #272400] Mon, 08 October 2007 01:10 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Don't do manual inserts. Let Forms do the work for you. Remember: this isn't VB!

David
Previous Topic: Oracle Developer 10g Form Run error FRM-10142 port 8889
Next Topic: Display Excel column names in a form List Item Elements
Goto Forum:
  


Current Time: Thu Nov 07 22:23:56 CST 2024