agree with Peter Luijer. BLOBs and TEXT (in MsSQL & MySQL) cannot be indexed, so it cannot be searched by locate.
On 7/16/10, Prakash Shirodkar <[email protected]> wrote: > I agree with with Peter. > > On Fri, Jul 16, 2010 at 4:00 AM, Peter Luijer <[email protected]> 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] > > > > ------------------------------------ > > ----------------------------------------------------- > Home page: http://groups.yahoo.com/group/delphi-en/ > To unsubscribe: [email protected]! Groups Links > > > > -- "Sabbe Satta Bhavantu Sukhitatta - Semoga Semua Makhluk Hidup Berbahagia" Se Hai Ce Nei, Kai Siung Ti Ye - Di Empat Penjuru Lautan, Kita Semua Bersaudara Ko Ko Cay Siang - Yang Tinggi Masih Ada Pula Yang Melebihi Oleh Karena Itu Jangan Takabur, Jumawa, dan Terlalu Berbangga Diri Niksen - Pulsarian Bandung 782 members of KORMOT COMMUNITY KC #008 D 5470 WQ
