I want to assign a date value from an EDBTable to a DateTimePicker:

if not VarIsNull(MyTableMyDate.value) then
 DateTimePicker.date := MyTableMyDate.value;

Surprisingly this results in an exception.

Investigating further I found that MyTableMyDate.value = 0! Checking this in EDBManager
shows, that the value is actually NULL.

Any idea what is wrong here?

Regards Uli

Uli

>Investigating further I found that MyTableMyDate.value = 0! Checking this in EDBManager
>shows, that the value is actually NULL.
>
>Any idea what is wrong here?

The quick answer is nothing. Everything is working as it should - apart from your expectations

There is a difference between sql and delphi with null's. eg a VARCHAR in sql may return null (currently at least) but if your access it through .AsString it returns an emptystring, for integers .AsInteger returns 0.

What you need to do is rather than using VarIsNull(MyTableMyDate.value) as your check use MyTableMyDate.IsNull

Roy Lambert

Roy,

> What you need to do is rather than using VarIsNull(MyTableMyDate.value) as your check use MyTableMyDate.IsNull

Thanky, Roy. That helped.

Regards Uli