• Registered: 2014-02-17
  • Posts: 365

Topic: Example SQLITE Search By Array Script Of String

I try find function regexp in sqlite have not
but  i try create script create script sql for search value

Can input multiple value  in one line for search by " "


IF MySQL USE  regexp

where column regexp '123|456'

Screen Short
https://i.imgur.com/1vGS1iY.png

Open Code

procedure Form1_Edit2_OnChange (Sender: TObject);
var
i : Integer ;
original_string : String;
arr_string : Array Of String ;
begin
    Form1.Memo2.Clear ;
    original_string := Trim(Form1.Edit2.Text);
    Form1.Memo2.Lines.add('SELECT * FROM city WHERE 1 = 1');
    arr_string := SplitString(original_string,' ');
    For i := 0 To Length(arr_string) -1
    Do
    Begin
        Form1.Memo2.Lines.add('AND tip LIKE "%'+arr_string[i]+'%"')
    End;
    Form1.TableGrid1.dbSQL := Form1.Memo2.Text ;
    Form1.TableGrid1.dbSQLExecute;
    Form1.TableGrid1.BestFitColumns(bfboth);
end;
begin
end.
Post's attachments

Attachment icon ScriptArray.zip 456.13 kb, 375 downloads since 2019-02-28 

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: Example SQLITE Search By Array Script Of String

Thank you for the example.

Dmitry.