Forms6i combobox length problem ('Maximum Length' philosophie has changed)
Date: Mon, 11 Dec 2000 12:31:16 GMT
Message-ID: <912hek$46m$1_at_nnrp1.deja.com>
Hello,
we are upgrading from Forms 4.5 to Forms 6i and have some problems
belonging to
the text length with comboboxes
which are populated by a record group. The behavior has changed !
I'll describe this by an example. There is database column 'dbval'
which is of
type VARCHAR2(3) and
a combobox (Datatype CHAR, Maximum Length 3) which is populated by a
recordgroup
'RG_dbval'
(select txt_txt, txt_id from lut_txt where ...).
In 'Column Specifications' of the recordgroup are the length parameters:
txt_txt_id = 99,txt_id = 3
This are also the values of the database columns from txt_txt, txt_id
in table
lut_txt
rg_ok := populate_group('RG_dbval');
populate_list('myblock.dbval','RG_dbval');
In Forms 4.5
'Maximum Length' described the maximum length of the value which has to be
written to the database (txt_id->dbval), so if the displayed value (txt_txt) exceeds the length (>3) there was no problem, only if someone typed
a text which is not in the look-up recordgroup and the length of this text
exceeds the database column length
(3 in our example).
In Forms 6i
the philosophy has changed. Now the 'Maximum Length' describes the length of the
displayed value (txt_txt).
Populating the recordgroup succeeds, populate_list succeeds
(FORM_SUCCESS =
TRUE), but the list is not populated.
After setting 'Maximum Length' = 100 displaying all values of txt_txt is possible.
With this increasing 'Maximum Length' modification the behavior is the same as
with Forms 4.5:
a text which is not in the look-up recordgroup and the length of this text
exceeds the database column length can not be written to the database. Clear !
Now my question:
How do You handle the situation of typing texts which are longer than
the
database column size and are not in the recordgroup ?
With validation triggers ? But this is in my opinion too late for the
user.
Maybe a better solution is after loosing the focus of the item.
Do You know a tricky implementation, or have other suggestions ?
A second problem was a show stopper which maybe belongs to
POPULATE_LIST with
values which exceed the 'Maximum Length'.
Any experience with this ?
Please reply to my email address hrenfranz_at_lstelcom.com
Thanks
Hermann
Hermann Renfranz LS telcom AG
Phone: +49 7227 9535-26 Spectrum Management Applications FAX: +49 7227 8982 Im Gewerbegebiet 31-35 mailto:hrenfranz_at_lstelcom.com D77839 LICHTENAU http://www.lstelcom.com Germany
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Dec 11 2000 - 13:31:16 CET