Record from a meno data type text field truncate on a unquie value query

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

After executing a "Select" query with the query property set to "Unique
Value", I noticed that on some "Memo" data type text field where the length
of the text string is longer than 255 characters, the first 255 characters
disappear in the result. Is there a way to execute a "Unique Value" query
without the "Memo" data type text string truncate. Thanks.
 
No, the Unique constraint means that Jet has to search within each field to
check that the values are unique. And to save time in searching, it only
searches, and returns, the first 256 characters. However, if you dont
actually need the Unique constraint on the memo field itself, you can set up
a query including the Unique, which returns a recordset containing the IDs
of the records you want, then use that as the source of a normal query,
joined to the memo field and the ID.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top