Página 1 de 1

FieldType date MSSQL

Publicado: Mié May 26, 2010 5:17 pm
por Pedro Sousa e Faro
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

FieldType date MSSQL

Publicado: Jue May 27, 2010 9:51 am
por jfgimenez
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

FieldType date MSSQL

Publicado: Jue May 27, 2010 9:51 am
por jfgimenez
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

FieldType date MSSQL

Publicado: Jue May 27, 2010 9:58 am
por ignacio
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
>
>

FieldType date MSSQL

Publicado: Jue May 27, 2010 9:58 am
por ignacio
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
>
>