Page 1 of 1

Problem with TinyInt field, SDAC 6.11.22

Posted: Mon 29 Sep 2014 09:09
by paweld
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

Re: Problem with TinyInt field, SDAC 6.11.22

Posted: Tue 30 Sep 2014 07:10
by azyk
We couldn't reproduce the problem. Please try to compose a small sample to demonstrate the problem and send it to andreyz*devart*com.

Re: Problem with TinyInt field, SDAC 6.11.22

Posted: Mon 06 Oct 2014 11:26
by azyk
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.

Re: Problem with TinyInt field, SDAC 6.11.22

Posted: Mon 06 Oct 2014 15:48
by paweld
Thanks you for the answer, but problem isn't solved.

Best regards

Re: Problem with TinyInt field, SDAC 6.11.22

Posted: Wed 08 Oct 2014 09:39
by azyk
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.

Re: Problem with TinyInt field, SDAC 6.11.22

Posted: Wed 08 Oct 2014 12:10
by paweld
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)

Re: Problem with TinyInt field, SDAC 6.11.22

Posted: Thu 09 Oct 2014 09:21
by azyk
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.

Re: Problem with TinyInt field, SDAC 6.11.22

Posted: Thu 09 Oct 2014 12:25
by paweld
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 ?

Re: Problem with TinyInt field, SDAC 6.11.22

Posted: Tue 14 Oct 2014 08:09
by azyk
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 .

Re: Problem with TinyInt field, SDAC 6.11.22

Posted: Tue 14 Oct 2014 08:51
by paweld
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

Re: Problem with TinyInt field, SDAC 6.11.22

Posted: Thu 16 Oct 2014 07:24
by azyk
Feel free to contact us if you have any further questions.