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


[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

Original text of this message