When using external SQL databases in conjunction with Askia, you must abide by certain conventions when naming databases tables, and fields, as follows:
Names are case-sensitive;
The following special characters are not allowed database, table or field names: . / * ; : ! # & - ? " ' $
Space characters are not allowed in database, table or field names;
Reserved words (see below) must not be used for database, table or field names.
Reserved words are words that have a specific grammatical meaning within a particular technical context, and cannot be used as names. In SQL, a field cannot be called "DATE", for example, because that word is used in SQL queries to refer to dates. Instead, you might name your field "InterviewDate" to avoid using a reserved word.
At the time of writing, the SQL reserved words are as listed below, but they can change in subsequent versions, so we advise you to check Microsoft's list of reserved words. (Link will open a new window).
List of reserved words:
|
ADD AND ANY BETWEEN BIT BOOLEAN BYTE CHAR CHARACTER COLUMN |
DATABASE DATE DELETE DESC Else End FALSE Field, Fields FROM If |
IGNORE INDEX INSERT INTO IS KEY NAME NO NULL NUMBER |
NUMERIC Object Parameter Property Query SELECT SET STRING TABLE UPDATE |
USER VALUE VERSION WHERE WITH Workspace |