If you're using WO 5.4, SQL generation doesn't work with EM until 5.4.2.
ms
On Jun 13, 2008, at 1:46 PM, Klaus Berkling wrote:
> Anyone seen this? Can't just be me.
>
> The SQL generated by Entity Modeler puts quotes around the column
> names and MySQL does not seem to like it.
>
> Works:
> CREATE TABLE Country (_id INT NOT NULL);
>
> Does not:
> CREATE TABLE Country ("_id" INT NOT NULL);
>
> ERROR 1064 (42000) at line <n>
>
> MySQL:
> mysql Ver 14.12 Distrib 5.0.51a, for apple-darwin8.5.1 (i686) using
> readline 5.0
>
> Eclipse:
> Version: 3.3.2
> Build id: M20080221-1800
>
> WOLips:
> First seen in 5047 and reproduces in 5233
>
> Thanks
>
> kib
>
> "Success is not final, failure is not fatal: it is the courage to
> continue that counts.”
> - Winston Churchill
>
> Klaus Berkling
> Systems Administrator
> DynEd International, Inc.
> www.dyned.com | www.eskimo.com/~kiberkli
>
>
>
This archive was generated by hypermail 2.0.0 : Fri Jun 13 2008 - 16:56:09 EDT