Type of Change: Enhancement
Product: Acu4GL
Module: MSSQL
New Version: 10.0
Machines Affected: Windows
Known Versions Affected: All
Description of enhancement
SQL Server 2012 introduced a new data type called TIME, which can efficiently store time data. Acu4GL for SQL Server now supports this data type.
Instructions for use
In order to use this data type, you must use the correct SQL Server ODBC driver. The only version known to support the TIME data type (at the time of writing) is the SQL Server Native Client 11.0 (the driver for SQL Server 2012). This driver is installed with SQL Server 2012 or later, or you can downloaded it from the Microsoft web site, free of charge.
To specify that a column should be a TIME column, use the DATE XFD directive, only specifying the time format characters (H, N, S, T).
See A_MSSQL_ODBC_DRIVER_NAME Configuration Variable for instructions for using different ODBC drivers.