OraFAQ Forum: Forms » extra columns added to table, not able to insert in form

Home » Developer & Programmer » Forms » extra columns added to table, not able to insert in form

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

extra columns added to table, not able to insert in form [message #147660]

Fri, 18 November 2005 23:25

gautamvv
Messages: 254
Registered: June 2005

Senior Member

my original table structures is as follows

add_qual_master(table)

ser_no

reg_no

dr_name

add_qual_detail(table)

ser_no

Qualification

college

Y_O_P

Date_ofReg

i already have a form where i can enter values and save it

now i have added two extra columns to the tables..

one column i added to master, and one to detail..in oracle
i have made changes in datablock wizard, ie, added the extra

column for the master databloc in dbwizard, similarly in

detail datablock wizard, i included the extra column in

database columns list

but why is it that when i enter data, only the detail ones

are getting saved? the extra master column is not getting saved

Report message to a moderator

Re: extra columns added to table, not able to insert in form [message #147662 is a reply to message #147660]

Fri, 18 November 2005 23:48

kiran
Messages: 503
Registered: July 2000

Senior Member

Did you keep DATABASE_ITEM = Yes for the new item that you added to the form master block.Kindly check that.

--Kiran.

Report message to a moderator

Re: extra columns added to table, not able to insert in form [message #147663 is a reply to message #147660]

Fri, 18 November 2005 23:57

gautamvv
Messages: 254
Registered: June 2005

Senior Member

it is set to yes, still its not coming

is there a way to set column name property?

Report message to a moderator

Re: extra columns added to table, not able to insert in form [message #149777 is a reply to message #147663]

Sun, 04 December 2005 23:01

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

Senior Member
Account Moderator

Yes ... type it into the field. Have you recompiled your form using Ctrl-Shft-K (compile all), not just Ctrl-K (compile) and then done your Ctrl-T (generate)?

David

Report message to a moderator

Previous Topic:	Go Block on forms
Next Topic:	Sending Emails from Forms 6i with Attachment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 02:16:05 CDT 2024