OraFAQ Forum: Forms » Detail block behavior

Home » Developer & Programmer » Forms » Detail block behavior (Forms 6i)

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

Detail block behavior [message #597241]

Tue, 01 October 2013 23:27

m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman

Senior Member

I have a master detail block based form, sometimes its very strange that upon saving the record on current row of detail record, the record disappears but when i exit and re query the item is actually saved.But when i keep the cursor on next record which is blank and save it , there is no problem.Something to do with properties.Kindly advice.

Report message to a moderator

Re: Detail block behavior [message #597246 is a reply to message #597241]

Wed, 02 October 2013 00:17

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

The main problem is in one word: SOMETIMES. What does it mean? Are there only 2 cases (1: you are in the empty record -> no problem. 2: you are in any other record -> it disappears)?

If you were on later Forms version, you could run the form in debug mode and follow its execution path. Now, on 6i, you'll have to put MESSAGE built-ins into your PL/SQL code units so that you could see - step by step - what the form exactly does and spot the moment record disappears.

Alternatively (and much less costly) is to execute query in detail block after commit, such as

commit;
go_block('detail_block');
execute_query;

Hopefully, you won't even notice that anything happened.

Report message to a moderator

Re: Detail block behavior [message #597254 is a reply to message #597246]

Wed, 02 October 2013 03:03

m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman

Senior Member

Sorry littlefoot , to be more precise while i am on detail record which is of type multirecord, after entering the complete first row or line and when i save that line disappears, when i requery the record will not appear ,i have to close the form and re open it again.then record is appearing.

Report message to a moderator

Re: Detail block behavior [message #597255 is a reply to message #597254]

Wed, 02 October 2013 03:09

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

does the detail block have any list items where the values of the list are changed programmatically?

Report message to a moderator

Re: Detail block behavior [message #597267 is a reply to message #597255]

Wed, 02 October 2013 05:52

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

check this sample .fmb master & detail block

regard
mughal

Attachment: sample_form.fmb
(Size: 172.00KB, Downloaded 1084 times)

[Updated on: Wed, 02 October 2013 05:55]

Report message to a moderator

Re: Detail block behavior [message #597316 is a reply to message #597255]

Thu, 03 October 2013 02:38

m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman

Senior Member

no cookiemonster.

Report message to a moderator

Re: Detail block behavior [message #597319 is a reply to message #597316]

Thu, 03 October 2013 03:00

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Ok then you're going to have to debug your form to work out what's going on.
As LF already suggested - put messages in each form trigger / program unit so you can see what gets fired when you save the records.
Use get_block_property(<block name>, last_query) to check what query the form submits to the DB when you try to requery the data and don't get it.

Report message to a moderator

Previous Topic:	file transfer form server directory to client
Next Topic:	organization chart (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 14:51:49 CDT 2024