Home » Developer & Programmer » Forms » About creating forms (Oracle10g developer suite)
About creating forms [message #385798] Wed, 11 February 2009 01:37 Go to next message
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
Junior Member
I am new to Oracle forms with some basic knowledge
I want to create a form with oracle forms builder 10g as follows

for ex.
Dept table
On form there is 1 input field i.e deptno
and one push button search

After entering the dept no when i clicked on the button
I want display all the fields from dept table on the same form.
Please help me in completing this task
Re: About creating forms [message #385810 is a reply to message #385798] Wed, 11 February 2009 03:05 Go to previous messageGo to next message
icmohsin
Messages: 12
Registered: January 2009
Location: Mumbai
Junior Member
Go through this form hope it will help you
  • Attachment: emp.fmb
    (Size: 44.00KB, Downloaded 1011 times)
Re: About creating forms [message #385841 is a reply to message #385810] Wed, 11 February 2009 06:08 Go to previous messageGo to next message
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
Junior Member
thanls....but
when i try to open your file it is giving me following error

PDE-PEP006 encoded program unit has unknown format
that error may be because i m using lower version of forms than yours

i can open the emp.fmb but code for trigger is not visible
can u copy paste code here

[Updated on: Wed, 11 February 2009 06:10]

Report message to a moderator

Re: About creating forms [message #385847 is a reply to message #385841] Wed, 11 February 2009 07:11 Go to previous messageGo to next message
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
Junior Member
please reply soon
Re: About creating forms [message #385892 is a reply to message #385798] Wed, 11 February 2009 14:21 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why reinventing the wheel? Forms can do the search by itself - it is one of its default, built-in behaviours: press ENTER QUERY, enter search criteria, press EXECUTE QUERY. As simple as that.

As of your own button solution, it would help if you had showed us what code stands behind this button. Otherwise, it is difficult to help.

Basically, you should create the DEFAULT WHERE clause and execute query. Did you do that? If not, search the board to see how to do it.
Re: About creating forms [message #385920 is a reply to message #385892] Wed, 11 February 2009 22:51 Go to previous messageGo to next message
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
Junior Member
in the attached example i.e emp.fmb there is one button and i want the code for the trigger on that button so that i can understand the flow
Re: About creating forms [message #385947 is a reply to message #385920] Wed, 11 February 2009 23:57 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Why 'understand the flow'?

You write a Form using the wizards. It massages the contents of a table. It works! Move on!

David
Previous Topic: Import Excel and numbers in varchar field
Next Topic: How to add graphics to the form webpage?
Goto Forum:
  


Current Time: Sun Feb 09 10:04:57 CST 2025