0

NAV field names from field nos

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:

=@NL("First","information_schema.columns","column_name")

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'

Thanks!

3 comments

Please sign in to leave a comment.