Author Topic: sqlite and EA  (Read 2293 times)

kalbun

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
sqlite and EA
« on: December 27, 2004, 04:39:23 am »
I'm using EA to generate tables for sqlite.
After some minimal work in the "database datatype" dialog box, I can generate SQL scripts to create tables.
There is a problem, yet, related with the creation of primary keys.
Indeed uses ALTER TABLE to add a constraint to the primary key, while sqlite uses a different syntax (appending PRIMARY KEY after the field definition).
This means that scripts must be modified by hand and then executed with sqlite. It would be great if this issue could be addressed in a future release.