OraFAQ Forum: Forms » How to us ALTER TABLE in forms

Home » Developer & Programmer » Forms » How to us ALTER TABLE in forms (form builder, 10g, xp)

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

How to us ALTER TABLE in forms [message #470881]

Wed, 11 August 2010 05:03

ShinTec
Messages: 8
Registered: May 2010

Junior Member

hi forum
can you use alter table command to disable/enable constraints in a form if you can how, if you cant why and is there another solution
thanks you in advance

Report message to a moderator

Re: How to us ALTER TABLE in forms [message #470883 is a reply to message #470881]

Wed, 11 August 2010 05:05

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

Senior Member

If you're doing that there's almost certainly something wrong with your design.
What are you trying to achieve?

Report message to a moderator

Re: How to us ALTER TABLE in forms [message #470909 is a reply to message #470883]

Wed, 11 August 2010 06:37

ShinTec
Messages: 8
Registered: May 2010

Junior Member

Im trying to delete a existing record from a table but it keeps giving me the ORA-02292 error

Report message to a moderator

Re: How to us ALTER TABLE in forms [message #470910 is a reply to message #470909]

Wed, 11 August 2010 06:42

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

Senior Member

So you think disabling the foreign key is good idea?!?!?!
How will you enable it again when you're done?

Just delete the child records first.

Report message to a moderator

Re: How to us ALTER TABLE in forms [message #470936 is a reply to message #470910]

Wed, 11 August 2010 08:52

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Quote:

Hi forum
can you use alter table command to disable/enable constraints in a form if you can how, if you cant why and is there another solution
thanks you in advance

This is not a good development approach.

As said cookiemonster Just delete the child records first.

Regards,

Irfan

Report message to a moderator

Previous Topic:	checking to see if a text item is empty
Next Topic:	client_ole2.create_obj('Excel.Application) not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:50:39 CDT 2024