#17 Create Tables Script has invalid DDL for MySQL 5

[Jim Doyle]

CREATE TABLE TBL_RFS_FIELDSELECTION
(
RECORDID integer,
CHILD_KEY smallint,
FIELD_NO smallint,
BOOLEAN_OPERATOR smallint,
FIELD_NAME varchar,
OPERATOR char(2),
FIELD_VALUE varchar
)
;
** Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' OPERATOR char(2), FIELD_VALUE varchar )' at line 1

---

Solution: Add field limits:
CREATE TABLE TBL_RFS_FIELDSELECTION
(
RECORDID integer,
CHILD_KEY smallint,
FIELD_NO smallint,
BOOLEAN_OPERATOR smallint,
FIELD_NAME varchar(255),
OPERATOR char(2),
FIELD_VALUE varchar(255)
);

[Bruce Martin]

Will do

[Bruce Martin]

A hack that may work is The Sql is stored in

• Windows: C:\Program Files\RecordEdit\Generic\SQL\Create_RecordEdit.Sql

• Linux: <home>/RecordEdit/Generic/SQL/Create_RecordEdit.Sql</home>

  So it can be updated.

  In the RecordEditor lib directory there is a bat / shell script runGenericInstall.bat/sh that will run the installer again

  RecordEditor lib directory: C:\Program Files\RecordEdit\Generic\lib
  or <home>/RecordEdit/Generic/lib/</home>