Home » Developer & Programmer » Forms » Text Item (9i)
Text Item [message #406927] Sun, 07 June 2009 15:35 Go to next message
MR[T]
Messages: 62
Registered: March 2009
Member
Hello

I created a text item on EMP Block, and set its
DATABASE property-COLUMN NAME to Empno . Program Giving me an error

"FRM-30431: Warning: Duplicate column name EMPNO in block EMP."


and if i do not assoicate it with any column name then its give me an error at Run-Time,

"ORA-00904: "ITEM6": invalid identifier"





Regards
MR[T]
Re: Text Item [message #406952 is a reply to message #406927] Mon, 08 June 2009 00:05 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Obviously, there's another item in "emp" block whose source is "empno" column from a table. As we know, you can not create a table which would contain two columns with the same name. Therefore, change its source - if it is a database item.

Another error says that you've created an item called "item6" and set it to be a database item, but Forms was unable to find a column "item6" in a table that is a source of the "emp" block. Therefore, it appears that you'll have to ALTER TABLE and add column named "item6" (which is probably not what you are going to do), or set "item6"'s database belonging property to "no" (which is much closer to the truth).

However, exact action depends on what you meant to do. What was it? What do you plan to do with that item? Is it based on a database column? If so, what is its name? If not, then it is not a database column.
Re: Text Item [message #407153 is a reply to message #406927] Mon, 08 June 2009 13:30 Go to previous messageGo to next message
MR[T]
Messages: 62
Registered: March 2009
Member
Thanks alot Littlefoot
Actually I am learning Oralce 9i Forms these days .I didnt plan anything .
I am just trying to understand why do we create Text item .?

Regards
MR{T]
Re: Text Item [message #407158 is a reply to message #407153] Mon, 08 June 2009 15:28 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, I create an item when I need it. I usually don't create them because of being boring.
Previous Topic: its urgent!!!!!!!!!!
Next Topic: sound in form
Goto Forum:
  


Current Time: Sat Dec 03 16:32:06 CST 2016

Total time taken to generate the page: 0.06092 seconds