Welcome! Log In Create A New Profile


[WD16] HCreation can't create Date only or Time only type fields in MS SQLServer

Posted by Al 
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().


Edited 1 time(s). Last edit at 07/13/2011 06:56AM by Al.

Your Email:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.