Filtering two IBTable and insert or edit IBTable

[DeddyH]

I personally prefer using queries rather than tables. Using a statement like:

SQL-Code:

SELECT 
  *   
FROM
  ATTENDANT 
WHERE
  "WHEN" BETWEEN :start AND :end

and filling the parameters as follows:

Delphi-Quellcode:

Query.ParamByName('start').Value := EncodeDate(2014, 2 ,17);
Query.ParamByName('end').Value := EncodeDate(2014, 2, 20);
Query.Open;

should return the expected result.