Entity Developer generating wrong script for SQLITE
Posted: Wed 12 Feb 2014 06:41
Hi,
I just downloaded EntityDAC and before connecting to any database I thought in creating a SQLite database as it's simpler than any other database for tests.
I opened via Entity Developer the EntityDemo and chose to Update Database from Model. Before that I created the connection to SQLite (creating a new file), but when executing the wizard I'm getting error "SQLite Error near "CHAR": syntax error" when executing the script generated to create the tables.
If I'm not wrong the script generated is wrong because there should be no CHAR after the field size.
Thx
I just downloaded EntityDAC and before connecting to any database I thought in creating a SQLite database as it's simpler than any other database for tests.
I opened via Entity Developer the EntityDemo and chose to Update Database from Model. Before that I created the connection to SQLite (creating a new file), but when executing the wizard I'm getting error "SQLite Error near "CHAR": syntax error" when executing the script generated to create the tables.
If I'm not wrong the script generated is wrong because there should be no CHAR after the field size.
Code: Select all
-- Script was generated by Devart Entity Developer, Version 5.7.290.0
-- Script date 12/02/2014 17:33:26
-- Target Server: SQLite
-- Server Version: 3.7
--
-- Creating a table "main".DEPT
--
CREATE TABLE "main".DEPT (
DEPTNO INTEGER PRIMARY KEY AUTOINCREMENT,
DNAME VARCHAR2(14 CHAR),
LOC VARCHAR2(13 CHAR)
);
...
