SqlDbx Forum

SqlDbx

You are not logged in.

#2 Re: Sybase ASE » Show full decimal part » 2011-10-10 07:57:29

Bulanov A.

Rounding issue can be fixed via settings. Options -> Results -> Max Decimal = No rounding.
But there is a problem when money value is less then 0.1

select convert(money, 0.0123), convert(money, -0.0123), convert(money, 0.123), convert(money, -0.123), @@VERSION

Results in


No Column Name No Column Name No Column Name No Column Name No Column Name                                                                                                           
-------------- -------------- -------------- -------------- --------------------------------------------------------------------------------------------------------------------------
           123         0.-123         0.1230        -0.1230 Adaptive Server Enterprise/12.5.4/EBF 15446 ESD#8/P/Solaris AMD64/OS 5.10/ase1254/2105/64-bit/OPT/Sat Mar 22 04:05:46 2008

#3 Re: Suggestions and Feedback » Alternative layout » 2010-10-13 11:00:13

Bulanov A.

It is not convenient
1. I should toggle this option and move/resize windows for every connection I made.
2. Windows in floating layout do not resizing with the main form.
3. Maximize script editor and Maximize results are not working in floating layout.

#4 Suggestions and Feedback » Alternative layout » 2010-10-13 03:24:55

Bulanov A.
Replies: 4

Is it possible to make an option to bind a Results window to the right side of main form?
It will be very useful for a wide-screen monitor.

#5 Suggestions and Feedback » Couple questions/suggestions » 2010-09-10 04:56:21

Bulanov A.
Replies: 1

1. At some release a keyboard shortcut for 'Close active script tab' was changed from Ctrl+W (what is a common shortcut for MS Windows GUI) to Ctrl+D. Is it possible to change it back or provide a way to customize shortcuts.

2. When 'Scripting object level permissions' is on for Sybase ASE objects I've got something like
  grant execute on dbo.myProc to "public" which leads to  - Error (102) Incorrect syntax near 'to'.
grant execute on dbo.myProc to public works fine.

My Sybase version is SQL Server/12.5/P/Generic/OS/1/OPT/Sat Jun 30 00:01:37 PDT 2001

Board footer

Powered by FluxBB