[SOLVED] SQLite3 Search
lazarus / 16-Databases

----------------------------------------------------------------------
Pe3s · 2021-12-14 17:56

Hello, what do I have to correct in the code so that it searches from
a letter?
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i  
SQLQuery1.Close;  if Edit1.Text = '' then  SQLQuery1.SQL.Text :=
'SELECT * FROM database'  else begin    SQLQuery1.SQL.Text := 'SELECT
* FROM database WHERE Name ='+QuotedStr(Edit1.Text);  end; 
SQLQuery1.Open;

----------------------------------------------------------------------
paweld · 2021-12-14 18:19

1. Use the parameters, eg
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
SQLQuery1.SQL.Text := 'select * from tabela where
kolumna=:kol';SQLQuery1.ParamByName('kol').AsString :=
'wartość';SQLQuery1.Open; 
2. Use LIKE operator: https://www.w3schools.com/SQL/sql_like.asp

----------------------------------------------------------------------
af0815 · 2021-12-14 18:21

use parameter see https://wiki.freepascal.org/Working_With_TSQLQuery 
Parameters in TSQLQuery.SQL

----------------------------------------------------------------------
Pe3s · 2021-12-14 20:10

Thank you