I agree with with Peter. On Fri, Jul 16, 2010 at 4:00 AM, Peter Luijer <p.lui...@hccnet.nl> wrote:
> > > 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: delphi-en@yahoogroups.com <delphi-en%40yahoogroups.com> [mailto: > delphi-en@yahoogroups.com <delphi-en%40yahoogroups.com>] 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] > > > [Non-text portions of this message have been removed]
