Re: Sorting (ORDER BY) Problem of a column in Forms 4.5

Jens U. Veigel wrote:
>
> 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

Make sure that in your form the type is also identified as a numeric type. It looks like your form is seeing the column as character rather than numeric.

--TRW

-- 
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Tim Witort            ||  He is not silent.  He is not  |
| trw_at_medicalert.org    ||  whispering.  We are not quiet |
|                       ||  we are not listening.         |
| Pin: TZ, only one :^( ||             - Out of the Grey  |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||