Hello, Some changes are needed in the design of Wt::Dbo to make it working with other backends. The problem is that sqlite specific syntax is deeply hardcoded, particulary the quote arround table and collumn names. Mysql does not like syntax with quote.
create table "name" ... I see too unblocking solutions: * write complex code to remove the quotes from the sql commands like create table, on the constructor of the derived MysqlStatement class, * or to patch the Wt code by removing tho quotes from the generated statements. * a more complicated and uggly solution would be to provide furthe virtual functions for SqlStatement for each method that is syntax dependent, etc. etc. I looked at the syntax of sqlite, and they do not require quotes arround the names. Maybe the quotes would be needed if table or column name would contain space, but such names with spaces are in my opinion are bad practice... -- rgrds, mobi phil being mobile, but including technology http://mobiphil.com ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ witty-interest mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/witty-interest
