Home » Developer & Programmer » Forms » form error (Windows XP pro service pack 2)
form error [message #341732] Wed, 20 August 2008 02:20 Go to next message
torenhof
Messages: 11
Registered: August 2008
Junior Member
Hello,

I have made a form with 4 datablocks
company, project, contract and student
when i press on ctrl f11 and then want to switch to the next record in my db he always asks if i want to save de changes even if i have changed nothing. Is there e way to suppress this error or warning on my form?
Im using oracle 10g devsuite and db

Gerrit
Re: form error [message #341955 is a reply to message #341732] Wed, 20 August 2008 21:18 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If Oracle Forms asks if you 'want to save changes' then you HAVE changed something. You may not want to have done so but you have! Look in your code and fix the problem, DON'T just mask it.

David
Re: form error [message #342622 is a reply to message #341955] Sat, 23 August 2008 05:43 Go to previous messageGo to next message
torenhof
Messages: 11
Registered: August 2008
Junior Member
djmartin wrote on Wed, 20 August 2008 21:18
If Oracle Forms asks if you 'want to save changes' then you HAVE changed something. You may not want to have done so but you have! Look in your code and fix the problem, DON'T just mask it.

David


This is the code i have changed

DECLARE 
   cursor c_stud 
   is 
   select Student.SCode,Student.SNAME,STUDENT.SFIRSTNAME,Student.SSTR,Student.area 
   from Student 
   Where student.Scode in 
   (Select Contract.scode from Contract where contract.ProjCode =:Project.projCode) 
   order by Student.scode; 
   r_stud c_stud%rowtype; 
   type type_coll_stud is table of c_stud%rowtype index by pls_integer; 
   t_stud type_coll_stud; 
Begin 
  go_block('Student'); 
  open c_stud; 
  loop 
     fetch c_stud into r_stud; 
     exit when c_stud%notfound; 
     t_stud (c_stud%rowcount) :=r_stud; 
      
  end loop; 
  close c_stud; 
  for i_index in t_stud.first .. t_stud.last 
  loop 
     :Student.scode := t_stud(i_index).scode; 
     :Student.SNAME := t_stud(i_index).sname; 
     :STUDENT.SFIRSTNAME := t_stud(i_index).sfirstname; 
     :Student.SSTR := t_stud(i_index).sstr; 
     :Student.area := t_stud(i_index).area; 
     next_record; 
  end loop; 
END;

[EDITED by DJM: added [code] tags]

[Updated on: Thu, 28 August 2008 01:05] by Moderator

Report message to a moderator

Re: form error [message #342763 is a reply to message #341732] Sun, 24 August 2008 23:40 Go to previous messageGo to next message
alammas
Messages: 46
Registered: July 2008
Member
Hi,
I am also facing same problem,
With shifting trigger button from master block to detail block where next record perform it works properly without fixing any code.
What was happen i don't know?
thanks
Re: form error [message #343749 is a reply to message #342622] Thu, 28 August 2008 01:07 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Populate block using cursor
http://www.orafaq.com/forum/m/605/67467/?srch=populate+block+cursor+create_record#msg_605
and my feelings about it.
http://www.orafaq.com/forum/m/134237/67467/?srch=populate+block+cursor+create_record#msg_134237
Another one of my rants.
http://www.orafaq.com/forum/mv/msg/74947/213213/67467/#msg_213213

David
Previous Topic: Webutil error
Next Topic: Requirements for conversion from 6i to 10g
Goto Forum:
  


Current Time: Wed Dec 07 10:29:44 CST 2016

Total time taken to generate the page: 0.11311 seconds