memo restriction??

[Andrej Gobec]

Hello!

I have a query based on a table with a couple of fields having Memo
datatype.

The problem is that this query seems to show only first 255 or so characters
of these Memo fields
whenever I run it. Which is bad! And I don't have a clue why this happens or
how to get past this?

Why would a Memo have the restriction of a Text datatype in a query??

Am I doing something wrong? What should I look at ... Has anyone seen this
before? I'm just lost
and don't have a clue, what's happening?!

thank you in advance,
Andrej

 

[Rick Brandt]

Hello!

I have a query based on a table with a couple of fields having Memo
datatype.

The problem is that this query seems to show only first 255 or so characters
of these Memo fields
whenever I run it. Which is bad! And I don't have a clue why this happens or
how to get past this?

Why would a Memo have the restriction of a Text datatype in a query??

Am I doing something wrong? What should I look at ... Has anyone seen this
before? I'm just lost
and don't have a clue, what's happening?!

This is normal behavior if you are attempting to sort or group on the memo
fields, or are applying any sort of format to them. Also if you are using
the DISTINCT clause. A plain-vanilla SELECT query should return the entire
memo field.