| frm-40831 [message #170382] |
Wed, 03 May 2006 08:58  |
shashikoor
Messages: 25
Registered: April 2006
Location: india
|
Junior Member |
|
|
hello everybody,
i've a problem. when i run one of my forms a form builder error(frm- 40831) is being displayed saying 'Truncation occured. Value too long for field xxxx'. i tested and found that there is no wrong with the field i've chosen in my form.
can any body pls help me.
thanks in advance.
|
|
|
|
|
|
| Re: frm-40831 [message #360091 is a reply to message #170382] |
Wed, 19 November 2008 10:09  |
GBudjak
Messages: 1
Registered: November 2008
Location: Toronto
|
Junior Member |
|
|
This is the fix for this problem.
(Especially if you are using Index Organized Tables)
FRM-40831 When querying from Indexed Organised Table in Forms
Problem Description:
====================
Performing a query in Forms, which is referring to an indexed organised table, with a longer rowid causes FRM-40831 - value too long for field ROWID. Though the query gets successfully executed with rowid full (No Truncation).
Solution Description
====================
Change block property Key Mode to Updatable or Non-Updatable and set item property Promary Key to Yes for all items that correspond to an index column in
the index-organized table.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
