Welcome! Log In Create A New Profile

Advanced

[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().

Regards
Al



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

Your Email:


Subject:


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.
Message: