Index corrupts memo field in concatenated table
to solve performance problems I added one index to table A. This table is joined within a query with table B. Adding an index mangles the output of memo fields in table B. When I drop the index everything is fine.
Hopefully I've made it clear if interested I could add more information about the request itself.
Any ideas on this?
Cheers, Ramon
+1
a source to share
1 answer
It appears that these issues are related to common errors in the handling of memo fields. When I change the request function from "group by" to "first" as shown here http://allenbrowne.com/bug-18.html everything works fine.
Oddly enough, the error only happened after the index was added.
Ramon
+1
a source to share