Research using LIKE in binary field.
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.
procedure TForm1.PesquisaClick(Sender: TObject);
Campo : String;
Campo := 'TO BE SEARCHED WORD'; //Normal word
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.
Powered by ABC Amber Outlook Express Converter