mibuso.com
Home› NAV/Navision Classic Client
Options

Table structure diff. between Obj. Designer and SQL Server

adiadi Member Posts: 8
edited 2004-07-17 in NAV/Navision Classic Client
Hi,

I'm puzzled by the way a table behave. I have to pick up someone's work and modify a report. I went to the table section of object designer select the table I needed to work with and press run, the data and fields displayed also mismatches the structure displayed with the design button. Two fields name "date filter" and "period filter" doesn't even appear on the Show Field menu. Any I idea how can that happen?

One of the filter criteria is the period filter. Now I hv not idea what was stored in the table.

So I went into SQL Server to check the table under the same name. However, even more fields are missing from the table.

Anyone can help?

Rgds,
Adrian

Comments

  • Options
    Rob_HansenRob_Hansen Member Posts: 296
    When you check the properties of those "invisible" fields in Design mode for the Table, is the Enabled property set to No?
    Rob Hansen
    http://www.epimatic.com
  • Options
    RobertMoRobertMo Member Posts: 484
    Check the class of fields. "FlowFilters" do not contain any values. Read in Application Designer's Guide about different filed classes.
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • Options
    adiadi Member Posts: 8
    Thx for your reply
Sign In or Register to comment.