Page 1 of 1
Cannot convert type Int to Tinyint Unidac 6.1.3
Posted: Tue 21 Apr 2015 21:33
by agenovesi
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
Re: Cannot convert type Int to Tinyint Unidac 6.1.3
Posted: Wed 22 Apr 2015 15:02
by sandy771
Have you tried Data Type Mapping?
Re: Cannot convert type Int to Tinyint Unidac 6.1.3
Posted: Thu 23 Apr 2015 08:15
by azyk
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;