Page 1 of 1

Advanced relation

PostPosted: Fri Apr 29, 2011 6:20 am
by Guest
Hi,
I would like to create thi kind of SQL query: "select * from (A inner join B on A.F2=B.F1) inner join C on B.F2=C.1 where C.F1=1 and A.F4=4". Is it possible to create this with QxOrm? Is there any sample to do this?
Thanks

Re: Advanced relation

PostPosted: Fri Apr 29, 2011 6:34 am
by Guest
I think about to create a view in the database and create a new class wrapping this new view.

Is there another solution through QxOrm only?

Re: Advanced relation

PostPosted: Mon May 02, 2011 7:51 am
by QxOrm admin
Hi,

You cannot build this kind of SQL queries with QxOrm : you have to execute your query with QtSql module or create a view in your database.