Problem with TinyInt field, SDAC 6.11.22

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
paweld
Posts: 11
Joined: Mon 29 Sep 2014 08:56

Problem with TinyInt field, SDAC 6.11.22

Post by paweld » Mon 29 Sep 2014 09:09

Hi,
under Lazarus, query not return correct values for field type TINYINT. When I convert field in query, or edit MapRules it's ok, but is not comfortable solution.

Lazarus 32-bit 1.2.4 + FPC 2.6.4, MSSQL 2008 R2, Windows 7 pro x64

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

Re: Problem with TinyInt field, SDAC 6.11.22

Post by azyk » Tue 30 Sep 2014 07:10

We couldn't reproduce the problem. Please try to compose a small sample to demonstrate the problem and send it to andreyz*devart*com.

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

Re: Problem with TinyInt field, SDAC 6.11.22

Post by azyk » Mon 06 Oct 2014 11:26

We have received your sample by email, run it, but the described problem for the TINYINT type wasn't reproduced.

To solve the problem, try to fully remove and reinstall SDAC.

For this, close all the open projects and files in Lazarus. Go to the main menu Package->Install/Uninstall Packages, select the following packages in the Installed list: dacvcl10 9.4.11, dcldac10 9.4.11, dclsdac10 6.11.23, sdacvcl10 6.11.23. Click "Uninstall selection", then - "Save and exit dialog", "Continue".

In the main menu Package->Package Links ... , in the grid of the opened dialog check the following items: dac10, dacvcl10, dcldac10, dclsdac10, sdac10, sdacvcl10. Click "Delete selected", "Close".

In the main menu select Package->Configure "Build Lazarus", in the "Clean Up" group of the opened dialog check the "Clean All" radio button. In the Defines group check "Debug" and click "Build".

After Lazarus is rebuilt, install SDAC, following the instructions in the ReadmeSrc.html file.

Now, please check whether the problem from the first post is reproduced and let us know the results.

paweld
Posts: 11
Joined: Mon 29 Sep 2014 08:56

Re: Problem with TinyInt field, SDAC 6.11.22

Post by paweld » Mon 06 Oct 2014 15:48

Thanks you for the answer, but problem isn't solved.

Best regards

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

Re: Problem with TinyInt field, SDAC 6.11.22

Post by azyk » Wed 08 Oct 2014 09:39

As a result of execution of your sample we got a grid with 4 columns (TinyInt, SmallInt, Int, Numeric) filled with the following values (5 records):

Code: Select all

1 1 1 1
2 2 2 2
3 3 3 3
4 4 4 4
5 5 5 5
Please clarify what results you expect and what you get.

paweld
Posts: 11
Joined: Mon 29 Sep 2014 08:56

Re: Problem with TinyInt field, SDAC 6.11.22

Post by paweld » Wed 08 Oct 2014 12:10

I expect results what You show, but i get in tinyint column random values. tested on few servers with different MSSQL versions (2005, 2008r2, 2012)

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

Re: Problem with TinyInt field, SDAC 6.11.22

Post by azyk » Thu 09 Oct 2014 09:21

Could you install Lazarus, then SDAC, to a clean OS (work station or virtual machine) and try to reproduce the problem? Please let us know the results.

paweld
Posts: 11
Joined: Mon 29 Sep 2014 08:56

Re: Problem with TinyInt field, SDAC 6.11.22

Post by paweld » Thu 09 Oct 2014 12:25

I tried on the new installation "windows xp mode" and problem still exists. After compile, i copy application to:
* laptop (win7 x64 + mssql 2008r2 express): in tinyint column get values: -255, -254, -253, -252, -251
* 1st server (win srv 2008 r2 x64 + mssql 2012 express): values: -31487, -31486 etc.
* 2nd server (win srv 2012r2 x64 + mssql 2014 standard): values: -3071, -3070 etc.

Can You send me compiled application, I test it on my computer ?

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

Re: Problem with TinyInt field, SDAC 6.11.22

Post by azyk » Tue 14 Oct 2014 08:09

We have compiled your sample and sent it back to your email. The sample was compiled on Windows 7 x64, Lazarus 32-bit 1.2.4 + FPC 2.6.4, SDAC 6.11.22 .

paweld
Posts: 11
Joined: Mon 29 Sep 2014 08:56

Re: Problem with TinyInt field, SDAC 6.11.22

Post by paweld » Tue 14 Oct 2014 08:51

The application works correctly. I thank for Your help, very much.
I'll be looking for the cause of an error in my Lazarus installation.

Best regards

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

Re: Problem with TinyInt field, SDAC 6.11.22

Post by azyk » Thu 16 Oct 2014 07:24

Feel free to contact us if you have any further questions.

Post Reply