Hi ,
Since our Xailer App's only work with MSSQL Server , the problem is that
MSSQL in Columns type "dateTime" only acepts dates > = 1753.
To validate the input we must insert a validation on "exit method" of any
date. "
Is ther any better way to validate this situation
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.
Field Date Edit (for SQL Databases)
-
Pedro Sousa e Faro
- Mensajes: 91
- Registrado: Mié May 30, 2007 5:25 pm
-
ignacio
- Site Admin
- Mensajes: 9441
- Registrado: Lun Abr 06, 2015 8:00 pm
- Ubicación: Madrid, Spain
- Contactar:
Field Date Edit (for SQL Databases)
Pedro Sousa e Faro escribió el jue, 10 mayo 2012 10:24Hi ,
Since our Xailer App's only work with MSSQL Server , the problem is that
MSSQL in Columns type "dateTime" only acepts dates > = 1753.
To validate the input we must insert a validation on "exit method" of any
date. "
Is ther any better way to validate this situation
Regards
Pedro Faro
You can try to overload TADoRecords:FieldPut() method. Something like this:
CLASS TAdoRecords FROM XAdoRecords
METHOD FieldPut( n, v )
END CLASS
METHOD FieldPut( n, v )
IF Valtype( v ) == "D" .AND. Year( v ) < 1753
v := NIL
ENDIF
RETURN Super:FieldPut( n, v )
Be aware that will do the job with any ADO connection.
Regards,
Since our Xailer App's only work with MSSQL Server , the problem is that
MSSQL in Columns type "dateTime" only acepts dates > = 1753.
To validate the input we must insert a validation on "exit method" of any
date. "
Is ther any better way to validate this situation
Regards
Pedro Faro
You can try to overload TADoRecords:FieldPut() method. Something like this:
CLASS TAdoRecords FROM XAdoRecords
METHOD FieldPut( n, v )
END CLASS
METHOD FieldPut( n, v )
IF Valtype( v ) == "D" .AND. Year( v ) < 1753
v := NIL
ENDIF
RETURN Super:FieldPut( n, v )
Be aware that will do the job with any ADO connection.
Regards,
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