Truncated Output

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

I see that my previous post is about to drop off into
oblivion (page 2), which is usually the case when my
questions are too value or confusing. I have the
following code, thanks to MS ACCESS MVPs:

SELECT DISTINCT BIBLE.D, Concatenate("SELECT [E] FROM
BIBLE WHERE [D]=""" & [D] & """ ORDER BY KeyID") AS Phrase
FROM BIBLE

This works well, however some of the contents of "Phrase"
are truncated because they exceed the 255 character
limit. Could someone please tell me how to solve this
problem, say by turning the output in "Phrase" into a memo
field? I would deeply appreciate your help.
 
It looks to me the "DISTINCT" Keyword is the problem since JET will have to
compare Strings to decide wthether 2 Strings are the same or not. I think
for efficiency, JET is design to truncate String values to 255 character max
before comparing them.

You will need to either remove the "DISTINCT" predicate or get some other
way to obtain the full String values.
 
And what would be "some other way"?
-----Original Message-----
It looks to me the "DISTINCT" Keyword is the problem since JET will have to
compare Strings to decide wthether 2 Strings are the same or not. I think
for efficiency, JET is design to truncate String values to 255 character max
before comparing them.

You will need to either remove the "DISTINCT" predicate or get some other
way to obtain the full String values.

--
HTH
Van T. Dinh
MVP (Access)



I see that my previous post is about to drop off into
oblivion (page 2), which is usually the case when my
questions are too value or confusing. I have the
following code, thanks to MS ACCESS MVPs:

SELECT DISTINCT BIBLE.D, Concatenate("SELECT [E] FROM
BIBLE WHERE [D]=""" & [D] & """ ORDER BY KeyID") AS Phrase
FROM BIBLE

This works well, however some of the contents of "Phrase"
are truncated because they exceed the 255 character
limit. Could someone please tell me how to solve this
problem, say by turning the output in "Phrase" into a memo
field? I would deeply appreciate your help.
Click to expand...


.
Click to expand...
 
Depends on what you need (which I don't know, not even your Table
Structure). For example, you can construct the String *outside* the Query.

The main question you need to ask yourself is why you need "DISTINCT" in the
first place.
 
Back
Top