Home » Developer & Programmer » Forms » oracle form entry
oracle form entry [message #444987] Thu, 25 February 2010 01:44 Go to next message
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
Re: oracle form entry [message #444994 is a reply to message #444987] Thu, 25 February 2010 02:48 Go to previous messageGo to next message
Littlefoot
Messages: 20827
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.
Re: oracle form entry [message #444995 is a reply to message #444994] Thu, 25 February 2010 03:05 Go to previous messageGo to next message
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
Re: oracle form entry [message #445017 is a reply to message #444987] Thu, 25 February 2010 04:29 Go to previous message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Set the datablocks number of records displayed property to 5.
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:
  


Current Time: Tue Sep 27 14:31:32 CDT 2016

Total time taken to generate the page: 0.22716 seconds