Nav "Fields" table: Does it exists on SQL Server?

txeriff
txeriff Member Posts: 515
edited 2012-04-26 in NAV/Navision Classic Client
Hi,

I was looking for the table called "Field" in sql server but cannot find it. Is it an internal table?

It shows all fields from any table. You ca browse it by making a new form and typing "Field", then retrieve all the fields.

Any idea?

thanks! :)

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    It doesn't exist in SQL. It is a virtual table in NAV.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • txeriff
    txeriff Member Posts: 515
    kriki wrote:
    It doesn't exist in SQL. It is a virtual table in NAV.

    thanks for the response.

    And how does nav make it? Does it use any view or something I could use from sql server?
  • DenSter
    DenSter Member Posts: 8,307
    Virtual tables are pieces of data that the NAV executable collects at runtime, and represents as a table structure, so that we can access it in C/AL code as if it were a table. As Alain said earlier, virtual tables do not exist on SQL Server.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • archer89
    archer89 Member Posts: 337
    the get the field names in sql you can use the sql system tables.

    select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS
    where TABLE_CATALOG = <databasename>
    and TABLE_NAME = <tablename>
    -- and ORDINAL_POSITION = <field no.>
    best regards
    Franz Kalchmair, MVP
    Alias: Jonathan Archer

    please like / agree / verify my answer, if it was helpful for you. thx.
    Blog: http://moxie4nav.wordpress.com/
  • txeriff
    txeriff Member Posts: 515
    DenSter wrote: »
    Virtual tables are pieces of data that the NAV executable collects at runtime, and represents as a table structure, so that we can access it in C/AL code as if it were a table. As Alain said earlier, virtual tables do not exist on SQL Server.

    thanks. I though they exist somewhere.

Categories