FireDAC Components for TSheets

Build 20.0.7654

Prepared Statements

Executing Prepared Statements with FireDAC Classes

By default, TFDQuery prepares the query to avoid recompiling the same query over and over.

FDQuery1.SQL.Text := 'SELECT * FROM Timesheets WHERE JobCodeType=:JobCodeType' 
FDQuery1.ParamByName('JobCodeType').AsString := 'regular';
FDQuery1.Open;

Notes

  • If you need to execute a command only once, set ResourceOptions.DirectExecute to true.
  • The connection must be active and open while a statement is prepared.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654