Home » Developer & Programmer » Forms » various beginner forms questions [merged 3 by jd] (oracle 9i)
various beginner forms questions [merged 3 by jd] [message #540514] Tue, 24 January 2012 04:03 Go to next message
abdulbilal
Messages: 17
Registered: December 2011
Location: chennai
Junior Member
Hi, May i know the triggers in forms 6i, which is applicable to all items,blocks and form.

Thanks in advance..
commit in forms [message #540524 is a reply to message #540514] Tue, 24 January 2012 04:30 Go to previous messageGo to next message
abdulbilal
Messages: 17
Registered: December 2011
Location: chennai
Junior Member
What is the difference between PRE/POST-FORMS-COMMIT and PRE/POST-DATABASE-COMMIT?
Re: Triggers in forms 6i [message #540525 is a reply to message #540514] Tue, 24 January 2012 04:35 Go to previous messageGo to next message
cookiemonster
Messages: 13926
Registered: September 2008
Location: Rainy Manchester
Senior Member
Oracle form builder help lists all triggers. Or you can download the documentation from oracle.
Re: commit in forms [message #540526 is a reply to message #540524] Tue, 24 January 2012 04:37 Go to previous messageGo to next message
cookiemonster
Messages: 13926
Registered: September 2008
Location: Rainy Manchester
Senior Member
As stated in your other thread, form builder help answers these questions.
Block properties [message #540547 is a reply to message #540514] Tue, 24 January 2012 07:38 Go to previous messageGo to next message
abdulbilal
Messages: 17
Registered: December 2011
Location: chennai
Junior Member
Can anybody tell me the purpose of block properties,

1.Query Array Size
2.Number of records Buffered
Re: Block properties [message #540548 is a reply to message #540547] Tue, 24 January 2012 07:42 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Navigate to these properties and press F1 (Help).
Re: various beginner forms questions [merged 3 by jd] [message #540555 is a reply to message #540514] Tue, 24 January 2012 08:12 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
abdulbilal wrote on Tue, 24 January 2012 05:03
Hi, May i know the triggers in forms 6i, which is applicable to all items,blocks and form.

Thanks in advance..


I have looked at the history of your questions and every single one of them is a one off question that is easily answered in documentation. you give no feedback, nor do you make any attempt to find the answer yourself.

[Updated on: Tue, 24 January 2012 08:13]

Report message to a moderator

Re: various beginner forms questions [merged 3 by jd] [message #540556 is a reply to message #540555] Tue, 24 January 2012 08:14 Go to previous messageGo to next message
abdulbilal
Messages: 17
Registered: December 2011
Location: chennai
Junior Member
I regret..
Re: Block properties [message #540655 is a reply to message #540556] Wed, 25 January 2012 03:53 Go to previous messageGo to next message
Tomcrzy
Messages: 101
Registered: December 2011
Location: Chennai,India
Senior Member

Hi abdulbilal,

Quote:
Can anybody tell me the purpose of block properties,

1.Query Array Size
2.Number of records Buffered


I think these query array size and number of records buffered will depends on your query

1.Query Array Size
-----------------

ARRAY SIZE is the number of records that get fetched each time forms goes to the database.

2.Number of records Buffered
---------------------------
The RECORDS BUFFERED specifies the minimum number of records that should be placed in memory when records are fetched from the database. Even if you specify a low value of 3,the minimum per form is slightly over 300.As more records are brought back from the database (eg records 303-306) they get moved between memory and the file buffer as the user scrolls down.

Thanks &Regards
Tom

[Updated on: Wed, 25 January 2012 03:54]

Report message to a moderator

Re: Block properties [message #540713 is a reply to message #540655] Wed, 25 January 2012 07:37 Go to previous message
Tomcrzy
Messages: 101
Registered: December 2011
Location: Chennai,India
Senior Member

Now do you got the answer
Previous Topic: How to reset error codes
Next Topic: When-Timer-Expired
Goto Forum:
  


Current Time: Thu Jul 11 16:57:19 CDT 2024