PDA

View Full Version : Catalog Section Table


Chuckie
30-Nov-2003, 04:14 PM
I have been looking the Catalog Section table in access and if i move the sections round in actinic my database tends to replace all the numbers in the following two columbs with 0's

nPrintSequence & nPrintLevel

but when you load actinic up, it still knows where each section has to go with out these numbers. Is there any other numbers in the database that actinic uses to reference where sections go ?

NormanRouxel
30-Nov-2003, 04:44 PM
In Table Catalog section I think it's nSectiondID that uniquely defines the Section. nParentSectionID that refers to the Parent Section (by it's nSectiondID) and Catalog section sequence that defines the order of the sub-sections (sections where nParentSectionID is the identical).

You should also pay some attention to Status as this is normally "N" but will change for deleted (but not Purged) sections.

Those are the 4 fields I used when writing NorTree that has to generate a section tree for Actinic 4 users who don't have access to the Actinic 5 onwards generated sectiontree structures.

Norman

Jan
02-Dec-2003, 06:40 AM
nPrintSequence & nPrintLevel are used by printing and are set on each print or preview for a catalog summary or catalog detail report. You don't have to worry about those.

Regards,

Chuckie
02-Dec-2003, 09:39 AM
I use these two columbs to build my pdf catalog up on the internet, are these details wrote to the db every time i do a print preview ?

Jan
02-Dec-2003, 11:33 AM
Yes.