Research using LIKE in binary field.

Return to index

Author

Message

Aleksey Aguiar Baranenko

Posted: 10/09/2002 21:21:23

As it could effect a search, using the LIKE of the SQL, in a binary field of

a table that uses the RichView. As normally one becomes with a Memo field.

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