OraFAQ Forum: Forms » UPDATE RECORD PROBLEM

Home » Developer & Programmer » Forms » UPDATE RECORD PROBLEM

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UPDATE RECORD PROBLEM [message #271075]

Sat, 29 September 2007 00:52

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 1039 times)

Report message to a moderator

Re: UPDATE RECORD PROBLEM [message #272135 is a reply to message #271075]

Thu, 04 October 2007 02:01

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

Report message to a moderator

Re: UPDATE RECORD PROBLEM [message #272400 is a reply to message #272135]

Thu, 04 October 2007 22:09

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,

Report message to a moderator

Re: UPDATE RECORD PROBLEM [message #272851 is a reply to message #272400]

Mon, 08 October 2007 01:10

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 18 11:18:47 CDT 2025