Dynamics User Group
Since 1995 - The Microsoft Dynamics Online User Community

Query Change Log Entry SQL Server Table - Field No

rated by 0 users
This post has 1 Reply | 1 Follower

Not Ranked
Male
Posts 3
Points 60
Derald Posted: 08-18-2008 20:11

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
Top 50 Contributor
Male
Posts 400
Points 6,365
DynamicsNAVMVP
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) | RSS


Copyright Dynamics User Group, 1995-2008, all rights reserved. The Dynamics User Group is not affiliated with Microsoft Corporation.