Hello Andries,
As far as I know (though I'm not a database expert), memo-fields are stored as blobs and can't therefor not be used to index or sort. Maybe someone can share a better light at this, but it's the only thing I could think of. Greetz, Peter. (AKA VideoRipper on NLDelphi) _____ From: [email protected] [mailto:[email protected]] On Behalf Of Andries Bos Sent: donderdag 15 juli 2010 22:15 To: delphi advanced group Subject: [delphi-en] ado "locate " search in a mdb memo field Hello all, I build a small application that displays some information within TDBEDit and TDBMemo field. The record that should be dispayed is connection to a 'locate' command that actually search in all field of the database. all went well, except searching in the memo field: This will result in a EOleExceptionand expanded with an error " 'sorting order' that could not be used" (sorry, the proper eror message is in Dutch: 'De sorteervolgorde kan niet worden toegepast"). I connect to a mdb database via ado. I have search the web for problems related to 'locate ' and memo field but could not find any articles related to this problem; Only some examples where they use the locate to search within fields. Could I use locate to search within a mdb memo fields? Regards Andries The netherlands ________________________________ Goedkoop en snel uw dia's laten scannen vanaf / from E 0,08c www.scancare.nl ________________________________ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
