in

Dynamics User Group

Since 1995 - The Microsoft Dynamics Online User Community
Dynamics User Group » Microsoft Dynamics NAV / Navision » NAV / Navision - Microsoft SQL Server » Query Change Log Entry SQL Server Table - Field No

Query Change Log Entry SQL Server Table - Field No

Last post 08-18-2008 22:20 by Rashed. 1 replies.
Page 1 of 1 (2 items)
Write a New Post Sort Posts: Previous Next

  • 08-18-2008 20:11

    • Derald
    • Not Ranked
      Male
    • Joined on 07-02-2008
    • Maryland
    • Posts 3
    • Points 60

    Query Change Log Entry SQL Server Table - Field No

    Reply Contact

    I want to query from SQL server the Change Log Entry table. Is there a way 
     
    to display the 'Field Name' for each of the 'Field No_'? The 'Field No_' is a 
     
    field that is part of the SQL table, however 'Field Name' is not. I cannot 
     
    find any SQL table that cross-references the Filed No to the Field Name. Any 
     
    ideas...? 
     
    Thanks! 

    • Post Points: 20

  • 08-18-2008 22:20 In reply to

    • Rashed
    • Top 50 Contributor
      Male
    • Joined on 08-05-2003
    • Washington DC
    • Posts 400
    • Points 6,790
    • DynamicsNAVMVP

    Re: Query Change Log Entry SQL Server Table - Field No

    Reply Contact
    Create a table in 50K range and from Navision run a report to populate it. The processing report will copy all the value from virtual table FIELD to this new table. You can run the report anytime you change any table structures.
    • Post Points: 5
Page 1 of 1 (2 items)

Copyright Dynamics User Group, 1995-2008, all rights reserved. This website and user group are independent and not affiliated with the Microsoft Corporation.