Page 1 of 1

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

Posted: Mon 23 Dec 2013 09:40
by 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?

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

Posted: Mon 23 Dec 2013 14:20
by AlexP
Hello,

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