Get a "Unknown data type" when params is ftVariant in SQL Execute;
Posted: Mon 23 Dec 2013 09:40
My code below:
Run it. I get the "Unknown data type" error message.
Why?
Code: Select all
SQLQuery1.SQL.Text := 'DELETE FROM "TableA" WHERE id = :myId ';
SQLQuery1.Params[0].DataType := ftVariant;
SQLQuery1.Params[0].Value := '';
SQLQuery1.ExecSQL();
Why?