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

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