HomeFlySpeed SQL QueryProblem with 'WideMemo' in 2.9.0.0

Problem with 'WideMemo' in 2.9.0.0


Hi Sergey,
I've plenty of mySQL tables with 'TINYTEXT' field type.

In 2.7.12, I could select a bunch of records and with Ctrl-C copy them to Excel. In 2.9, I get in Excel only a text "(WIDEMO)". So, now I need even for just a few lines go through 'Export'

This is a real killer for 2.9! Hope this can be fixed on short notice!

Kind regards, Stefan
Stefan_E | email
February 27 2011, 05:53 PM
Dear Stefan,

I tested the tool with native connection to MySQL (not Generic ODBC or OLE DB) and the tool shows tinytext fields content in the grid competely, so I can copy it to Excel fine. Please provide us more information about your connection.
Sergey Smagin | email
12 hours, 6 mins since original post
Hi Sergey,
I use native MySQL connection (Connection Type = MySQL in Connection Properties). In the grid, I see correct values. I see "(WIDEMEMO)" when I
- paste into Excel
- paste into an ASCII editor such as UltraEdit
- single-click into a cell of the grid to copy only one cell
I'm running Windows 7 (32 bit), MySQL 5.1.41 and FlySpeed 2.9.0.0

Thanks for your help, Stefan
Stefan_E | email
20 hours, 40 mins since original post
Hi Sergey,

any update? Didn't see it mentioned in 2.9.0.2 change summary (but also didn't have time to try yet).

Stefan
Stefan_E | email
3 days since original post
Dear Stefan,

This bug is fixed in version 2.9.0.4
Sergey Smagin | email
5 days, 14 hours since original post
Dear Sergey,
...perfect, thanks!

Stefan
Stefan_E | email
5 days, 20 hours since original post
This topic is closed