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

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for PostgreSQL in Delphi and C++Builder
Post Reply
Eden0928
Posts: 47
Joined: Sun 22 Apr 2012 14:08

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

Post by 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?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

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

Post by 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.

Post Reply