Problem with the tinyint fields
Problem with the tinyint fields
Hi, I have a problem with the new version of the dbexpress driver and tinyint fields. A tinyint field in the previous versions was ftSmallInt datatype, but now it's ftByte and for example, instead of 1 I get 1025.
Re: Problem with the tinyint fields
Thank you for the information. We have reproduced the problem and will investigate it.
Re: Problem with the tinyint fields
Can you give me any solution? My application does not work properly!
Re: Problem with the tinyint fields
We have fixed this problem. This fix will be included in the next dbExpress driver for SQL Server build.
We have sent you a night build including the fix to your e-mail. Please install it and let us know if the problem still remains.
We have sent you a night build including the fix to your e-mail. Please install it and let us know if the problem still remains.
Re: Problem with the tinyint fields
In the version of DBExpress driver you sent me, problem still exists when I get records from stored procedures.
Re: Problem with the tinyint fields
We can't reproduce the described issue for tinyint using a stored procedure. Please try to compose a small sample reproducing the issue and send it to andreyz*devart*com . Include the scripts for creating the table and stored procedure.
Re: Problem with the tinyint fields
I have just upgraded to the latest release and am also getting this error when calling stored procedures with tinyint parameters: "error converting data type smallint to tinyint".
I have literally 100's of procedures in several applications, so i need a fix for this urgently. For now, I have had to revert back to the old version that I was previously using, but this version does not fully support windows authentication in SQL2014, which is needed by some customers.
Please advise
I have literally 100's of procedures in several applications, so i need a fix for this urgently. For now, I have had to revert back to the old version that I was previously using, but this version does not fully support windows authentication in SQL2014, which is needed by some customers.
Please advise
Re: Problem with the tinyint fields
As we wrote earlier, we can't reproduce the described issue for tinyint using a stored procedure. Therefore, to investigate this behavior of dbExpress driver for SQL Server, please try to compose a small sample reproducing the issue and send it to viktorv*devart*com include the scripts for creating the table and stored procedure.
Re: Problem with the tinyint fields
After further investigation, I discovered that the reason for the error message when attempting to pass tinyint fields to a stored procedure was in fact correct! The program was indeed trying to pass a value of 1795 as a tinyint, which obviously is invalid.
HOWEVER, the reason for this is because the data being returned via the Devart component is incorrect! A tinyint value of 3 is being returned via the database components as 1795. This behaviour is probably because of the way that the programs are written, which is quite complex but has worked on the old version of the component for many years.
As requested, I have built a sample program which reproduces the problem and have emailed it to the address you provided.
HOWEVER, the reason for this is because the data being returned via the Devart component is incorrect! A tinyint value of 3 is being returned via the database components as 1795. This behaviour is probably because of the way that the programs are written, which is quite complex but has worked on the old version of the component for many years.
As requested, I have built a sample program which reproduces the problem and have emailed it to the address you provided.
Re: Problem with the tinyint fields
Thank you for the information. We have reproduced the issue and investigation is in progress. We will inform you when we have any results.