trichview.com

trichview.support




Re: Research using LIKE in binary field.


Return to index


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" <svt@trichview.com> escreveu na mensagem

news:3da5a43d$1@support.torry.net...

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