Knowledge Base

Probelm with Column Heading in Customer Select Choices

Hint Ref: 020911270006
Hint Date: 27/11/2009

Hint Details:

Problem:

 

When adding a new Customer Select Choices layout, a customer found that the Column headings were not displaying correctly, with some column headings being repeated. In addition, on some occasions the customer select display had random characters in some columns.

Solution:

Firstly, please note that ALL items that are not just simple field names MUST have an alias name ('as soemthingorother').
Secondly, make sure that there are NO trailing spaces at the end of the SQL statement for each item.

(Please Note: This Procedure can be destructive and should only be used by Advanced Users.  RADical Systems (UK) Limited or its Partners cannot be held responsible, in anyway, for any consequence of using this or any other Database Function, Procedure or SQL command.  Responsibility resides solely with the user.  

IT IS HIGHLY RECOMMENDED THAT A FULL AND VALID SPACE MANAGER DATABASE BACKUP IS TAKEN AND VERIFIED AS VALID BEFORE MAKING ANY CHANGES TO THE DATABASE.)