[Gambas-user] Strange iif behaviour

[Liutauras Adomaitis]

hello,

I wanted to shorten my code so decided to use iif( expression, value on true, 
value on false). My expression was iif( isnull(value from DB table),Null, 
cdate(value from DB table)). Idea is to display nothing (null) if date is not 
specified in DB tables record. The error of this sentece was, that gambas 
expevted date, but got null instead.
Changing sentece to iif( isnull(value from DB table),"True", "False") - works 
ok. 
It seems that gambas is evaluating all the values (on true an false), and 
checking all the values and comparing data types. It is very strange, at 
least comparing with VB
-- 
--------------------------------
Liutauras Adomaitis

Infosaitas
+370 650 82554
www.infosaitas.lt