Post reply

Ado recordset does not return value from varchar(MAX) field

  • October 26, 2011 at 1:22 pm

    #245228

    Some records in this field have len = 22000. When I run the query (Select Summary From MyTbl Where ID=SomeiD) in ss2k8 - everything is ok. When I run this query from Access form intellisense above the MyRs(0) shows a set of small squares with occasional alfanumerics, and nothing can be seen in the appropriate textbox. When I change the query - Select Cast(Summary as varchar(8000)) From MyTbl Where ID=SomeiD everything is ok, if you do not count that the result would be truncated to 8000 characters (alas ....)

    Any idea?

  • October 26, 2011 at 1:34 pm

    #1399891

    Ha-ha! Select Cast(Summary as TEXT) worked! long live ME!

  • October 26, 2011 at 1:55 pm

    #1399901

    TEXT is being deprecated. Use varchar(max) instead.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • October 26, 2011 at 2:43 pm

    #1399918

    but this was a starting point - varchar(max) does not work in this context

  • October 26, 2011 at 6:35 pm

    #1399966

    You would be more likely to get relevant help on Microsoft Access if you're in the forum for Access ... http://www.sqlservercentral.com/Forums/Forum131-1.aspx. Good luck.

    └> bt


    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 27, 2011 at 9:05 am

    #1400226

    Thanks, I'll try ...

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply