Table structure diff. between Obj. Designer and SQL Server

adi
adi 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

  • Rob_Hansen
    Rob_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
  • RobertMo
    RobertMo 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           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • adi
    adi Member Posts: 8
    Thx for your reply

Categories