| Hello, I'm trying to deploy a project that I have on my developement machine on my server but am having trouble creating my EO Tables on the server machine using EO Modeler. I have installed the same version of Eclipse and WOLips on both machines, and imported my project into the workspace on my server machine.
On my development machine I can use EO modeler to create my tables fine with Frontbase. However, when I try to do this on my server machine using the same eomodel file, I get a series of errors when I execute the SQL generated by EO modeler, and two of my tables don't get created. The errors I get are:
Syntax error 180. Illegal Direct SQL statement Syntax error 144. Illegal or missing base table element. When I just try to create just one of the problem tables I get the same errors.
This is the SQL that EOModeler generates for me for one of the tables that causes the errors:
CREATE TABLE t_team_popup (c_combo_index INTEGER NOT NULL, comboTeamID INTEGER NOT NULL, group INTEGER NOT NULL, id INTEGER NOT NULL, c_pool_type INTEGER NOT NULL, c_seed INTEGER NOT NULL, c_team_id INTEGER NOT NULL, c_team_pos INTEGER NOT NULL);
/* The 'Create Primary Key Support' option is unavailable. */;
ALTER TABLE t_team_popup ADD PRIMARY KEY (id);
ALTER TABLE t_team_popup ADD CONSTRAINT t_team_popup_comboTeam_FK FOREIGN KEY (comboTeamID) REFERENCES t_combo_team (id);
Any ideas?
Thanks, Jeff |