FireDAC Components for eBay Analytics

Build 21.0.7929

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 TrafficReportByListing WHERE ListingId=:ListingId' 
FDQuery1.ParamByName('ListingId').AsString := '201284405428';
FDQuery1.Open;

Notes

  • If you need to execute a command only once, set ResourceOptions.DirectExecute to true.
  • The TFDConnection class is most useful for one-off data manipulation commands, where prepared statements are unnecessary.
  • The connection must be active and open while a statement is prepared.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7929