Get a "Unknown data type" when params is ftVariant in SQL Execute;

[Eden0928]

My code below:

Code: Select all

  SQLQuery1.SQL.Text := 'DELETE FROM "TableA" WHERE id = :myId ';
  SQLQuery1.Params[0].DataType := ftVariant;
  SQLQuery1.Params[0].Value := '';
  SQLQuery1.ExecSQL();

Run it. I get the "Unknown data type" error message.

Why?

[AlexP]

Hello,

Thank you for the information. We have reproduced and fixed the problem. This fix will be included to the next version.