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

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

Postby Eden0928 » Mon 23 Dec 2013 09:40

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?
Eden0928
 
Posts: 44
Joined: Sun 22 Apr 2012 14:08

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

Postby AlexP » Mon 23 Dec 2013 14:20

Hello,

Thank you for the information. We have reproduced and fixed the problem. This fix will be included to the next version.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for PostgreSQL