Level Check question

[Guest.Visitor]

Will what generate a level check? My notes say changing the select/omit will not change the level ID. But this is an SQL forum so what would it matter? Chris

[Guest.Visitor]

Chris, This is the "database" forum, not just SQL, so it does matter. chuck Opinions expressed are not necessarily those of my employer. "Chris Ringer" wrote in message news:6ae9c7e2.0@WebX.WawyahGHajS... > Will what generate a level check? My notes say changing the select/omit will not change the level ID. But this is an SQL forum so what would it matter? > > Chris

[Guest.Visitor]

My eyes must be failing me! I see your message posted under "Forums > Programming > SQL". When I click on "Forums > Database", your message doesn't appear there. Chris

[Guest.Visitor]

Chris, I only use Outlook Express to access these forums. That's the hazard MCPress has with a web-based version also, they aren't necessarily in sync. chuck Opinions expressed are not necessarily those of my employer. "Chris Ringer" wrote in message news:6ae9c7e2.2@WebX.WawyahGHajS... > My eyes must be failing me! I see your message posted under "Forums > Programming > SQL". When I click on "Forums > Database", your message doesn't appear there. > > Chris

[Guest.Visitor]

Chuck, You should be fine and not encounter a level check. Frank

[JohnJoe1011]

Chuck, the only thing that changes the causes a level check is when you add a new field, change the size of an existing field, remove a field, or change the attribute of a numeric pack field to signed numeric. In other words when the layout of the file is change. John

[Guest.Visitor]

If I change a logical file to exclude records (where before it didn't exclude records) and run a CHGPF against the DDS to change the logical, will it generate a level check? TIA, chuck Opinions expressed are not necessarily those of my employer.

[Guest.Visitor]

...or rename the record format, or rename a field or change the order of the fields or change the number of decimal positions in a field. Chris