Sorting (ORDER BY) Problem of a column in Forms 4.5
From: Jens U. Veigel <jens_at_deutschware.com>
Date: 1997/03/27
Message-ID: <333a8408.171618464_at_news.aud.alcatel.com>#1/1
Date: 1997/03/27
Message-ID: <333a8408.171618464_at_news.aud.alcatel.com>#1/1
[Quoted] Hi Pro's
My problem is that when I sort a column with datataype number(4). The sort does not work. in forms !
it comes out like:
1, 10, 100,101,102,103,104,105,106,107,108,109,11,110,111
.....119,12, 120,121 etc
instead of 1, 2, 3, 4,5,6,7... 10, 11, 12.....
The query works when I use SQL*Plus
Don't really want to change the datatype of the column sice it has data in in already.
Any suggestions are appreciated.
Jens
jens_at_deutschware.com Received on Thu Mar 27 1997 - 00:00:00 CET