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?