Table structure diff. between Obj. Designer and SQL Server

adi

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

Rob_Hansen

When you check the properties of those "invisible" fields in Design mode for the Table, is the Enabled property set to No?

RobertMo

Check the class of fields. "FlowFilters" do not contain any values. Read in Application Designer's Guide about different filed classes.

adi

Thx for your reply