trichview.support
Re: Research using LIKE in binary field. |
Author |
Message |
Aleksey Aguiar Baranenko |
Posted: 10/10/2002 21:19:43 Yes, the DBRichView component, uses in the database a Binary field, therefore compo Memo does not function. It has as to make this type of consultation? "Sergey Tkachenko" <[email protected]> escreveu na mensagem news:[email protected]... I do not know. Does it work dor binary fields? > > Example: > > procedure TForm1.PesquisaClick(Sender: TObject); > Var > Campo : String; > begin > Query1.Close; > Query1.SQL.Clear; > Campo := 'TO BE SEARCHED WORD'; //Normal word > Begin > Query1.SQL.Add('SELECT * ' + > 'FROM Principal WHERE '); > Query1.SQL.Add(' Conteudo LIKE ''%' + Campo + '%'''); //Conteudo - > Binary field of one prices of the MSAccess, that is used in the DBRichView. > End; > Query1.Open; > End; > > At > Aleksey > > > > |
Powered by ABC Amber Outlook Express Converter