Hi,
The function
qx::dao::create_table is just used to build prototype using SQLite database.
This function must not be used for a commercial application : just to create quick examples.
All other SQL queries (
SELECT,
INSERT,
UPDATE,
DELETE) should work correctly with MS SQL Server.
To create your SQL schema, I strongly recommend to use a tool provided by your SGBD.
But you can also write your own function using introspection engine of QxOrm library, it's quite easy to do, you have an example provided by
dodobibi for a commercial application using a PostgreSQL database :
http://www.qxorm.com/qxorm_en/faq.html#faq_230You can also see another example with the function
qx::QxClassX::dumpSqlSchema() :
http://www.qxorm.com/qxorm_en/resource/ ... chema.htmlhave anybody used QxORM in commercial applications?
Yes you can find some examples of commercial application (using SQLite, MySQL, PostgreSQL and Oracle) into this forum and the french forum here :
http://www.developpez.net/forums/f1563/ ... ues/qxorm/But for MS SQL Server, I don't know (but I'm pretty sure yes).
Anyway, QxOrm library builds standard SQL queries (except for table creation), and if MS SQL Server supports standard SQL queries, it will be no problem (there is a SQL generator for database specific cases :
http://www.qxorm.com/doxygen/html/dir_6 ... 0e447.html).
Using ODBC driver (this is your case), you must define this SQL generator like this :
- Code: Select all
qx::QxSqlDatabase::getSingleton()->setSqlGenerator(new qx::dao::detail::QxSqlGenerator_MSSQLServer());