Are there any rules to follow when creating my Database?
Avoid names that have any possible resemblance to what might be reserved words in a programming language. The SQL language which is what ASaP uses to connect to the different database types will have conflicts with the following list below. These are reserved for the SQL language to perform functions. To help alleviate this problem simply add something to the beginning of your fieldname. For example if your fieldname is called NAME then change it to myNAME or my_NAME.
Reserved SQL words:
NAME
STATE
LIST
FIELD
CLASS
LOCATION
ADD
ALL
ALTER
AND
ANY
AS
ASC
AUTOINCREMENT
AVA
BETWEEN
BINARY
BIT
BOOLEAN
BY CREATE
BYTE
CHAR
CHARACTER
COLUMN
CONSTRAINT
COUNT
COUNTER
CURRENCY
DATABASE
DATE
DATETIME
DELETE
DESC
DISALLOW
DISTINCT
DISTINCTROW
DOUBLE
DROP
EXISTS
FROM
FLOAT
FLOAT4
FLOAT8
FOREIGN
GENERAL
GROUP
GUID
HAVING
Reserved SQL words
continued:
INNER
INSERT
IGNORE
IMP
IN
INDEX
INT
INTEGER
INTEGER1
INTEGER2
INTEGER4
INTO
ISJOIN
KEY
LEFT
LEVEL
LIKE
LOGICAL
LONG
LONGBINARY
LONGTEXTMAX
MEMO
MIN
MOD
MONEY
NOT
NULL
NUMBER
NUMERIC
OLEOBJECT
ON PIVOT
ORDER
OUTER
OWNERACCESS
PARAMETERS
PERCENT
REAL
REFERENCES
RIGHT
SELECT
SET
SHORT
SINGLE
SMALLINT
SOME
STDEV
STDEVP
STRING
SUM
TABLE
TABLEID
TEXT
TIME
TIMESTAMP
TOP
TRANSFORM
UNION
UNIQUE
UPDATE
VALUE
VALUES
VAR
VARBINARY
VARCHAR
VARP
WHERE
WITH
YESNO