dbExpress driver for MS SQL Server2.57 in delphi2006 bug

[masks]

select isnull(datanamenum,1) as datanamenum from mrecno
Data table is empty why datanamenum =5231964 .
This worth should be equal to 1


Delphi7 have no problem

[Ikar]

Send us please complete small sample. We will check it before releasing DbxSda for Delphi 2006.

[masks]

To Ikar
you Email_add?

[Ikar]

dbxsda*cralb*com

[masks1]

I already ba this bug de demo Email to you.

[Ikar]

We reproduced the problem. It is dbExpress bug. We have adjusted our code to
avoid it. Please note: if table is empty (RecordCount = 0) getting Field.AsString has no sense.

[masks]

to:Ikar
I am register consumer for std , I already under plant but that BUG still exist .Please help me

[Ikar]

For what reasons you try to get data from empty (RecordCount = 0) dataset?

[masks]

I come in China, use de is B/ S framework. DbExpress take charge of sql execute and return Thereinto have many requirements are empty value or zero value. select isnull (datanamenum, one) as datanamenum from mrecno this is very simple example

I use delphi7 translate and edit have no discover corllab Groupware have problem.
but I be used for delphi2006 then discover this' key problem,

I use delphi2006
ConnectionName = ' MSSQLConnection'
DriverName = ' MSSQL'
GetDriverFunc = ' getSQLDriverMSSQL'
LibraryName = ' dbxmss30. dll' have no bring forth problem.


I hope Core Lab Team Can help I settle this' problem.

[Ikar]

We will add this behavior for compatibility reasons. The functionality will be included in the next build. Please note however that it is highly recommended to avoid such practice. There is little sense in reading nonexisting rows. The code you use may not work in other versions of Delphi, for example, in Delphi 2005. We recommend to check quantity of rows in returned dataset.

[masks]

Thank you ^_^