SqlDbx Forum

timeco

Member

Bug: Invalid sort of decimal numbers

Hi,

I noticed problems when editing and sorting decimal numbers in Sqldbx. It seems the numbers are sorted as strings, this is the outcome:

Descending sort:
2.1
3
2
1

Ascending sort:
1
2
3
2.1

This error comes up when modifying table and trying to edit those decimal numbers:

I'm using Sqldbx version 4.5.

Thanks for your help,
Goran

sqldbxhelp

Administrator

Re: Bug: Invalid sort of decimal numbers

Sorting was fixed while ago and I can not reproduce it. What database you use.
I assume you had commas in your number when trying to update database.
Currently update will fail if you have thousands separator.

timeco

Member

Re: Bug: Invalid sort of decimal numbers

I'm using Oracle 10g Enterprise Edition Release 10.2.0.4.0, 64bi.
Thousands separator is off...

timeco

Member

Re: Bug: Invalid sort of decimal numbers

This is still an issue for me. Is there a possibility to debug the statement SqlDbx is issuing to Oracle through Application log ? This way we could see why the update fails.

sqldbxhelp

Administrator

Re: Bug: Invalid sort of decimal numbers

This will be enabled in a next version.
If you use Pro version send email to support and they will let you know how to get fixed version