mibuso.com
Home› NAV/Navision Classic Client
Options

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

txerifftxeriff Member Posts: 492
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

  • Options
    krikikriki Member, Moderator Posts: 9,096
    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!

  • Options
    txerifftxeriff Member Posts: 492
    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?
  • Options
    DenSterDenSter Member Posts: 8,304
    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
    MVP - Business Apps
  • Options
    archer89archer89 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/
  • Options
    txerifftxeriff Member Posts: 492
    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.
Sign In or Register to comment.