Behaviour difference between TDaMem and TDaCDS

Data Abstract
#1

another difference popped up in our move from TDaCDS to TDaMem:

if you filter on a boolean field wich is NULL in the database then CDS treats this as False as where MEM does not
so with CDS you get all records NULL
with MEM you get no NULL recs…

is this by design or not?
if so, i’de really whish there was a document outlining these major differences between the 2 datasets…

is CDS still maintained or is CDS deprecated in the DA landscape?

#2

Hi,

What filter you have used?
afair, you can check for NULL with

fld IS NULL

CDS is deprecated since June 2014 release

#3

dataset.Filter:=‘boolfield=false’
if boolfield ISNULL then it gets filtered out
CDS treated NULL as false…

#4

we don’t treat Null value as False.

Use

fld is NULL

or

fld IS NOT NULL
#5

that i know now…
just saying that it is really hard to migrate to MEM with all these undocumented differences
and the more hard to discover them before releasing soft…

#6

MemDataTable has advanced filter syntax comparing with basic one in CDS.
this is difference …