How do I access the information_schema.columns table in JET so I can determine the Field Name from a Field No?
Here is the simplest form of the query but it returns a #VALUE! error:
I've tried both my NAV datasource and a generic data source that allows access to the NAV system tables and both say that "information_schema.columns" is an invalid table.
I can successfully query the table in SQL just cannot find a way to access it through JET. Working SQL query:
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'NAV$Purchase Header' and ORDINAL_POSITION = '3'