OraFAQ Forum: Forms » oracle form entry

Home » Developer & Programmer » Forms » oracle form entry

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

oracle form entry [message #444987]

Thu, 25 February 2010 01:44

aimi99
Messages: 3
Registered: February 2010

Junior Member

Hi
i am new to oracle form , i am using orcale 10g forms, i have following requirements.
1-I have a Data Block names Hes_Modules which is connected to a table HES_MODULES having following fields (modid,moddescr).i want when form open it should show all enteries in table, My form conatin 5 fields and scrollbar.After form open it should allow to update and insert the reords in form.

Please help me

Report message to a moderator

Re: oracle form entry [message #444994 is a reply to message #444987]

Thu, 25 February 2010 02:48

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

Senior Member
Account Moderator

Quote:

i want when form open it should show all enteries in table

EXECUTE_QUERY in WHEN-NEW-FORM-INSTANCE trigger.

Quote:

My form conatin 5 fields

Does it mean that 3 of them are non-database items (as you've said that the block is based on a table which contains two columns)?
Quote:

and scrollbar

OK, no problem.

Quote:

After form open it should allow to update and insert the reords in form.

This is default form behaviour. You don't have to do anything about it.

If it is your first form, perhaps you should create it using Wizard's help.

Report message to a moderator

Re: oracle form entry [message #444995 is a reply to message #444994]

Thu, 25 February 2010 03:05

aimi99
Messages: 3
Registered: February 2010

Junior Member

i mean to say five record like
modid modedescr
modid modedescr
modid modedescr
modid modedescr
modid modedescr

Report message to a moderator

Re: oracle form entry [message #445017 is a reply to message #444987]

Thu, 25 February 2010 04:29

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

Senior Member

Set the datablocks number of records displayed property to 5.

Report message to a moderator

Previous Topic:	how to suppress the "Do you want to save the changes you have made?"
Next Topic:	How to use Pattern matching in Text_IO package

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 21:55:37 CST 2024