Devart Forums

Posted: **Thu 05 Apr 2018 18:52**

Hello
Using dbForge Query Builder for SQL Server (Standard edtion version 3.9.163 OS Version: Windows 7 X32)

When running a query in "Results as Text" mode on "varchar(max)" columns, "(Long Object)" is returned.
For instance:
SELECT top 1 DS_DON_COM_REF_ALL from JA1.DONCREF;
DS_DON_COM_REF_ALL
------------------
(Long Object)
1 records fetched

When running the same query in "Results as Grid" mode, the data is displayed properly.

I've ran the same query on other database products (SSMS 2012 server) and the the data is properly returned when running in "Results as Text" mode

I cannot use "Results as grid" mode since we use an automated tool which scan text results from multiple queries.

Any help would be... helpful !

Thanks!

Posted: **Fri 06 Apr 2018 06:21**

We will investigate this issue and will answer you as soon as possible.

Devart Forums

select on varchar(max) returns (Long Object)

select on varchar(max) returns (Long Object)

Re: select on varchar(max) returns (Long Object)