DB Filter Data Manipulation Language Array DML FireDAC TDataSet.Filter

 Array DML FireDAC

The Array DML execution technique submits a single DBMS command with an array of parameters. Each command parameter has an array of values, ...
Array DML (FireDAC) - RAD Studio - Embarcadero DocWiki
https://docwiki.embarcadero.com/RADStudio/Sydney/en/Array_DML_(FireDAC)

https://docs.oracle.com/cd/E11882_01/appdev.112/e10766/tdddg_dml.htm#TDDDG23000
About Data Manipulation Language (DML) Statements
Data manipulation language (DML) statements access and manipulate data in existing tables.
In the SQL*Plus environment, you can enter a DML statement after the SQL> prompt.
In the SQL Developer environment, you can enter a DML statement in the Worksheet. Alternatively, you can use the SQL Developer Connections frame and tools to access and manipulate data.
https://zh.wikipedia.org/wiki/%E8%B3%87%E6%96%99%E6%93%8D%E7%B8%B1%E8%AA%9E%E8%A8%80

https://docwiki.embarcadero.com/Libraries/Alexandria/en/FireDAC.Stan.Option.TFDResourceOptions.ParamCreate

https://docwiki.embarcadero.com/RADStudio/XE7/en/Working_with_Commands_(FireDAC)

https://docwiki.embarcadero.com/Libraries/Alexandria/en/FireDAC.Stan.Option.TFDResourceOptions.ParamCreate

https://www.embarcadero.com/cn/products/rad-studio/firedac

https://en.wikipedia.org/wiki/Data_manipulation_language

https://www.geeksforgeeks.org/sql-ddl-dql-dml-dcl-tcl-commands/


TDataSet.Filter
A TTable.Filter isn't a SQL query. LIKE isn't supported (neither is IN). The supported operators are =, <>, >, <, >=, '<=,AND,NOTandOR`, according to the documentation
For more complicated filtering, use the TDataSet.OnFilterRecord event:
procedure TForm1.Table1FilterRecord(Dataset: TDataset; var Accept: Boolean);
begin
  // Don't remember if D7 supports DataSet[FieldName] syntax; if not,
  // use DataSet.FieldByName instead, or a persistent field.
  Accept := Pos(Edit_Search.Text, DataSet[SearchField].AsString) > 0;
end;
delphi Setting_the_Filter_Property
docwiki.embarcadero.com/RADStudio/en/Properties#Array_Properties
docwiki.embarcadero.com/RADStudio/en/Properties#Index_Specifiers
https://docwiki.embarcadero.com/Libraries/Alexandria/en/Data.DB.TDataSet.OnFilterRecord
https://docwiki.embarcadero.com/Libraries/Alexandria/en/Data.DB.TDataSet.Filter
Filtering ClientDataSets  
https://edn.embarcadero.com/article/29271

filtered屬性設定為true
Data.DB.TDataSet.Filter - RAD Studio API Documentation
Data.DB.TDataSet.Filter. Up to Parent: TDataSet. Delphi ... following run-time example shows how to assign that filter expression to the Data.DB.TDataSet.


Starting and Exiting Windows ISQL - Delphi and InterBase
https://www.delphipower.xyz › interbase
The ISQL window can also be opened from the Server Manager by choosing Tasks I Interactive SQL or clicking on the corresponding Speedbar ...
Interactive SQL Window - InterBase - Embarcadero DocWiki
https://docwiki.embarcadero.com › Intera...
The IBConsole isql Window permits you to
execute DDL and DML commands
to the InterBase server as well as to load, save, print, cut, paste, and copy SQL scripts ...

https://www.firebirdsql.org/file/documentation/html/en/firebirddocs/isql/firebird-isql.html

DatGridView Filter BindingSource.Filter Property