Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
select * from cliente
where nome like :pnome or nome is null
SELECT * FROM cliente WHERE nome LIKE LesPaul or [b]LesPaul[/b] is null
If EditBox.Text <> '' then
SQL.ADD('SELECT * FROM Cliente WHERE nome LIKE ' + QuotedStr('%' + EditBox.Text + '%'))
else
SQL.Add('SELECT * FROM Cliente');
SQL.Active := True;
select * from cliente
where nome like :pnome
...
SQLCommand := 'SELECT * FROM cliente ' +
'WHERE nome LIKE ' + QuotedStr(Edit1.Text) +
' OR ' + ComboBox1.Text + ' IS NULL';
...