How to apply distinct on memo datatype in visual basic access 2007

Question

0.00/5 (No votes)

See more:

Hello,

I am using the Visual basic access 2007 to create a Tool.Now my getting stuck as I have to apply distinct on Memo data type.But I am getting the error

"the field is too small to accept the amount of data you attempted to add access 2010 memo fields.Try inserting or pasting less data"

Please help me to out from this problem.

Thanks,
Naveen

What I have tried:

I have tried the below mentioned query to get the distinct records from memo field.

select distinct CAS from table1.

Posted 20-Feb-16 2:04am

Rohit from Delhi

Updated 20-Feb-16 2:26am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2016-02-20T02:26:00

The short answer is that you can't.

However, you could calculate a hash value on the field, store that in another (non-memo) column then you can use

SQL

select distinct CASasHash from Table1

to identify the records you want.

There are no in-built functions to calculate the hash, but there are several examples available if you google... in fact the first one I came across when trying to find you a reference was this ... UtterAccess Forums >"indexing" Memo Fields[^]

It does beg the question as to why you would want to do this - you may like to rethink your data model.