Where is Database | Test function?

navis01navis01 Posts: 2Member
Why there is no more Database | Test function in newer versions (2017, 2018) like in old Classic Client? Is there another way to test data consistency? I tried to find something and the closest thing is codeunit 134926 Table Relation Test, but it checks technical aspects of relations (like data types of related fields), not the actual data consistency.

Answers

  • Slawek_GuzekSlawek_Guzek Posts: 1,683Member
    The "Database -> Test function was only available for native NAV database. For SQL databases you need to use SQL tools, (DBCC CHECKDB etc)
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • navis01navis01 Posts: 2Member
    Actually, it did exist on SQL Server Option in Classic Client, I’m just running it in NAV2009 finsql.exe. Thanks for DBCC/CHECKDB info. I will check it out, but I doubt it will be able to check field relationships between tables which is my primary concern. Especially conditional ones like “Sales Line”.”No.”:

    IF (Type=CONST(" ")) "Standard Text" ELSE IF (Type=CONST(G/L Account),System-Created Entry=CONST(No)) "G/L Account" WHERE (Direct Posting=CONST(Yes),Account Type=CONST(Posting),Blocked=CONST(No)) ELSE IF (Type=CONST(G/L Account),System-Created Entry=CONST(Yes)) "G/L Account" ELSE IF (Type=CONST(Item)) Item ELSE IF (Type=CONST(Resource)) Resource ELSE IF (Type=CONST(Fixed Asset)) "Fixed Asset" ELSE IF (Type=CONST("Charge (Item)")) "Item Charge"

    I guess it could be done from C/AL using RecordRef/FieldRef and Table Relations Metadata. But it would also be great to put it back in Development Environment.
Sign In or Register to comment.