OraFAQ Forum: Forms » Add a record in form

Home » Developer & Programmer » Forms » Add a record in form

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

Add a record in form [message #127559]

Tue, 12 July 2005 04:03

bhoite_amol83
Messages: 110
Registered: June 2005
Location: Pune

Senior Member

I am designing a form.
I this if i click ADD BUTTON then clear the fields in record and after inserting new fields and pressing SAVE BUTTON record has to be saved.

And also how can can i edit the record.

How can i do this.

Waiting for reply.

Thanx in advance.

Report message to a moderator

Re: Add a record in form [message #127571 is a reply to message #127559]

Tue, 12 July 2005 05:17

PradeepPatil
Messages: 3
Registered: June 2005
Location: Pune,Maharashtra,India

Junior Member

[Updated on: Tue, 12 July 2005 05:30]

Report message to a moderator

Re: Add a record in form [message #127676 is a reply to message #127571]

Tue, 12 July 2005 17:49

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Create a table in the Oracle database (or use EMP). Decide whether you want a tabular or form layout. In the default new module create a block using the wizard. Follow the prompts. Enjoy.

David

Report message to a moderator

Re: Add a record in form [message #127702 is a reply to message #127676]

Tue, 12 July 2005 23:41

bhoite_amol83
Messages: 110
Registered: June 2005
Location: Pune

Senior Member

Hi David,
I have done it what u r saying.
But, I want to add new record for user interface.
In form there r two buttons
1. ADD
2. SAVE
If u press ADD button all fields should be cleared and after inserting field values and Pressing button SAVE all fileds must be saved in database.
I m facing problem in coding level .
Waiting for ur reply.

Thanx in advance.

Report message to a moderator

Re: Add a record in form [message #127704 is a reply to message #127702]

Tue, 12 July 2005 23:54

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Add button = create_record;
Save button = commit_form;

You don't need to 'clear' fields, you just need a new record into which you will place new data. Clearing a field will clear the data from an existing record thereby updating that record with blank fields - not what you want, I think.

David

Report message to a moderator

Re: Add a record in form [message #127706 is a reply to message #127559]

Tue, 12 July 2005 23:57

bhoite_amol83
Messages: 110
Registered: June 2005
Location: Pune

Senior Member

Thanx a lot david.

And one more thing where i can find source code for forms 6i
i.e. Website or Link or any book

Report message to a moderator

Re: Add a record in form [message #127709 is a reply to message #127706]

Wed, 13 July 2005 00:02

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Go to http://www.oracle.com/technology/documentation/forms.html. Find 'Guidelines for Building Applications' and 'Form Builder Reference'. Download them and enjoy.

Depending on the versions of forms you are running, you may need to go to an associated page.

David

Report message to a moderator

Previous Topic:	How to create a menu driven list item that is expandable in Oracle Forms
Next Topic:	A small problem, please help me out (merged threads)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 11:17:10 CDT 2024