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
In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Picture in date fields in arrayBrowse
-
Pedro Faro
- Mensajes: 11
- Registrado: Sab Dic 01, 2007 11:13 pm
Picture in date fields in arrayBrowse
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
> 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
-
Pedro Faro
- Mensajes: 11
- Registrado: Sab Dic 01, 2007 11:13 pm
Picture in date fields in arrayBrowse
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
>
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
>