Re: Best way to use raw SQL

2014-10-23 Thread Johann Werner
Hi Thomas, look at ERXJDBCUtilities and ERXEOAccessUtilities for plenty of methods like: ERXJDBCUtilities.executeUpdate(EOAdaptorChannel channel, String sql) ERXEOAccessUtilities.evaluateSQLWithEntity(EOEditingContext ec, EOEntity entity, String sql) There should be something suiting your needs

Best way to use raw SQL

2014-10-23 Thread Thomas LATTER
Hi, what would be the best way to query in SQL these days in Project Wonder ? I would like to use SQL directly sometimes for complex queries including calculations (averages, medians..). Some of the previous solutions are deprecated. Thanks in advance __