SqlDbx
You are not logged in.
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
Offline
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.
Offline
I'm using Oracle 10g Enterprise Edition Release 10.2.0.4.0, 64bi.
Thousands separator is off...
Offline
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.
Offline
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
Offline