Hi,
Function ValType() of a Field Type "Date" on SqlServer returns "C" , but in
a field type "DATETIME" it returns correct "D",
Since SqlServer 2008 have this type of field, how can we use it in Xailer
App's
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.
FieldType date MSSQL
-
Pedro Sousa e Faro
- Mensajes: 91
- Registrado: Mié May 30, 2007 5:25 pm
FieldType date MSSQL
Pedro,
> Function ValType() of a Field Type "Date" on SqlServer returns "C" , but
> in a field type "DATETIME" it returns correct "D",
>
> Since SqlServer 2008 have this type of field, how can we use it in Xailer
> App's
We'll review it ASAP.
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info
> Function ValType() of a Field Type "Date" on SqlServer returns "C" , but
> in a field type "DATETIME" it returns correct "D",
>
> Since SqlServer 2008 have this type of field, how can we use it in Xailer
> App's
We'll review it ASAP.
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info
FieldType date MSSQL
Pedro,
> Function ValType() of a Field Type "Date" on SqlServer returns "C" , but
> in a field type "DATETIME" it returns correct "D",
>
> Since SqlServer 2008 have this type of field, how can we use it in Xailer
> App's
We'll review it ASAP.
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info
> Function ValType() of a Field Type "Date" on SqlServer returns "C" , but
> in a field type "DATETIME" it returns correct "D",
>
> Since SqlServer 2008 have this type of field, how can we use it in Xailer
> App's
We'll review it ASAP.
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info
-
ignacio
- Site Admin
- Mensajes: 9440
- Registrado: Lun Abr 06, 2015 8:00 pm
- Ubicación: Madrid, Spain
- Contactar:
FieldType date MSSQL
Pedro,
You can use any field type you want as long you treat it correctly. If ADO
returns for the Field 'date' as a string you should treat it that way.
Regards,
Note: We do not perform any casting on data field values. The complete job
is made by Microsoft ADO
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
"Pedro Faro" <psfaro@shi.pt> escribió en el mensaje de
noticias:4bfd3e52$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Hi,
>
> Function ValType() of a Field Type "Date" on SqlServer returns "C" , but
> in a field type "DATETIME" it returns correct "D",
>
> Since SqlServer 2008 have this type of field, how can we use it in Xailer
> App's
>
> Regards
>
> Pedro faro
>
>
You can use any field type you want as long you treat it correctly. If ADO
returns for the Field 'date' as a string you should treat it that way.
Regards,
Note: We do not perform any casting on data field values. The complete job
is made by Microsoft ADO
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
"Pedro Faro" <psfaro@shi.pt> escribió en el mensaje de
noticias:4bfd3e52$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Hi,
>
> Function ValType() of a Field Type "Date" on SqlServer returns "C" , but
> in a field type "DATETIME" it returns correct "D",
>
> Since SqlServer 2008 have this type of field, how can we use it in Xailer
> App's
>
> Regards
>
> Pedro faro
>
>
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
-
ignacio
- Site Admin
- Mensajes: 9440
- Registrado: Lun Abr 06, 2015 8:00 pm
- Ubicación: Madrid, Spain
- Contactar:
FieldType date MSSQL
Pedro,
You can use any field type you want as long you treat it correctly. If ADO
returns for the Field 'date' as a string you should treat it that way.
Regards,
Note: We do not perform any casting on data field values. The complete job
is made by Microsoft ADO
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
"Pedro Faro" <psfaro@shi.pt> escribió en el mensaje de
noticias:4bfd3e52$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Hi,
>
> Function ValType() of a Field Type "Date" on SqlServer returns "C" , but
> in a field type "DATETIME" it returns correct "D",
>
> Since SqlServer 2008 have this type of field, how can we use it in Xailer
> App's
>
> Regards
>
> Pedro faro
>
>
You can use any field type you want as long you treat it correctly. If ADO
returns for the Field 'date' as a string you should treat it that way.
Regards,
Note: We do not perform any casting on data field values. The complete job
is made by Microsoft ADO
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
"Pedro Faro" <psfaro@shi.pt> escribió en el mensaje de
noticias:4bfd3e52$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Hi,
>
> Function ValType() of a Field Type "Date" on SqlServer returns "C" , but
> in a field type "DATETIME" it returns correct "D",
>
> Since SqlServer 2008 have this type of field, how can we use it in Xailer
> App's
>
> Regards
>
> Pedro faro
>
>
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com