UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> The string returned by the builder was too long.    
 
   
Mansell
post Jul 16 2007, 10:38 AM
Post #1

UtterAccess Enthusiast
Posts: 57
From: Wolverhampton, UK
Hi,

I'm trying to add to an already complicated query but when doing so I get a message stating...

The String returned by the Builder was too long.
The result will be truncated.

At this I lose half the code I've already added.

Any ideas how I am able to resolve this? The perfect solution would be to be able to extend the allowable string length.

Thanks.


--------------------
Phil
_________________
"If something is hard, then it is probably not worth doing." Homer Simpson.
Go to the top of the page
 
+
niesz
post Jul 16 2007, 10:44 AM
Post #2

Utter A-fishin'-ado
Posts: 17,957
From: Cincinnati, Ohio, USA . . . ><((((°>
There is a finite number of characters that the Builder can handle. If you post your SQL we may be able to show you ways of shortening it.


--------------------
Walter Niesz | Microsoft Access MVP 2007-12 | Link Library | Function Library | UtterAccess Wiki TOC
"By iron, iron itself is sharpened. So one man sharpens the face of another."
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 23rd July 2014 - 09:10 PM