Any text over 240 characters in length is stored in a linked file, so your only option is to load the blob field into a string and search that. If you are storing richtext you have to keep in mind tha the meta-data will be seen by your search routine, so it may be more practical to load it into a hidden richedit for searching and create a listbox or whatever to show intermediate results, like you'd see in Outlook Express.
Dave --- On Mon, 8/2/10, haroutbulbulian2000 <[email protected]> wrote: From: haroutbulbulian2000 <[email protected]> Subject: [delphi-en] Re: ado "locate " search in a mdb memo field To: [email protected] Date: Monday, August 2, 2010, 8:00 AM You can make your Own Searching prcedure by moving through the Records in the table and compare your text (or Lines) to the memo. --- In [email protected], Prakash Shirodkar <prakash.shirod...@...> wrote: > > I agree with with Peter. > > On Fri, Jul 16, 2010 at 4:00 AM, Peter Luijer <p.lui...@...> 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: [email protected] <delphi-en%40yahoogroups.com> [mailto: > > [email protected] <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] > [Non-text portions of this message have been removed]
