If a custom layout is defined and is available for all users the layout of the

If a custom layout is defined and is available for

This preview shows page 2 - 4 out of 4 pages.

If a custom layout is defined and is available for all users, the layout of the fields in the custom data model itself has no significance. The custom layout totally redefines the page and grouping structure, there the built-in fields and custom fields can be intermixed freely. Custom indexes In addition to new fields, the custom data model can contain database indexes. These are defined with the DBINDEX statement. The indexed columns can be either from the custom data model itself or built-in, also in any combination, as long as there is not already a built-in index for the same column combination. A custom index may be useful for reducing database load or for defining an additional uniqueness constraint to columns or their combinations. Custom tables The Anygraaf system also allows users to define entire database tables. When a new object is added to the Tables list in the Database window of UserManager, the object is created with the parameters of a user-defined table. For such tables, the table name always has prefix UT_, the class name begins with User., and SUPPORTSUSERFIELDS has value 2. The class and table name prefixes guarantee that the class name will not conflict with any predefined table. Thus the actual class name after the User. prefix can be chosen freely as long as it is unique among all custom tables. Like custom fields, custom tables are defined using the data model language . All the data model statements that are allowed for custom fields are also allowed for custom tables. In addition, ID fields are possible for custom tables, and statements CLASSUINAME , UIINFO , and SELECTIONINFO have now relevance.
Image of page 2
Anygraaf Neo System Configuration Guide Custom tables and fields The data model of a custom table defines the default layout for the editing window. Custom layouts can be defined for custom tables just as for predefined tables. Custom tables cannot currently have an archive table. If some data model has a field that refers to a custom table, the full name of the target class must be used, i.e., the prefix User. must be included. Custom fields and indexes in offline editing The Neo application has an offline editing feature, which stores local copies of articles and topics in a local database (“My Database”) on the workstation. The local database contains only a subset of all tables. Of the custom fields, only those which do not refer to any other table are included in the local database. Initial values for custom fields The custom fields are often added to tables that already contain data, and new fields may also be added to custom tables. Fields that have NOT NULL constraint in database should always have an InitialValue setting to specify the value by which existing rows in the new column are initialized.
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 4 pages?

  • Summer '18

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors