1C:Enterprise does not natively support accessing to Firebird database with External data source function, thus using “Other” category for this task.
But there is one problem – when using dynamic lists, 1C:Enterprise uses constructions like:

SELECT TOP 10 … FROM …

Firebird has another syntax:

SELECT FIRST 10 … FROM …

And as a result such queries does not work.

Attached ODBC driver is patched to replace “SELECT TOP” to “SELECT FIRST” to make 1C:Enterprise work correctly.
There are some other issues left through.

Download from here

Leave a Reply