Is there a more secure way to pass parameters to a query?
TFDQuery(Qry).SQL.Add('select * from table where id= :id');
// option 1
TFDQuery(Qry).Parambyname('id').AsFloat := valueFloat;
Hi, I'm trying to insert some data into a mysql table using an fdquery object in Delphi 10, which works fine except it does not insert all the exclamation marks (!) present into the varchar fields
"Hello!/Goodbye!" will be inserted as "Hello/G...
FireDAC SQL - I can't get the CASE syntax to work - and don't know a good source of help information that is specific to the FireDAC version of SQL. I have an TFDQuery on a table called Gases that has a gas name (field Gas) and a required concentrati...