Version 9 Grid causes a bug in my odbc connection ...

Scriptcase 9 General
#1

[TABLE=“border: 0, cellpadding: 0, cellspacing: 0”]
[TR]
[TD]when I use group by date in Grid:[/TD]
[/TR]
[TR]
[TD]Now v9 writes automatically the following[/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD]…[/TD]
[/TR]
[TR]
[TD]…[/TD]
[/TR]
[TR]
[TD]ORDER BY[/TD]
[/TR]
[TR]
[TD][SIZE=18px]YEAR[/SIZE] (RCDA_FEC_PAGO) asc, [SIZE=18px]MONTH[/SIZE] (RCDA_FEC_PAGO) asc[/TD]
[/TR]
[TR]
[TD]--------------------------------------[/TD]
[/TR]
[TR]
[TD]And this causes an error in my ODBC connection[/TD]
[/TR]
[TR]
[TD][TOD] [ODBC] [GENESIS] File error: TFIREAD ‘’[/TD]
[/TR]
[TR]
[TD]-------------------------------------------------- ----------[/TD]
[/TR]
[TR]
[TD]The same application and connection in v8 worked perfectly.[/TD]
[/TR]
[/TABLE]

#2

What is the database driver?

#3

Driver Acucorp Acuxdbc version 8.01.02.00 (now Microfocus Inc.) for Vision Cobol files, this driver has some differences from the standard sql.
For example, he does not know how to interpret:
ORDER BY
YEAR (RCDA_FEC_PAGO) asc

But yes:
ORDER BY
(RCDA_FEC_FAGO) asc

value (YYYY-MM-DD) as date sql.

As it did in version 8 sc.

Thank you.