[WD16] HCreation can't create Date only or Time only type fields in MS SQLServer Hello All The Windev analysis supports DATE only and Time only type fields in the files and so does MS SQL server for version 2008 . The problem is that HCreation() will NOT create a DATE or a TIME type field in MS SQL Server, it creates a DateTime field instead. Also the script generator in the analysis writes DateTime not Date or Time into the script it creates. The only solution at the moment is the set the Date only and Time Only fields to text or manage the table creation and alteration with HExecuteSQLQuery(). Regards Al https://www.wxforum.info/read.php?27593,106471,106471#msg-106471 Tue, 19 May 2026 03:29:08 +0200 Phorum 5.2.23 https://www.wxforum.info/read.php?27593,106471,106471#msg-106471 [WD16] HCreation can't create Date only or Time only type fields in MS SQLServer https://www.wxforum.info/read.php?27593,106471,106471#msg-106471
The Windev analysis supports DATE only and Time only type fields in the files and so does MS SQL server for version 2008
.
The problem is that HCreation() will NOT create a DATE or a TIME type field in MS SQL Server, it creates a DateTime field instead.

Also the script generator in the analysis writes DateTime not Date or Time into the script it creates.

The only solution at the moment is the set the Date only and Time Only fields to text or manage the table creation and alteration with HExecuteSQLQuery().

Regards
Al]]> Al WX-Products: Reports of malfunctions & bugs Mon, 11 Jul 2011 15:43:59 +0200