Home » Developer & Programmer » Forms » Can we Change Database Column Name in Run Form (Developer 6I, Database 10g window XP)
Can we Change Database Column Name in Run Form [message #405263] Wed, 27 May 2009 04:35 Go to next message
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
Well i have a situation where i have 1 table with tablour style and i have 1 text item which relate to same table now i need when i run form and click one button its will change text item database column name its is possible to change database column name ?


Regards


Shahzaib
Re: Can we Change Database Column Name in Run Form [message #405269 is a reply to message #405263] Wed, 27 May 2009 04:41 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Form builder help will tell you, for every item in the property palette, whether or not it can be set programatically.

So what does it say?
Re: Can we Change Database Column Name in Run Form [message #405271 is a reply to message #405263] Wed, 27 May 2009 04:54 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
i can't find any think which could change text item database column name


Regards


Shahzaib
Re: Can we Change Database Column Name in Run Form [message #405274 is a reply to message #405263] Wed, 27 May 2009 04:59 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
that'd be because you can't.

Create two items, one for each column and use the button to change which one is visible.
Re: Can we Change Database Column Name in Run Form [message #405279 is a reply to message #405263] Wed, 27 May 2009 05:18 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
Ya i understand i also thinking about this but i don't think this will help me a lot because i have more then 10 different text item in 1 form and i have over 50 form to create like this so i can do with that's technique is well but i want any other idea if that exist


Regard


Shahzaib
Re: Can we Change Database Column Name in Run Form [message #405300 is a reply to message #405279] Wed, 27 May 2009 05:55 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
shahzaib_4vip@hotmail.com wrote on Wed, 27 May 2009 11:18
i have more then 10 different text item in 1 form and i have over 50 form to create like this


really?

ouch!

If you're doing that this much that suggests to me there's something seriously wrong with your data model. This is not something you should normally have to do.

You could try basing your blocks on procedures - that'll give you far more control over where stuff is put in the database.
But that makes things more complicated.

I'd look long and hard at your table design and see if you change it to avoid having to do this.
Re: Can we Change Database Column Name in Run Form [message #405325 is a reply to message #405263] Wed, 27 May 2009 06:46 Go to previous message
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
Thanks for your reply cookiemonster



Regards


Shahzaib Ismail


Previous Topic: how make pass word
Next Topic: scrollbar on tab pages
Goto Forum:
  


Current Time: Fri Sep 20 12:38:55 CDT 2024