Truncation

[Bigley]

Anyone have any idea why when I return a long varchar from SQL through MS Query to a mail merge document that it gets truncated down to 256 characters. I cannot establish whether it is the SQL database or the ODBC connection or the MS Query that is doing it!!!

 

[foxdev]

Its probably MSQuery; we get the same problem in SQLS's Query Analyzer, but connecting via ODBC using something like Visual FoxPro returns the full text.

Also make sure you are not explicitly setting SET TEXTSIZE; the default should work fine. Robert Bradley

http://www.foxdev.com/

Do you have too much money? Visit

http://www.agrainofhope.org

 

[Bigley]

Thanks for the reply Robert.
I have come across the truncation in query analyser before but that can be resolver by going into current connection option ->Advanced and resetting the character limit.
My problem has taken a curious twist though. I have discovered that whilst it happens with Office 2000 it does not happen with Office 97.
So you are definately right when you say it is MS Query - which although that means I am in the wrong forum, doesn't get me any closer to a solution.
Where is the SET TEXTSIZE option?

Thanks again
Bigley

 

[Bigley]

I got it....Microsoft's Service pack 1 for Office 2k resolves the truncation problem.........incase anyone cares!