Cannot convert type Int to Tinyint Unidac 6.1.3

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
agenovesi
Posts: 2
Joined: Wed 30 Apr 2014 14:07

Cannot convert type Int to Tinyint Unidac 6.1.3

Post by agenovesi » Tue 21 Apr 2015 21:33

Hi, Have a lot of stored procedures with tinyint parameters in sql server, and the type for those parameters is always ftWord. With the latest version a get the error "Cannot convert type Int to Tinyint". If I change the ftWord to ftSmallInt that fix the problem, but as I wrote before, have a plenty of stored procedures like this one. Thanks

sandy771
Posts: 194
Joined: Tue 22 May 2007 13:57

Re: Cannot convert type Int to Tinyint Unidac 6.1.3

Post by sandy771 » Wed 22 Apr 2015 15:02

Have you tried Data Type Mapping?

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Cannot convert type Int to Tinyint Unidac 6.1.3

Post by azyk » Thu 23 Apr 2015 08:15

Support for parameters with tinyint data type was added to UniDAC. You should specify the Delphi ftByte data type for such parameters. For example:

Code: Select all

UniStoredProc.ParamByName(ParamName).DataType := ftByte;

Post Reply