What would you like to know more about?

DBISAM Engine Error #11949 -Alumni Report

Alumni Report

When trying to preview or print the Alumni Report in HeadMaster, this error displays "Dbisam engine error #11949 sql parsing error--expected column name, but instead found field 1 in select sql statement at line 3, column 3"

  • Products Affected: HeadMaster (All)

  • Versions Affected: 11.5.1.5

  1. Create a HeadMaster Backup.
  2. Access the USERDEF.ACSDAT table for the Current data set and the System data set.
  3. The UDType field Alumni has field names such as Field 1, Field 2, Field 3, etc. Delete those fields. but only delete field names that include the word field and a number.
    Tip: Examples of some field names for Alumni are Enroll Date, Withdrew, Father, and Mother. To see which Alumni custom fields need to be in the userdef table before deleting, go to Options/Custom and select the Alumni type. Only the fields needed in the table display.
  4. To locate the custom fields, on the Home page, click Options, then Custom.
  5. Click the Type list and select an individual type (Student, Teacher, etc.). The custom field displays on the individual window for the type you select.
    Figure 1. Custom Fields