trichview.support
Research using LIKE in binary field. |
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 |
Powered by ABC Amber Outlook Express Converter