From: hatzinger_m@bmwf1f.bmwf.gv.at Newsgroups: comp.databases.oracle Subject: Re: SQL*FORMS List of Value bug? Message-ID: <1993Feb2.090900.63@bmwf1f.bmwf.gv.at> Date: 2 Feb 93 09:09:00 +0100 References: Organization: (Klaus-Michael Hatzinger), BMWF, Vienna Lines: 44 In article , guy@mais.hydro.qc.ca (Guy Harel) writes: > Hi, > > I need your input on the following little puzzle: > > Given: > create table t1 (n1 number(1)) > > ...filled with 8 rows (1,2,3,4...8), if I create a default bloc on it > and define a list of values: > > select n1 into :n1 from t1 > > ...I have only zero`s in the KEY_LIST pop-up. (??!!) > > While if I do the same with a table having a field NUMBER(2), I have > the correct value in the pop-up. > > Any clues? > > Thanks. > -- > -- -- Truncating the last Character in LOV's is a known Oracle-bug in a special Version of SQL*Forms 3.0. But I think you can solve it with Bugfix 127076. kind regards Mike ================================================================================ ^ Federal Ministry of Science and Research B | M <-------------------------------------------------------------------------+----> Computer Center W | F | Ing. Klaus-Michael Hatzinger mail: hatzinger_m@bmwf1f.bmwf.gv.at | Bankgasse 1/209 phone: 0043-222-53120/5188 | 1014 Vienna, Austria fax: 0043-222-53120/5155 V ================================================================================