Home » Developer & Programmer » Forms » Record locking. (oracle 10g, windows XP)
Record locking. [message #480099] Thu, 21 October 2010 03:44 Go to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
Dear All

I have developed a form, containing 5 tab pages and also referencing to 5 tables.

tab page a of table a
some fields are required and some or not.

when i open form and start entering record, and then i change mine and dont enter and want to navigate to some other page, it simply allows me to leave it blank and move to some other tab page.

tab page b of table b
some fields are required and some or not.

when i open this tab page and one i click in the first field and then do not enter anything in it and want to leave it , it does not allow me to leave blank.

what could be the reason. why one tab page allow me to leave blank and navigate and why the other does not?
first field of both tab pages are required.

i shall be thankful to any solution .
Re: Record locking. [message #480104 is a reply to message #480099] Thu, 21 October 2010 04:11 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Something is changing the record_status of block b from new to insert.
Have you got any when-new-item|record-instance triggers?
Try putting messages at various points in various triggers to display the record status of block b and work out at what point it changes.
Re: Record locking. [message #480114 is a reply to message #480104] Thu, 21 October 2010 04:38 Go to previous message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
Sir,

thanks a lot.

you have rightly pointed out the problematic area.

actually i was getting value of seqnum column through cursor_record.

:abc.SeqNum := :system.cursor_record ;


after all thanks a lot i shall change the code.

regards.
Previous Topic: How can executing a program .bat in another PC in forms 10g?
Next Topic: Ora-00600 cannot exeucte package of other schema
Goto Forum:
  


Current Time: Thu Sep 19 12:22:06 CDT 2024