SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 6.4.208 preview] Float columns not visible in Notepad++

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 6.4.208 preview] Float columns not visible in Notepad++
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post [SA 6.4.208 preview] Float columns not visible in Notepad++ Reply with quote
The contents of float type columns are not visible in Code Execution Output when executing code from Notepad++.
Thu Jun 06, 2013 8:50 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
That's weird. What about decimal columns? Which connection method (ODBC, ADO, etc) do you use with Notepad++
Thu Jun 06, 2013 11:06 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
Weird, indeed. Decimals are fine. Perhaps it's related to libmysql.dll. Everything is okay when using ODBC connections.
Thu Jun 06, 2013 12:08 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
I'm not quite sure if the conversion from a binary float value to a display string takes place in the libmysql or in our code after the value is already retrieved. I know in fact that we have implemented separate database interfaces for different types of drivers.
I'm going to log a case and ask our developers to investigate this issue.
Thu Jun 06, 2013 5:19 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 804
Country: United States

Post Reply with quote
Tested in NP++ with SQL Server 2008 SP3. I can see floats ok. I know you are using MySQL here but I wanted to chime in on it.
Fri Jun 07, 2013 10:56 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
Thanks. It seems to be affecting different types of MySQL connections.
Mon Jun 10, 2013 2:59 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
It appears the issue is specific to libMySQL.dll versions 5.5.2x released relatively recently. Any older version of MySQL client should be fine. MySQL ODBC drivers seem to be fine too. I recommend copying an older version of libMySQL.dll to your computer and pointing SQL Assistant to the that version in the connection options (click the Options button on the Connect to Database dialog and in MySQL DLL parameter enter path to an older version).


Last edited by SysOp on Mon Jun 24, 2013 8:02 am; edited 1 time in total
Fri Jun 21, 2013 7:18 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
Good to know. Thanks for the feedback.
Fri Jun 21, 2013 11:08 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.