| Text Item [message #406927] |
Sun, 07 June 2009 15:35  |
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  |
 |
Littlefoot
Messages: 21823
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 |
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 |
|
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
