Record locking. [message #480099] |
Thu, 21 October 2010 03:44 |
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 |
cookiemonster
Messages: 13963 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 |
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.
|
|
|