Xailer & OZ Software

Hi
If we declare picture in colums type date in ArrayBrowse like
'9999-99-99',
if the database have value NULL , the app returns a "transform ... " error
and exit.
In sql tables , the fields type DATETIME assums null , where they havent't
any value.
How can we turn around the problem. ?
Best regards
Pedro Faro

Pedro,
> If we declare picture in colums type date in ArrayBrowse like
> '9999-99-99',
> if the database have value NULL , the app returns a "transform ... " error
> and exit.
>
> In sql tables , the fields type DATETIME assums null , where they havent't
> any value.
Either TMySQLDatasource and TSQLiteDatasource return CTOD("") when a date or
datetime field contains NULL. ITOH, ADO doesn't do so, and returns NULL. In
this case, I'm affraid you have to treat those values, f.e., by using the
OnGetData or OnGetValue events of the browse's columns.
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info

Hi Jose
Tanks very much . Works fine.
"Jose F. Gimenez" <jfgimenez@wanadoo.es> escreveu na mensagem
news:49eda2f3$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Pedro,
>
>> If we declare picture in colums type date in ArrayBrowse like
>> '9999-99-99',
>> if the database have value NULL , the app returns a "transform ... "
>> error and exit.
>>
>> In sql tables , the fields type DATETIME assums null , where they
>> havent't any value.
>
> Either TMySQLDatasource and TSQLiteDatasource return CTOD("") when a date
> or datetime field contains NULL. ITOH, ADO doesn't do so, and returns
> NULL. In this case, I'm affraid you have to treat those values, f.e., by
> using the OnGetData or OnGetValue events of the browse's columns.
>
> --
> Regards,
>
> Jose F. Gimenez
> http://www.xailer.com
> http://www.xailer.info
>