qxBlog Bug in ODBC/MS SQL/ QxORM in commercial application
Posted: Thu Apr 12, 2012 12:12 pm
I am looking for a good ORM for our commercial application. That's why I am here with QxORM.
I tried to build and run qxBlog application from the tutorial against ODBC driver to MS SQL Server.
The first create table operator generated by (qx::dao::create_table<author>();) was translated to the following SQL command:
CREATE TABLE author (author_id TEXT NOT NULL PRIMARY KEY, name TEXT, birthdate DATE, sex INTEGER)
That is wrong for MS SQL: Column 'author_id' in table 'author' is of a type that is invalid for use as a key column in an index.
I am disappointed...
So my question: have anybody used QxORM in commercial applications? What ist your experience?
I tried to build and run qxBlog application from the tutorial against ODBC driver to MS SQL Server.
The first create table operator generated by (qx::dao::create_table<author>();) was translated to the following SQL command:
CREATE TABLE author (author_id TEXT NOT NULL PRIMARY KEY, name TEXT, birthdate DATE, sex INTEGER)
That is wrong for MS SQL: Column 'author_id' in table 'author' is of a type that is invalid for use as a key column in an index.
I am disappointed...
So my question: have anybody used QxORM in commercial applications? What ist your experience?