char field corrupted

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Ludek
Posts: 296
Joined: Thu 12 Oct 2006 09:34

char field corrupted

Post by Ludek » Thu 12 Feb 2009 10:13

following scenario:
delphi 2009, newest sdac.
fastmm4 with fulldebugmode activated.
one empty table with one char(60) field.
one simple form with tdbedit, tmsquery, tdatasource, tmsconnection and tdbnavigator

user writes an "a" to the edit field and presses "post" in the navigator.
sdac stores following to the char(60) field (converted to hex):

0x610032F67536808080808080202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020

those characters after "00" are making BIG trouble in non-sdac applications like ado.net.
please, could you make the char field clear?

note: without fulldebug, i get following in the char field

0x610020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020

it seems, you are storing data from memory areas, that don't belong to you.

thanks for your help, Ludek.

Ludek
Posts: 296
Joined: Thu 12 Oct 2006 09:34

Post by Ludek » Thu 12 Feb 2009 10:27

next info:
using d2006 and sdac 4.35.1.16 everything is ok, with or without fastmm4 fulldebugmode i always get following:

0x612020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020

which is perfect - even the rather unhappy 00 character isn't there.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 17 Feb 2009 07:11

I could not reproduce the problem.
Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill table.

Ludek
Posts: 296
Joined: Thu 12 Oct 2006 09:34

char

Post by Ludek » Tue 17 Feb 2009 07:41

did you really try using following

select cast(col as binary(60)) from testtable

? i'll test you the project soon...

Ludek
Posts: 296
Joined: Thu 12 Oct 2006 09:34

Post by Ludek » Tue 17 Feb 2009 10:17

example sent. it's really nothing more than i've already written.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 17 Feb 2009 12:47

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next SDAC build.

Ludek
Posts: 296
Joined: Thu 12 Oct 2006 09:34

Post by Ludek » Wed 18 Feb 2009 17:19

When will the next sdac build be available?

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 19 Feb 2009 12:12

The next SDAC build will be released in the course of the next week.

Ludek
Posts: 296
Joined: Thu 12 Oct 2006 09:34

Post by Ludek » Fri 27 Feb 2009 09:56

Are you sure? there are only a few hours remaining from this week... :cry:

Ludek
Posts: 296
Joined: Thu 12 Oct 2006 09:34

Post by Ludek » Fri 27 Feb 2009 13:39

Wow, now! thanks :)

Post Reply