Some ODBC drivers require spaces when sending dates or timestamps to the data source. For data sources that require spaces between the d and the quote ('), set the configuration variable A_ODBC_USE_SPACE_IN_DATES.
For example:
Set MYDATE={d '1999-3-20'}
(note that there is a space between d and ')
Setting the A_ODBC_USE_SPACE_IN_DATES configuration variable to 1 causes the
Acu4GL for ODBC product to use syntax as above, instead of:
Set MYDATE={d'1999-3-20'}
(note that there is not a space between d and ')
Keep in mind that it is possible that all data sources may allow a space
between the and the ', and that it is always safe to set this variable.
While the default value is "0", this configuration variable can also take values of "Yes," "No," "True," "False,"
"On," or "Off."
A_ODBC_USE_SPACE_IN_DATES 1